Azure Synapse analytics with CosmosDB query is giving null values

Sathya Sai Cheetirala 0 Reputation points
2024-06-25T12:09:20.5533333+00:00

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.

Screenshot from 2024-06-25 14-02-29

Azure Synapse Analytics
Azure Synapse Analytics
An Azure analytics service that brings together data integration, enterprise data warehousing, and big data analytics. Previously known as Azure SQL Data Warehouse.
4,646 questions
Azure Cosmos DB
Azure Cosmos DB
An Azure NoSQL database service for app development.
1,526 questions
{count} votes

1 answer

Sort by: Most helpful
  1. BhargavaGunnam-MSFT 28,926 Reputation points Microsoft Employee
    2024-06-25T18:15:08.1333333+00:00

    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

    0 comments No comments