topic Re: Lakehouse SQL Endpoint: OPENROWSET - Support for FORMAT = 'DELTA' when reading from ADLS data so in Data Engineering

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

mb_ — Mon, 27 Oct 2025 18:21:38 GMT

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')

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

vrsanaidu2025 — Mon, 27 Oct 2025 19:02:04 GMT

yes,

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

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

v-veshwara-msft — Fri, 31 Oct 2025 12:26:44 GMT

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.

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

mb_ — Fri, 31 Oct 2025 15:46:40 GMT

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.