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
Anonymous's avatar
Anonymous
Not applicable
2 years ago

Could we please get a reply on this topic? It seems like the confusing "SELECT - FOR (except JSON)" has just been removed from the documentation without any notice.

  • Etc's avatar
    Etc
    Frequent Visitor
    2 years ago

    We seem to have been a bit forgotten! Hopefully we'll get an answer soon

    • 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.