question

sakuraime avatar image
0 Votes"
sakuraime asked SaurabhSharma-msft commented

Azure synapse serverless external table for json

From the MSDN library, it says
78655-image.png




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://docs.microsoft.com/en-us/azure/synapse-analytics/sql/query-json-files


and what's the meaning of

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




azure-synapse-analytics
image.png (69.3 KiB)
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

1 Answer

SaurabhSharma-msft avatar image
0 Votes"
SaurabhSharma-msft answered SaurabhSharma-msft commented

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

· 2
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

@sakuraime Please let me know if you find above reply useful. If yes, do click on 'Mark as answer' link in above reply. This will help other community members facing similar query to refer to this solution. Thanks.

0 Votes 0 ·

@sakuraime I have not heard back from you. Did my answer solve your issue? If so, please mark as accepted answer. If not, please let me know how I may better assist.

0 Votes 0 ·