Update: Microsoft will be moving away from UserVoice sites on a product-by-product basis throughout the 2021 calendar year. We will leverage 1st party solutions for customer feedback. Learn more here.

Ali Shashaani

My feedback

  1. 196 votes

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)

    We’ll send you updates on this idea

    under review  ·  9 comments  ·  Azure Synapse Analytics » SQL/Table Structure  ·  Flag idea as inappropriate…  ·  Admin →
    An error occurred while saving the comment
    Ali Shashaani commented  · 

    Our need is to traverse complex, unpredictable JSON objects and pull out all elements, not matter how deeply nested they are, into a table of key-value pairs. A recursive CTE with cross application of OPENJSON table-valued function would elegantly take care of this. Pretty, please.

    Ali Shashaani supported this idea  · 

Feedback and Knowledge Base