Jonathan Boarman on 11 Jun 2024 00:14:33
In Databricks, as with most DBMS, one can query INFORMATION_SCHEMA.VIEWS
or INFORMATION_SCHEMA.COLUMNS
to access metadata about the delta tables.
However, attempting the same in Fabric presents this error:
[TABLE_OR_VIEW_NOT_FOUND] The table or viewINFORMATION_SCHEMA
.VIEWS
cannot be found. Please verify the spelling and schema correctness.