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.
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.