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 reading from CSV in ADLS, is reading from Delta Table also supported?

csv:

SELECT * FROM OPENROWSET(BULK '/Files/data/2025/0 9/sales.csv', DATA_SOURCE = 'MyAdls')

delta:

SELECT * FROM OPENROWSET(BULK '/Files/data/2025/0 9/', DATA_SOURCE = 'MyAdls', FORMAT = 'DELTA')
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.

3 Replies

  • 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.

  • vrsanaidu2025's avatar
    vrsanaidu2025
    New Member
    10 months ago

    yes, 

    SELECT *
    FROM OPENROWSET(
    BULK '/Files/data/2025/09/',
    DATA_SOURCE = 'MyAdls',
    FORMAT = 'DELTA'
    )

  • mb_'s avatar
    mb_
    New Member
    10 months ago

    Appreciate the response v-veshwara-msft!

     

    Creating views against Delta tables would allow us to replicate our Synapse Serverless SQL databases in Fabric, so I would consider this a valuable feature for current Synapse users looking to migrate to Fabric.