Microsoft Q&A

Azure Cosmos DB

985 questions

An Azure NoSQL database service for app development.

Browse all Azure tags

985 questions with Azure Cosmos DB tags

Sort by: Updated
2 answers

Point Read has higher RUs than equivalent query

We have 2 documents in a container that is being used for testing. 1 of them is small (<1KB) and 1 of them is relatively large (~60KB). The following query which returns both documents (in full, of course) costs 3.17RU: SELECT * FROM c Performing a…

Azure Cosmos DB
Azure Cosmos DB
An Azure NoSQL database service for app development.
985 questions
asked 2023-03-24T22:56:45.1833333+00:00
Rudi Visser 0 Reputation points
commented 2023-03-31T21:49:44.7533333+00:00
Oury Ba-MSFT 10,331 Reputation points Microsoft Employee
1 answer

Failed request to Azure Cosmos DB service

In Application Insights, we have traces indicate that an exception occurred while trying to add an entity document to CosmosDB. The reason for the failure is that the service was unavailable (ServiceUnavailable) with a sub-status code of 20006. If we…

Azure Cosmos DB
Azure Cosmos DB
An Azure NoSQL database service for app development.
985 questions
asked 2023-03-31T13:05:04.0166667+00:00
Robbert Vanherck 0 Reputation points
answered 2023-03-31T13:22:43.79+00:00
Rahul Randive 866 Reputation points Microsoft Employee
1 answer

Is it possible to create a pre-seeded docker image based on mcr.microsoft.com/cosmosdb/linux/azure-cosmos-emulator?

To give our team a ready to query cosmos db container, pre-seeded with our data, I am trying to build a docker image based of mcr.microsoft.com/cosmosdb/linux/azure-cosmos-emulator My idea was to do something like this: FROM…

Azure Cosmos DB
Azure Cosmos DB
An Azure NoSQL database service for app development.
985 questions
asked 2023-03-24T15:31:06.18+00:00
Jef Schraag Halma 1 Reputation point
commented 2023-03-31T05:56:16.7166667+00:00
PRADEEPCHEEKATLA-MSFT 56,551 Reputation points Microsoft Employee
1 answer

How to use order by on the HighWaterMarkChangeDetectionPolicy field with the search service API

Hello, I'm currently work on solution of azure cognitive search with multiple cosmos db indexers. I use .NET SDK to configure my indexes and indexers. I set up the HighWaterMarkChangeDetectionPolicy on the _ts filed of my cosmos documents. I set up the…

Azure Cosmos DB
Azure Cosmos DB
An Azure NoSQL database service for app development.
985 questions
Azure Cognitive Search
Azure Cognitive Search
An Azure search service with built-in artificial intelligence capabilities that enrich information to help identify and explore relevant content at scale.
218 questions
asked 2023-03-30T06:40:16.76+00:00
Julien Ferreira 0 Reputation points
answered 2023-03-31T00:03:09.77+00:00
Grmacjon-MSFT 9,581 Reputation points
0 answers

Hierarchical partition not distributed equally across physical partitions

I have been working with hierarchical partitions and noticed some behavior where documents with the same primary partition key are always put into the same physical partition. Even though they all have a different secondary partition key and I have more…

Azure Cosmos DB
Azure Cosmos DB
An Azure NoSQL database service for app development.
985 questions
asked 2023-03-24T10:52:52+00:00
Louis Lavens 6 Reputation points
commented 2023-03-30T14:31:19.5833333+00:00
Louis Lavens 6 Reputation points
0 answers

With Cosmos db and Postgres would it be efficient to partition on column?

Hi This is concerning: Azure Cosmos DB for PostgreSQL I have this table structure. It is a record over alle events (inserts, deletes and updates) on my server. The catalog column indicates from where the events originates from. There will be 100.000.000…

Azure Cosmos DB
Azure Cosmos DB
An Azure NoSQL database service for app development.
985 questions
Azure Database for PostgreSQL
asked 2023-03-30T12:53:42.2233333+00:00
Klaus Nørregaard 1 Reputation point
edited the question 2023-03-30T13:21:23.9933333+00:00
Klaus Nørregaard 1 Reputation point
1 answer

How to enable "Allow public access from Azure services and resources within Azure to this cluster" for Azure Cosmos DB for PostgreSQL Cluster using CLI?

Hi, For my deployment script, I would like to know how can turn on the option "Allow public access from Azure services and resources within Azure to this cluster" in a "Azure Cosmos DB for PostgreSQL Cluster" resource by using CLI? Or…

Azure Cosmos DB
Azure Cosmos DB
An Azure NoSQL database service for app development.
985 questions
asked 2023-03-28T05:57:06.2633333+00:00
Jacky Lam 0 Reputation points
commented 2023-03-30T06:08:19.41+00:00
ShaktiSingh-MSFT 5,866 Reputation points Microsoft Employee
1 answer

is that possible to prmote the cosmos db nosql account to standalone

i got stuck with below queries, 1.was trying to promote the cosmos db for disaster recovery using CLI, need support.

Azure Cosmos DB
Azure Cosmos DB
An Azure NoSQL database service for app development.
985 questions
asked 2023-03-20T06:36:46.3766667+00:00
Golthi K Chandra 0 Reputation points Microsoft Vendor
answered 2023-03-30T03:01:35.4366667+00:00
Rahul Randive 866 Reputation points Microsoft Employee
0 answers

Cosmos DB - Failed to delete CosmosDB containers after 2023-03-23

When I try to use the CosmosDB Java SDK and NodeJS SDK to delete a container, I encounter an error message like the one below. Error: Unknown server error occurred when processing this request. ActivityId: 9301c0e8-959a-4d7c-b571-cf2256ed7153,…

Azure Cosmos DB
Azure Cosmos DB
An Azure NoSQL database service for app development.
985 questions
asked 2023-03-24T07:42:56.6033333+00:00
Jess 91 Reputation points
commented 2023-03-30T02:17:37.6733333+00:00
Lucas 0 Reputation points
1 answer

Azure Cosmos change feed Apache Gremlin with Azure functions

Hello everyone! I would like to know how to "subscribe" to change feed of Azure Cosmos DB based on Apache Gremlin. I've tried to subscribe using Azure Function App (Cosmos DB trigger using Python client), but it didn't log any changes. I used…

Azure Cosmos DB
Azure Cosmos DB
An Azure NoSQL database service for app development.
985 questions
Azure Functions
Azure Functions
An Azure service that provides an event-driven serverless compute platform.
2,812 questions
asked 2023-03-17T09:32:42.8933333+00:00
Domagoj Bazina 221 Reputation points
edited the question 2023-03-29T18:49:43.0466667+00:00
Oury Ba-MSFT 10,331 Reputation points Microsoft Employee
1 answer

How to do a bulk upload of 17.6M records in cosmos db for mongo api instance in less than an hour?

Currently I am using a serverless instance of Cosmos db for mongo api in Canada East region. It takes almost a day to write 17.6M records to the cosmos instance. I have enabled the server side retries and I am using only a single instance of mongoClient…

Azure Cosmos DB
Azure Cosmos DB
An Azure NoSQL database service for app development.
985 questions
asked 2023-03-28T14:31:13.7833333+00:00
15643986 5 Reputation points
commented 2023-03-29T13:47:33.95+00:00
15643986 5 Reputation points
1 answer One of the answers was accepted by the question author.

Does Azure Cosmos DB for PostgreSQL support logical decoding?

Hi, I want to use debezium to stream CDC events from the Azure Cosmos DB for PostgreSQL cluster. But it seems that I cannot create a user (role) with REPLICATION privilege via the citus user. So how can I get a user with REPLICATION privilege? FYI:…

Azure Cosmos DB
Azure Cosmos DB
An Azure NoSQL database service for app development.
985 questions
asked 2023-03-27T08:53:57.79+00:00
Siyuan 20 Reputation points
accepted 2023-03-29T03:16:42.53+00:00
Siyuan 20 Reputation points
1 answer

Cosmos DB - Failed to change the ID after it has exceeded 300 characters.

On 2023-03-23, we create a new CosmosDB Account. And then we found something wrong. Failed to change the ID after it has exceeded 300 characters. we change the ID of the data to one over 300 characters. it succeeded After that, failed to change the…

Azure Cosmos DB
Azure Cosmos DB
An Azure NoSQL database service for app development.
985 questions
asked 2023-03-24T07:58:54.4666667+00:00
Jess 91 Reputation points
commented 2023-03-29T01:18:34.0133333+00:00
Jess 91 Reputation points
2 answers

Getting Error While doing Bulk Delete Cosmosdb Documents using Stored Procedure through Rest API

I've created a database and a collection. When creating the collection, the partition key was a required field so I used 'Date' field as partition key. I have created stored procedure to perform bulk documents delete from the collection in the cosmos…

Azure Cosmos DB
Azure Cosmos DB
An Azure NoSQL database service for app development.
985 questions
asked 2023-03-21T06:50:43.4833333+00:00
kumar sanu 0 Reputation points
commented 2023-03-27T04:10:06.3133333+00:00
Sajeetharan 696 Reputation points Microsoft Employee
0 answers

Cosmo DB docker linux does not work on custom port

Hello, I am facing the same problem as it was described here https://github.com/Azure/azure-cosmos-db-emulator-docker/issues/50 Basically, I would like to run cosmos DB container using a custom port (not 8081). If I have my application running as a…

Azure Cosmos DB
Azure Cosmos DB
An Azure NoSQL database service for app development.
985 questions
asked 2023-03-12T07:26:04.51+00:00
Andrey Lopatin 0 Reputation points
commented 2023-03-27T00:13:25.11+00:00
Andrey L 0 Reputation points
1 answer

Can Resource Token be used for accessing Cosmos Table API from clients

I am currently using Azure Table Storage and use SAS Tokens to access data from clients. I am planning to move to Cosmos DB Tables, but SAS Tokens are not supported in Cosmos DB Tables. So, is it possible to use the Resource Tokens to access Cosmos…

Azure Cosmos DB
Azure Cosmos DB
An Azure NoSQL database service for app development.
985 questions
asked 2023-03-25T15:04:37.7966667+00:00
Vinod Shinde 1 Reputation point
commented 2023-03-26T17:39:06.22+00:00
Patchfox 1,086 Reputation points
1 answer

TLS exchange FAILS between Azure cosmos db and client Node 18.14.2 openssl 3.0.8+quic

Hi, I have setup Azure cosmos db and written a simple conn.ts script to create document in cosmos db. I am using Node 18.14.2 which has built-in openssl 3.0.8+quic in it. I am getting an error as shown below: **The same code works fine with Node version…

Azure Cosmos DB
Azure Cosmos DB
An Azure NoSQL database service for app development.
985 questions
asked 2023-02-22T18:51:43.3366667+00:00
Isha Padmanaban 0 Reputation points
answered 2023-03-25T08:48:29.93+00:00
erastus iilonga 0 Reputation points
2 answers One of the answers was accepted by the question author.

Is security an issue when configuring & deploying an Azure Cosmos Change Feed Function App?

When I am creating a Cosmos Change Feed Function do I care about Publicly visibility Authorization Level (Function, Anonymous, Admin) Thanks Siegfried

Azure Cosmos DB
Azure Cosmos DB
An Azure NoSQL database service for app development.
985 questions
Azure Functions
Azure Functions
An Azure service that provides an event-driven serverless compute platform.
2,812 questions
asked 2023-03-17T19:10:07.49+00:00
Siegfried Heintze 1,411 Reputation points
accepted 2023-03-24T15:48:50.9333333+00:00
Siegfried Heintze 1,411 Reputation points
2 answers

Combining Data from Two CosmosDB Containers Using Azure Data Factory

I am working on a project where I need to combine data from two different CosmosDB containers and save the result in a third container using Azure Data Factory (ADF). I have two containers, one containing a nested array of products, and another with…

Azure Cosmos DB
Azure Cosmos DB
An Azure NoSQL database service for app development.
985 questions
Azure Data Factory
Azure Data Factory
An Azure service for ingesting, preparing, and transforming data at scale.
6,721 questions
asked 2023-03-03T22:51:23.2466667+00:00
Eliu Prachedes Moraes 0 Reputation points
commented 2023-03-24T12:21:56.51+00:00
Eliu Prachedes Moraes 0 Reputation points
1 answer One of the answers was accepted by the question author.

Cosmos DB always encrypted Bicep Support

Hi, I am working on always encrypted feature of cosmos DB, however not able to find documentation on how I can create Data encryption key & create a container with encryption policy as always encryption does not have Bicep or ARM support.

Azure Cosmos DB
Azure Cosmos DB
An Azure NoSQL database service for app development.
985 questions
asked 2023-03-20T14:16:31.3+00:00
Kuldeep Ghildiyal 20 Reputation points Microsoft Employee
accepted 2023-03-23T21:06:39.4866667+00:00
Kuldeep Ghildiyal 20 Reputation points Microsoft Employee