Forum Discussion

Etc's avatar
Etc
Frequent Visitor
2 years ago

FOR JSON Path in Fabric Warehouse

Hi,   I have noticed that the FOR JSON statement is not supported in Fabric Synapse, and was wondering if there is any alternative to it? I am working on a Stored Procedure that will be used in ...
data engineering
Data Integration
data warehouse
v-cboorla-msft's avatar
v-cboorla-msft
Microsoft Employee
2 years ago

Hi Etc 

 

I have checked with the internal team.

Apologies for the issue and delay in the response. JSON types and JSON functions are not supported in warehouse in Fabric currently. This is not supported.

But you could share your feedback on our feedback link which would be open for the user community to upvote & comment on. This allows our product teams to effectively prioritize your request against our existing feature backlog and gives insight into the potential impact of implementing the suggested feature.

Feedback Link : Home (microsoft.com)

 

Thank you.

  • abhidotnet's avatar
    abhidotnet
    Advocate II
    8 months ago

    Similarly, FOR XML isn't supported either.


    If you attempt to use it in a SQL query on the Fabric warehouse, you get this error:



    Msg 15868, Level 16, State 12, Line 3
    FOR XML is not supported.