{"active":true,"blog_title":"Announcing improved JSON support in Fabric DW","blog_url":"https://blog.fabric.microsoft.com/en-us/blog/announcing-improved-json-support-in-fabric-dw","feature_description":"JSON support in Fabric Datawarehouse enables processing of textual data formatted as JSON text. The new JSON features in Fabric DW are:* 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.* 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), Fabric DW is suporting the latest JSON functions that exist in Azure SQL Database - JSON_PATH_EXISTS, JSON_OBJECT, and JSON_ARRAY.","feature_name":"JSON support","last_modified":"2024-10-29","product_id":"fa3a73cd-dcd6-ee11-9079-000d3a310f67","product_name":"Data Warehouse","release_date":"2024-10-29","release_item_id":"1f690b06-ce80-ef11-ac21-6045bd062aa2","release_status":"Shipped","release_type":"General availability"}