{"active":true,"blog_title":"Read JSON Lines files with OPENROWSET in Fabric Data Warehouse and Lakehouse SQL Analytics Endpoint","blog_url":"https://community.fabric.microsoft.com/blog/fbc_fabricupdatesblogs/read-json-lines-files-with-openrowset-in-fabric-data-warehouse-and-lakehouse-sql/5172652","feature_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')```","feature_name":"OPENROWSET(JSONL)","last_modified":"2026-06-16","product_id":"fa3a73cd-dcd6-ee11-9079-000d3a310f67","product_name":"Data Warehouse","release_date":"Q4 2025","release_item_id":"65cd5ddb-28a8-f011-bbd3-000d3a30273e","release_status":"Shipped","release_type":"General availability"}