OPENROWSET(JSONL)

Data Warehouse · General availability · Shipped

Data Warehouse General availability Shipped
Last Modified: April 16, 2026 Release Date: Q3 2025

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

📰 Related Blog Article

Query and ingest JSONL files in Data Warehouse and SQL Analytics Endpoint for Lakehouse (Generally Available)
🔗 blog.fabric.microsoft.com

Change History

  1. 2026-04-16
    Release Type Public preview -> General availability
  2. 2025-07-09
    Roadmap Item Added
← Back to Roadmap 👁️ Watch this Feature View API JSON Workload: Data Warehouse