Hi In azure cosmos db what is the table format in container table .. Is it in JSON format or something else

As per https://learn.microsoft.com/en-us/azure/cosmos-db/choose-api#table-api The Azure Cosmos DB API for Table stores data in key/value format. Note that there are some differences though when compared with Azure Table Storage - for details, refer to https://learn.microsoft.com/en-us/azure/cosmos-db/table/faq#where-is-api-for-table-not-identical-with-azure-table-storage-behavior- If the above response helps answer your question, remember to "Accept Answer" so that others in the community facing similar issues can easily find the solution. Your contribution is highly appreciated. hth Marcin

Container table format - Microsoft Q&A

Accepted answer

Marcin Policht 24,630 Reputation points MVP

2024-09-22T00:00:31.5966667+00:00

As per https://learn.microsoft.com/en-us/azure/cosmos-db/choose-api#table-api

The Azure Cosmos DB API for Table stores data in key/value format.

Note that there are some differences though when compared with Azure Table Storage - for details, refer to https://learn.microsoft.com/en-us/azure/cosmos-db/table/faq#where-is-api-for-table-not-identical-with-azure-table-storage-behavior-

If the above response helps answer your question, remember to "Accept Answer" so that others in the community facing similar issues can easily find the solution. Your contribution is highly appreciated.

hth

Marcin
Please sign in to rate this answer.
Vineet S 950 Reputation points

2024-09-22T04:42:02.9366667+00:00

What is format.. Key value?

Marcin Policht 24,630 Reputation points MVP

2024-09-22T10:59:27.6933333+00:00

The key/value format is a simple data storage model where each item (or entry) is stored as a pair consisting of a key and a value.

Key: A unique identifier used to access the associated value. In the context of databases, the key is often used as an index to quickly retrieve the corresponding value.

Value: The data associated with the key. This can be a simple data type like a string or number, or a more complex structure such as a JSON object, a list, or even binary data.

In the key/value format:

Each key is unique within a given context (e.g., within a table or a container).

The value can vary in structure and type, depending on the storage system.

In Azure Cosmos DB's Table API:

The key is typically a combination of the PartitionKey and RowKey (which together uniquely identify an entity).

The value consists of the properties associated with that entity.

For example, in Azure Cosmos DB Table API, an entity might have:

PartitionKey: "Customer1"

RowKey: "Order123"

Properties (values): OrderDate, Amount, Status, etc.

This structured format, while resembling a table with rows and columns, fundamentally relies on the key/value pairing to store and retrieve data.

If the above response helps answer your question, remember to "Accept Answer" so that others in the community facing similar issues can easily find the solution. Your contribution is highly appreciated.

hth

Marcin
Sign in to comment

Use comments to ask for clarification, additional information, or improvements to the question.

Share via

Container table format

0 additional answers

Your answer