{"active":true,"blog_title":"Query and ingest JSONL files in Data Warehouse and SQL Analytics Endpoint for Lakehouse (Generally Available)","blog_url":"https://blog.fabric.microsoft.com/en-us/blog/query-and-ingest-jsonl-files-in-data-warehouse-and-sql-endpoint-for-lakehouse-general-availability","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":"2025-10-13","product_id":"fa3a73cd-dcd6-ee11-9079-000d3a310f67","product_name":"Data Warehouse","release_date":"2025-10-07","release_item_id":"65cd5ddb-28a8-f011-bbd3-000d3a30273e","release_status":"Shipped","release_type":"General availability"}