Skip to main content

Synapse

New

Expose access to INFORMATION_SCHEMA within Lakehouse

Vote (7) Share
Jonathan Boarman's profile image

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 view INFORMATION_SCHEMA.VIEWS cannot be found. Please verify the spelling and schema correctness.