Forum Discussion

cadams123's avatar
cadams123
New Member
4 months ago
Solved

INFORMATION_SCHEMA

Hi all, I’m currently migrating tables from Oracle into Microsoft Fabric (Lakehouse) and I’m trying to show progress / coverage of the migration to management.   What I’m trying to achieve The req...
data engineering
Lakehouse
  • nilendraFabric's avatar
    nilendraFabric
    4 months ago

    Hi cadams123 

     

    INFORMATION_SCHEMA in Fabric’s SQL analytics endpoint is a read-only system catalog that can’t be joined to Lakehouse Delta tables or materialized via CTAS . that’s by design, not a bug.

     

    The standard workaround is to snapshot the metadata into a Delta table so you can join it with your Oracle metadata normally.

     

    The spark.catalog.listTables() approach in a notebook remains your best bet for snapshotting Fabric metadata into a joinable Delta table.

     

     

nilendraFabric's avatar
nilendraFabric
Super User
4 months ago

Hi cadams123 

 

INFORMATION_SCHEMA in Fabric’s SQL analytics endpoint is a read-only system catalog that can’t be joined to Lakehouse Delta tables or materialized via CTAS . that’s by design, not a bug.

 

The standard workaround is to snapshot the metadata into a Delta table so you can join it with your Oracle metadata normally.

 

The spark.catalog.listTables() approach in a notebook remains your best bet for snapshotting Fabric metadata into a joinable Delta table.