Masukkan informasi Anda untuk berlangganan Blog Microsoft Fabric.

Terima kasih telah berlangganan Blog Microsoft Fabric. Anda akan menerima notifikasi email saat kami memublikasikan postingan baru.

Microsoft Fabric Updates Blog

  1. Pembaruan
  2. Jovan Popovic

Announcing improved JSON support in Fabric DW

We’ve improved the JSON support in Fabric Datawarehouse (Fabric DW) and have added the following features in Fabric DW:

  • Fabric DW enables you to use FOR JSON query option that formats the query results as JSON text. This was one of the features that is requested on Microsoft Fabric Idea site.
  • Fabric DW enables you to use all JSON scalar functions that can also be used in Azure SQL database. In addition to the existing JSON scalar functions (ISJSON, JSON_VALUE, JSON_QUERY, and JSON_MODIFY), we have added support for the latest JSON functions that exist in Azure SQL Database – JSON_PATH_EXISTS, JSON_OBJECT, and JSON_ARRAY.

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 scalar values without a need to concatenate and escape the values to produce a properly formatted JSON text.

In the following example you can see the new approach that you can use to create JSON objects in the queries:

Formatting without JSON_OBJECTFormatting with JSON_OBJECT
SELECT
     CONCAT('{"name:"', name, '",
              "size":"', size,'",
              "color":"', color,'"}')
FROM Product
SELECT
     JSON_OBJECT('name':name,
                 'size': size,
                 'color': color)
FROM Product
Formatting the vales in the rows as JSON

With the new approach, you don’t need to worry about pairing curly brackets and quotes to properly format JSON objects, and you don’t need to ensure that you are properly escaping the values before you concatenate them.

In addition to the new functionalities, we have enabled you to use the OPENROWSET function with CROSS/OUTER APPLY operator. This was one of the feature requests asked in Microsoft Fabric Idea site.

With these improvements, the JSON support in Azure SQL database and Fabric DW is aligned. You can easily migrate code between Azure SQL database and Fabric without the need to rewrite and modify your T-SQL logic.

Postingan blog terkait

Announcing improved JSON support in Fabric DW

Gambar unggulan blog

Expanding Real-Time Intelligence data sources with Cribl source (Preview)
Januari 20, 2026 berdasarkan Xu Jiang

The exchange of real-time data across different data platforms is becoming increasingly popular. The Cribl source (preview) is now available in Real-Time Intelligence, allowing real-time data to flow into Fabric RTI Eventstream through our collaboration with Cribl, enabling you to take full advantage of Fabric Real-Time Intelligence’s robust analytics tools for their real-time needs. Collaborating to broaden … Continue reading “Expanding Real-Time Intelligence data sources with Cribl source (Preview)”

Baca selengkapnya
Gambar unggulan blog

Simplifying data movement across multiple clouds with Copy job – Enhancements on incremental copy and change data capture
Januari 20, 2026 berdasarkan Ye Xu

Copy job is the go-to solution in Microsoft Fabric Data Factory for simplified data movement, whether you’re moving data across clouds, from on-premises systems, or between services. With native support for multiple delivery styles, including bulk copy, incremental copy, and change data capture (CDC) replication, Copy job offers the flexibility to handle a wide range … Continue reading “Simplifying data movement across multiple clouds with Copy job – Enhancements on incremental copy and change data capture”

Baca selengkapnya