Jovan Popovic announces that JSONL format support is now generally available in Microsoft Fabric:
The OPENROWSET function that can read JSONL format empowers you to easily read and ingest JSONL files – for example log files, social media streams, machine learning datasets, configuration files, and other semi-structured sources. With the versatile OPENROWSET T-SQL function, you can reference and query JSONL files as if they were tables, eliminating the need for manual parsing or complex transformation steps.
Read on to see examples of how to ingest and use data in the JSON Lines format.