Azure synapse serverless external table for json

Question

From the MSDN library, it says

So is it still possible to create external table for a json ?

The following has a work around using openrowset , but still using format as CSV..
https://learn.microsoft.com/en-us/azure/synapse-analytics/sql/query-json-files

and what's the meaning of

    fieldterminator ='0x0b',  
    fieldquote = '0x0b',  
    rowterminator = '0x0b'   

Answer 1

@sakuraime Thanks for using Microsoft Q&A !!
It is not supported and like you mentioned you could use Openrowset and Cross Apply OPENJSON to achieve the same. I would recommend creating a feature request on Azure Synapse Analytics User Voice.

Also, 0x0b is hex code for the vertical tab (new line).

----------

Please do not forget to "Accept the answer" wherever the information provided helps you to help others in the community.