Azure Synapse analytics with CosmosDB query is giving null values

Question

Hi Team,

we are storing data in Azure cosmos db for mongo and trying to query from Azure synapse serverless pool.when we query with Query items with full fidelity schema we are getting the values else we are getting string:value.

can you please help us how to get value with out full fidelity schema.We have some key with int and float values for same key when i mention value.Int we are getting nulls for float values.

Thanks.

Answer 1

Hello Sathya Sai Cheetirala,

The behavior you are seeing is related to how you setup the Cosmos DB account, either using Well-defined or Full fidelity schema.

Please see the below document for your reference:

https://learn.microsoft.com/en-us/azure/cosmos-db/analytical-store-introduction#schema-representation