Microsoft Fabric Updates Blog

OPENROWSET function in Fabric Data Warehouse (Generally Available)

The OPENROWSET function is generally available in Fabric Data Warehouse and Fabric SQL endpoints for Lakehouse and Mirrored databases. The OPENROWSET function enables you to easily read Parquet and CSV files stored in Azure Data Lake Storage and Azure Blob Storage: With the OPENROWSET function, you can easily browse files before loading them into the … Continue reading “OPENROWSET function in Fabric Data Warehouse (Generally Available)”

Spatial queries in Fabric Data Warehouse

Spatial data has become increasingly important in various fields, from urban planning and environmental monitoring to transportation and logistics. Fabric Data Warehouse offers spatial functionalities that enable you to query and analyze spatial data efficiently. In this blog post, we will delve into the spatial capabilities in the Fabric Data Warehouse and demonstrate how to … Continue reading “Spatial queries in Fabric Data Warehouse”

BULK INSERT in Fabric Data Warehouse

We are excited to announce that the BULK INSERT statement in available in Fabric Data Warehouse. The BULK INSERT statement allows you to load CSV files from Azure Data Lake Storage and Azure Blob Storage. Refer to the example of the traditional BULK INSERT statement commonly used by SQL Server or Azure SQL users to … Continue reading “BULK INSERT in Fabric Data Warehouse”

Fabric OPENROWSET function

We are excited to announce the availability of the OPENROWSET function in the Fabric Data Warehouse and SQL endpoint for Lakehouse. This powerful function allows you to read the content of external files stored in Azure Data Lake Storage and Azure Blob Storage without the need to ingest them into the Data Warehouse. With the … Continue reading “Fabric OPENROWSET function”

JSON aggregates in Fabric Datawarehouse (Preview)

The preview for JSON aggregate functions in Fabric Datawarehouse has begun. You can now take advantage of two powerful JSON aggregate functions during this preview period. The preview for these two aggregate functions is already live in Azure SQL Database, and we are excited to announce that it is now also available in Fabric Data … Continue reading “JSON aggregates in Fabric Datawarehouse (Preview)”