OPENROWSET
Data Warehouse · General availability · Shipped
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.
Change History
-
2025-04-07
Roadmap Item Added
Workload: Data Warehouse