Azure synapse serverless external table for json

sakuraime 2,321 Reputation points
2021-03-17T07:48:32.84+00:00

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://learn.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
Azure Synapse Analytics
An Azure analytics service that brings together data integration, enterprise data warehousing, and big data analytics. Previously known as Azure SQL Data Warehouse.
4,671 questions
0 comments No comments
{count} votes

1 answer

Sort by: Most helpful
  1. Saurabh Sharma 23,791 Reputation points Microsoft Employee
    2021-03-18T18:06:09.757+00:00

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