Share via

Using JSON AUTO in Azure Synapse Analytics SQL pool

Shafique 27 Reputation points
2021-01-22T17:05:26.703+00:00

Hi all,

I am working with JSON data in SQL Server using Synapse Analytics. The following query is returning syntax error
SQL Error [103010] [S0001]: Parse error at line: 4, column: 1: Incorrect syntax near 'FOR'.

SELECT TOP 5 [qualifier], [textline]
FROM [intg].TestTable
FOR JSON AUTO

Not sure if JSON AUTO is supported. Has anyone used it in Synapse?

Thanks,
Shafique

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.

SQL Server | Other

Answer accepted by question author

  1. Erland Sommarskog 133.9K Reputation points MVP Volunteer Moderator
    2021-01-22T22:31:24.953+00:00

    Indeed, it does not seem to be your lucky day. Look here:
    https://learn.microsoft.com/en-us/sql/t-sql/queries/select-for-clause-transact-sql?view=sql-server-ver15
    Synapse is not listed, so you cannot do FOR JSON or FOR XML on Synapse.

    Was this answer helpful?

1 additional answer

Sort by: Most helpful
Most helpful Newest Oldest
  1. HimanshuSinha 19,597 Reputation points Microsoft Employee Moderator
    2021-01-22T23:22:19.44+00:00

    Hello @Anonymous ,
    Thanks for the ask and using the forum .
    At this time FOR JSON AUTO is not supported by Synaspse .

    May I request you to please log the ask here . The feature ask are reviewed by the product group and this should help them .

    Thanks
    Himanshu

    Was this answer helpful?

Your answer

Answers can be marked as 'Accepted' by the question author and 'Recommended' by moderators, which helps users know the answer solved the author's problem.