Query Azure Cosmos DB using serverless SQl pool in synapse analytics

Job ID: 32900696

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