Hello @jduong
No this is not the case. In fact the order of the databases that are missing corresponds with the log file errors for “failed to fetch schema for…”.
e.g. BASE_AG4 is skipped before master, then model is skipped.
The SCORD databases are indeed missing, but are only a few of missing databases. Also SCMAT-NUM is being skipped even before the SCORD.
In SCMAT-NUM there are no special tables. I added the schema in export.zip (3,5 KB)
For BASE_AG4, it could, which is also skipped, could be expected, as in dbvisualizer (using the same mssql jdbc driver) the database is listed, but its schema cannot be read: because it is part of an availability group. However, it would be nice that Dremio can also notify when this is the case.
In DBVisualizer
An error occurred while performing the operation:
The target database, ‘BASE_AG4’, is participating in an availability group and is currently not accessible for queries. Either data movement is suspended or the availability replica is not enabled for read access.
For SCMAT-NUM I don’t get any errors in DBVisualizer.