Is DAB supports Azure Synapse dedicated sql pool?

[Madhan-Rommala]

Hi Guys, I just wanted to understand that is DAB supports Azure Synapse dedicated sql pool? can we created API endpoints on Azure Synapse DB's?

[Aniruddh25]

Hi @Madhan-Rommala,
DAB does not support dedicated sql pool yet since as of now we rely on the FOR JSON PATH clause to format the response as JSON for Azure SQL DB as per the docs here: https://learn.microsoft.com/en-us/sql/relational-databases/json/format-query-results-as-json-with-for-json-sql-server?view=azuresqldb-current

Thanks
Aniruddh.

[Narming1868]

Hi, is this also causing the error message?
{
"error": {
"code": "DatabaseOperationFailed",
"message": "'FOR' clause is not supported in this version of Synapse SQL.",
"status": 500
}
}

Thanks for your help.