Query Azure Cosmos DB using serverless SQl pool in synapse analytics
Budget: $10 – $30 USD
I created a SQL query to pull records from the synapse serverless pool. Unfortunately, I had an issue with the result set. The return type is an array and needs to format the result into JSON. I have attached a screenshot that shows the query. Anyone with a solution is appreciated