Azure Cosmos DB
An Azure NoSQL database service for app development.
1,513 questions
1 answer
Azure Cosmos DB status: "Creating"
Hello I tried to create a cosmo database with containers, using bisep, but something went wrong, and now I have a cosmo account that has been created for 5 days. "Status: Creating" I can’t delete it, the resource group couldn’t be deleted…
asked 2024-06-27T22:46:45.0766667+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(12.8, 1%, 11%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EA%3C/text%3E%3C/svg%3E)
Влад Терещенко
0
Reputation points
commented 2024-06-29T13:36:39.78+00:00
Влад Терещенко
0
Reputation points
0 answers
Query items (container.query_items) for aio CosmosClient works for query that returns few items but fails when the number of items returned increase
Hello, I'm relatively new to aio.CosmosClient which is a Cosmos DB Client for Python to be used with async code. This is the snippet of my code in one function: async_iter = container.query_items( query=sql_query, parameters=query_params, …
asked 2024-06-27T20:11:22.9533333+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(92.8, 33%, 18%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EBN%3C/text%3E%3C/svg%3E)
Byiringiro, Nissi Fidele
0
Reputation points
edited a comment 2024-06-28T21:21:32.2+00:00
Oury Ba-MSFT
17,556
Reputation points Microsoft Employee
1 answer
Azure Cosmos DB for PostgreSQL. Prepared statement error
I am running into issues regarding the pgbouncer connection pooling in Azure Cosmos DB for PostgreSQL: https://learn.microsoft.com/en-us/azure/cosmos-db/postgresql/concepts-connection-pool. The issue is that I get the error: "prepared statement…
asked 2024-06-27T14:26:29.3366667+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(80, 64%, 17%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EPM%3C/text%3E%3C/svg%3E)
Petter Moe
5
Reputation points
answered 2024-06-27T21:28:21.6833333+00:00
GeethaThatipatri-MSFT
28,852
Reputation points Microsoft Employee
0 answers
Azure Synapse analytics with CosmosDB query is giving null values
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…
asked 2024-06-25T12:09:20.5533333+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(201.6, 34%, 29%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ESS%3C/text%3E%3C/svg%3E)
Sathya Sai Cheetirala
0
Reputation points
commented 2024-06-27T19:29:03.3566667+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(86.4, 36%, 18%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EBM%3C/text%3E%3C/svg%3E)
BhargavaGunnam-MSFT
28,446
Reputation points Microsoft Employee
1 answer
Azure Cosmos DB with mongo don't support .sort operation ?
Hi, after trying to query data from cosmos db (configured for mongo), but I got error on .sort({"at": -1}) Everything works on localhost mongo db very well, but not in azure. Trace back from python is: 2024-04-09T13:02:08.1267872Z Traceback…
asked 2024-04-09T13:10:56.72+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(201.6, 7.000000000000001%, 29%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EEP%3C/text%3E%3C/svg%3E)
Erik Palenčík
0
Reputation points
edited a comment 2024-06-27T11:22:56.8166667+00:00
Erik Palenčík
0
Reputation points
0 answers
Cosmos DB copy in ADF comes from two regions instead of one region
I have one ADF instance in West US region and I have a Cosmos DB in East US. When running a copy activity in ADF from Cosmos to Azure SQL, I see the copy comes from East US and West US regions. The copy should come just from East US. Could this beavior…
asked 2024-06-25T22:30:57.58+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(96, 78%, 19%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ESH%3C/text%3E%3C/svg%3E)
Salomon Henriquez
106
Reputation points Microsoft Employee
commented 2024-06-27T09:08:27.6333333+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(12.8, 48%, 11%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EH%3C/text%3E%3C/svg%3E)
Harishga
5,420
Reputation points Microsoft Vendor
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:…
asked 2023-03-27T08:53:57.79+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(16, 75%, 11%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ES%3C/text%3E%3C/svg%3E)
Siyuan
30
Reputation points
commented 2024-06-26T17:14:42.8866667+00:00
GeethaThatipatri-MSFT
28,852
Reputation points Microsoft Employee
0 answers
[INTERNAL_ERROR] The Spark SQL phase optimization failed with an internal error. You hit a bug in Spark or the Spark plugins you use.
"I am trying to extract data from Azure Cosmos DB using PySpark and I am getting the following error: Py4JJavaError: An error occurred while calling o700.save.: org.apache.spark.SparkException: [INTERNAL_ERROR] The Spark SQL phase optimization…
asked 2024-03-08T08:35:10.85+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(19.2, 81%, 11%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ENF%3C/text%3E%3C/svg%3E)
Nathalia Fernandez Rodrigues
0
Reputation points
commented 2024-06-26T16:39:36.0333333+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(54.400000000000006, 69%, 15%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ELP%3C/text%3E%3C/svg%3E)
Luce PHILIBERT
0
Reputation points
1 answer
How to enable partition key delete feature for my Azure cosmos account?
var deleteResponse = await container.DeleteAllItemsByPartitionKeyStreamAsync(new PartitionKey(partitionKey)); I have used this code snippet from referring -…
asked 2024-06-26T06:31:25.76+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(179.20000000000002, 44%, 27%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ESA%3C/text%3E%3C/svg%3E)
Sharuk Abdul Gafoor
0
Reputation points
answered 2024-06-26T10:49:31.8366667+00:00
Sajeetharan
2,031
Reputation points Microsoft Employee
5 answers
One of the answers was accepted by the question author.
How to run stored procedure for hierarchical partition container
I am trying to run stored procedure from Azure Portal UI. The container has hierarchical partition with two levels. When trying to give the partition key value im providing input as json: {"level1": "value1", "level2":…
asked 2024-06-12T05:58:21.2433333+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(6.4, 3%, 10%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EAS%3C/text%3E%3C/svg%3E)
Antra Sharma
41
Reputation points Microsoft Employee
accepted 2024-06-26T04:56:52.4766667+00:00
Antra Sharma
41
Reputation points Microsoft Employee
1 answer
Update to version 3 of the Azure Cosmos DB .NET SDK by 31 August 2024
We received this email stating "we'll retire version 2.x of this SDK on 31 August 2024." What does retirement mean? What will stop working and what will continue to work if i stay on version 2.x
asked 2024-06-25T18:44:38.28+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(304, 97%, 39%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EGG%3C/text%3E%3C/svg%3E)
Gaurav Gautam
0
Reputation points Microsoft Employee
edited an answer 2024-06-25T22:18:55.9433333+00:00
Oury Ba-MSFT
17,556
Reputation points Microsoft Employee
2 answers
How to use mTLS to secure a sql database
Hi, I'm trying to an managed sql database in Azure using either a managed sql instance or cosmosdb with the postgres interface. However I would like to secure the communication towards it using mTLS since all of the communication will come from…
asked 2024-05-30T07:43:23.8666667+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(192, 4%, 28%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EDA%3C/text%3E%3C/svg%3E)
David Andersson
0
Reputation points
edited the question 2024-06-25T17:25:12.22+00:00
KapilAnanth-MSFT
39,051
Reputation points Microsoft Employee
1 answer
Batch upload document to Azure Cosmos DB using Perl
I have successfully set up Postman Collections to access Microsoft Azure Cosmos DB via REST APIs by following https://github.com/sajeetharan/CosmosDBPostmanGuide. The next step I need to perform is gather sample JSON data to be batch uploaded to our…
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(176, 5%, 27%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EA%3C/text%3E%3C/svg%3E)
1 answer
Azure durable functions Activity and CosmosDBInput binding usage
I am using azure durable functions where in from kafka trigger we invoke and orchestrator function which triggers various activities. With in trigger, we store the message with in cosmos db. However we want to further enrich the stored message with in…
asked 2024-06-24T14:32:13.37+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(73.60000000000001, 38%, 17%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ER%3C/text%3E%3C/svg%3E)
RK
20
Reputation points
commented 2024-06-25T10:04:21.61+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(249.60000000000002, 39%, 34%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ESM%3C/text%3E%3C/svg%3E)
SwathiDhanwada-MSFT
18,456
Reputation points
1 answer
Metadata permissions clarity
Hello, Having a few doubts related to Metadata permissions. What is metadata read/write permissions? What is the use of it, and whether this permission is required for an user who majorly uses only Azure portal for managing the resources? How to…
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(12.8, 89%, 11%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EA%3C/text%3E%3C/svg%3E)
1 answer
How can I implement asynchronous loading into Azure Cosmos DB (Gremlin) with Python 3.10 correctly?
Hello, I have an Event Grid trigger Azure function that takes events, processes them, checks if a vertex exists in the Cosmos DB (Gremlin), and if not, adds this vertex to the database. When the number of events for processing is small, everything…
asked 2024-06-23T22:05:05.43+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(294.40000000000003, 90%, 38%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EMP%3C/text%3E%3C/svg%3E)
Maryna Paluyanava
211
Reputation points
commented 2024-06-24T07:05:43.4733333+00:00
Sajeetharan
2,031
Reputation points Microsoft Employee
1 answer
One of the answers was accepted by the question author.
Why am I asked to update Azure Cosmos DB .NET SDK to version 3 by 31 August 2024? We've never been using version 2 to the best of my knowledge.
Hi, I've received the following email: Update to version 3 of the Azure Cosmos DB .NET SDK by 31 August 2024 You're receiving this email because you've used version 2.x of the Azure Cosmos DB .NET SDK. Because version 3 of the Azure Cosmos DB .NET SDK…
.NET
.NET
Microsoft Technologies based on the .NET software framework.
3,561 questions
Azure Cosmos DB
Azure Cosmos DB
An Azure NoSQL database service for app development.
1,513 questions
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(297.6, 57.99999999999999%, 38%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EO%3C/text%3E%3C/svg%3E)
1 answer
Request blocked by Auth - user does not have required RBAC permission Microsoft.DocumentDB/databaseAccounts/readMetaData
First error is trying to load the FlightExpression items in the azsupportrp-casemgmt-westus db in the azure portal I was told that the cosmos data explorer would resolve the AAD error above so I used this link to access the db…
asked 2024-06-21T15:25:48.0333333+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(25.6, 10%, 12%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EKS%3C/text%3E%3C/svg%3E)
Kenley Shaw
0
Reputation points Microsoft Employee
answered 2024-06-21T19:50:48.76+00:00
Oury Ba-MSFT
17,556
Reputation points Microsoft Employee
1 answer
Cosmos DB read operation timeout after second try with Error Code 500
I am having issues with Cosmos DB where the first read operation succeeds and returns result from DB as expected, but all subsequent reads fail with Error Code 500. The error message mentions a session token not being available. How can I resolve this…
asked 2024-06-19T20:30:20.2633333+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(144, 15%, 23%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EJC%3C/text%3E%3C/svg%3E)
Jerry Cui
0
Reputation points
answered 2024-06-20T20:01:15+00:00
GeethaThatipatri-MSFT
28,852
Reputation points Microsoft Employee
2 answers
One of the answers was accepted by the question author.
Role required to read/write data from cosmos DB (SQL API) from ADF?
We are trying to read/write data from Azure data factory, since local authentication is disabled in cosmos we are trying to access cosmos DB using managed identity. However even with Cosmos DB Account Contributor role assigned to managed identity of…
asked 2022-04-06T15:47:26.763+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(38.4, 92%, 13%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EAS%3C/text%3E%3C/svg%3E)
Ashutosh Saini
36
Reputation points
commented 2024-06-20T12:22:48.4933333+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(304, 88%, 39%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EGB%3C/text%3E%3C/svg%3E)
Guillaume Belzile
0
Reputation points