Forum Discussion

mb_'s avatar
mb_
New Member
10 months ago
Solved

Lakehouse SQL Endpoint: OPENROWSET - Support for FORMAT = 'DELTA' when reading from ADLS data source

Using the OPENROWSET protocol to read from ADLS: Simplifying file access in OPENROWSET using data sources and relative paths (Preview) | Microsoft Fabric Blog | Microsoft Fabric The blog shows read...
lakehouse
  • v-veshwara-msft's avatar
    v-veshwara-msft
    10 months ago

    Hi mb_ ,

    Thanks for posting in Microsoft Fabric Community.

    At present, using OPENROWSET with FORMAT = 'DELTA' to read Delta tables from an ADLS data source is not supported in the Lakehouse SQL Endpoint. The current preview functionality supports formats like CSV, Parquet, and JSON when accessing files through OPENROWSET.

     

    The team is continuously working to expand format support, so this may become available in future updates.

    Reference: Browse File Content Before Ingestion with the OPENROWSET function - Microsoft Fabric | Microsoft Learn

     

    Hope this helps. Please reach out for further assistance.

    Thank you.

v-veshwara-msft's avatar
v-veshwara-msft
Community Support
10 months ago

Hi mb_ ,

Thanks for posting in Microsoft Fabric Community.

At present, using OPENROWSET with FORMAT = 'DELTA' to read Delta tables from an ADLS data source is not supported in the Lakehouse SQL Endpoint. The current preview functionality supports formats like CSV, Parquet, and JSON when accessing files through OPENROWSET.

 

The team is continuously working to expand format support, so this may become available in future updates.

Reference: Browse File Content Before Ingestion with the OPENROWSET function - Microsoft Fabric | Microsoft Learn

 

Hope this helps. Please reach out for further assistance.

Thank you.