{"active":true,"blog_title":"OPENROWSET function in Fabric Data Warehouse (Generally Available)","blog_url":"https://blog.fabric.microsoft.com/en-us/blog/the-openrowset-function-is-generally-available-in-fabric-data-warehouse","feature_description":"Fabric DW enables the users to use the OPENROWSET function to read data from the files in the lake. A simple example of OPENROWSET function is: ```sqlSELECT * FROM OPENROWSET ( BULK '<file path>' ) WITH ( <column definition> ) ``` The OPENROWSET function will read the content of the file(s) at the given `<file path>` and return the content of the files.Thi function enables easy browsing and previewing the files before ingestion.","feature_name":"OPENROWSET","last_modified":"2025-04-07","product_id":"fa3a73cd-dcd6-ee11-9079-000d3a310f67","product_name":"Data Warehouse","release_date":"2025-04-07","release_item_id":"585d3195-b880-ef11-ac21-00224804e9b4","release_status":"Shipped","release_type":"General availability"}