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.

     

     

v-priyankata's avatar
v-priyankata
Community Support
4 months ago

Hi cadams123 

Thank you for reaching out to the Microsoft Fabric Forum Community.

nilendraFabric Thanks for the inputs.

I hope the information provided by user was helpful. If you still have questions, please don't hesitate to reach out to the community.

 

v-priyankata's avatar
v-priyankata
Community Support
4 months ago

Hi cadams123 

Hope everything’s going smoothly on your end. I wanted to check if the issue got sorted. if you have any other issues please reach community.