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