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”
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”
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)”
Fabric Data Warehouse is a modern data warehouse optimized for analytical data models, primarily focused on the smaller numeric, datetime, and string types that are suitable for analytics. For the textual data, Fabric DW supports the VARCHAR type that can store up to 8KB of text, which is suitable for most of the textual values … Continue reading “Announcing public preview of VARCHAR(MAX) and VARBINARY(MAX) types in Fabric Data Warehouse”
We’ve improved the JSON support in Fabric Datawarehouse (Fabric DW) and have added the following features in Fabric DW: The JSON_PATH_EXIST function checks if there is a value on the given path in JSON text. The JSON_OBJECT and JSON_ARRAY functions enable you to more easily create JSON objects or arrays based on a set of … Continue reading “Announcing improved JSON support in Fabric DW”
