OPENROWSET(JSONL)
Data Warehouse · General availability · Shipped
Description
The OPENROWSET(BULK) function allows you to query external data (such as CSV and Parquet files) stored in the lake using the T-SQL syntax. With JSONL support, you can now also query JSON Lines files, expanding the range of supported formats and simplifying access to semi-structured data. To read a JSONL file, use the existing OPENROWSET(BULK) syntax:```SELECT TOP 10 *FROM OPENROWSET( BULK 'https://pandemicdatalake.blob.core.windows.net/public/curated/covid-19/bing_covid-19_data/latest/bing_covid-19_data.jsonl')```
Change History
-
2025-10-13
Roadmap Item Added
Workload: Data Warehouse