Skip to main content

Data Warehouse

Planned

Add FOR JSON support in fabric warehouse

Vote (17) Share
Filip O's profile image

Filip O on 28 Nov 2023 19:13:33

The FOR JSON syntax in T-SQL is a powerful way to create json objects from select statements. This can be useful both to export data but also to pass parameters to for example Data factory if working with a metadata driven framework.


As this functionality is working in most Microsoft SQL offerings including Serverless SQL pools in Synapse, and I know a lot of organizations have built features around it. It would be great to add this functionality in Fabric Data Warehouse as well.

Administrator

This is in the works!

Comments (1)
Filip O's profile image Profile Picture

Sulagna Banerjee on 01 Nov 2024 13:49:39

RE: Add FOR JSON support in fabric warehouse

Any update on this? FOR JSON functions are very useful functions.