Azure Cosmos DB
An Azure NoSQL database service for app development.
1,524 questions
0 answers
Normalized RU Consumption metrics calculation for Azure Cosmos
Hi, I was trying to understand the different metrics available in azure portal for Azure Cosmos resource. There is one metric named as "Normalized RU Consumption(Max)" , I would like to understand how this percentage is calculated over a given…
asked 2024-07-10T04:08:39.6933333+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, 48%, 10%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EDM%3C/text%3E%3C/svg%3E)
Debajit Mitra
20
Reputation points
commented 2024-07-11T07:47:11.32+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(220.8, 4%, 31%)' 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)
ShaktiSingh-MSFT
14,291
Reputation points Microsoft Employee
0 answers
CosmosDB blocking Managed Identity principal for readMetadata action
Hi, I am having CosmosDB and Managed Identity created in same resource group. I have added Reader, Contributor Roles from Managed Identity - Azure Roles Assignments from left panel of azure portal. But still I am getting following error: Request blocked…
asked 2024-07-09T13:59:42.9+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(265.6, 31%, 35%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EAK%3C/text%3E%3C/svg%3E)
aditya kature
0
Reputation points
edited a comment 2024-07-10T19:26:29.2433333+00:00
Oury Ba-MSFT
17,706
Reputation points Microsoft Employee
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
edited an answer 2024-07-10T19:14:25.93+00:00
Oury Ba-MSFT
17,706
Reputation points Microsoft Employee
6 answers
CosmosDB Analytical store delete changes in sql sink
Hi I am trying to capture delete changes from Azure cosmosdb analytical store using change data capture in Azure datafactory, Source is Cosmosdb, sink is Azure sql database. In between I am flattening my file using dataflow. My insert, update is…
asked 2024-04-30T13:52:46.2133333+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(112.00000000000001, 15%, 20%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EKB%3C/text%3E%3C/svg%3E)
Kuldeep Bhati
0
Reputation points
answered 2024-07-10T12:16:09.6333333+00:00
Kuldeep Bhati
0
Reputation points
1 answer
One of the answers was accepted by the question author.
Azure Data Factory Copy Geometry data from Azure SQL to Azure Cosmos DB
Hi Team, I am trying to copy over data from a table in Azure SQL database containing geometry type columns. When i created a linked service and preview data get the error message 'Type=Newtonsoft.Json.JsonSerializationException,Message=Error getting…
asked 2024-07-10T05:11:28.7133333+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(172.8, 70%, 26%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EVR%3C/text%3E%3C/svg%3E)
Vijay Rudrasamudram
0
Reputation points
commented 2024-07-10T11:03:04.6+00:00
Vijay Rudrasamudram
0
Reputation points
0 answers
how to sync data between Azure Cosmos DB for PostgreSQL clusters?
Hi, I want to sync data from a Azure Cosmos DB for PostgreSQL cluster to other. Does Azure Cosmos DB for PostgreSQL support CDC now? Can I use some tools like debezium to do it? If not, is there any other solution? Thanks!
![](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, 67%, 29%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EP%3C/text%3E%3C/svg%3E)
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
commented 2024-07-09T18:28:26.2+00:00
Oury Ba-MSFT
17,706
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
commented 2024-07-09T14:28:57.99+00:00
GeethaThatipatri-MSFT
29,012
Reputation points Microsoft Employee
3 answers
One of the answers was accepted by the question author.
Azure CosmosDB Consistency - Understanding Bounded Staleness
Hi , I am new to AzureCosmosDB and struggling to understand the Bounded Staleness Consistency level. https://learn.microsoft.com/en-us/azure/cosmos-db/consistency-levels What does the lag in time and updates really mean? Referring to…
asked 2020-10-04T10:59:45.593+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(256, 12%, 34%)' 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)
Biju Mathew
481
Reputation points
commented 2024-07-09T03:30:46.36+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, 61%, 12%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EKG%3C/text%3E%3C/svg%3E)
Karl Gardner
0
Reputation points
0 answers
Failed to retrieve resource
Error: Failed to retrieve resource │ │ reading "Resource: (ResourceId │ "/subscriptions/xxxxxxxx-xxxxx-xxxxx/resourceGroups/XXXX-xxxxx-XXX/providers/Microsoft.DocumentDB/databaseAccounts/cosmosdb" │ / Api Version…
asked 2024-07-05T04:23:45.8266667+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(41.6, 43%, 14%)' 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)
Kulkarni, Siddaraj [ext]
0
Reputation points
commented 2024-07-08T16:18:24.2933333+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(166.4, 85%, 26%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ENB%3C/text%3E%3C/svg%3E)
Nathan Bird
1
Reputation point
6 answers
In Azure OpenAI Studio, I'm working on Chat Playground, trying to connect to my own Azure Cosmos DB for MongoDB (vCore). I can't select an index name; there's no dropdown. What's the issue?
In Azure OpenAI Studio, I am currently engaged in the Chat Playground project, where I am endeavoring to establish a connection to my personal data source via Azure Cosmos DB for MongoDB (vCore). I have encountered a predicament during the selection of…
asked 2023-12-18T08:58:05.4833333+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(252.8, 43%, 34%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ESP%3C/text%3E%3C/svg%3E)
Siravich Piboonworachat
5
Reputation points
answered 2024-07-08T15:52:19.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(169.60000000000002, 69%, 26%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EPR%3C/text%3E%3C/svg%3E)
prakash ramasamy
0
Reputation points
3 answers
Not getting access with newly created user in cosmosdb for mongodb
I have created user in consmosdb for mongodb api with built-in role but while accessing with newly created user getting Error: invalid salt length provided
asked 2024-05-14T11:18:05.34+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(198.4, 20%, 29%)' 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)
Sanjay Mange
5
Reputation points
answered 2024-07-08T03:50:01.68+00:00
ShaktiSingh-MSFT
14,291
Reputation points Microsoft Employee
0 answers
How to write resolvers for related attributes in API Management GraphQL NoSQL CosmosDB Resolver?
I have a Cosmos NoSQL model with document types user, clip, and audioFile. I have created GraphQL resolvers to access CosmosDB. One GraphQL query (query/clip by ID) works fine until I ask for the child audioFiles (I have a clip/audioFiles resolver). …
asked 2024-07-07T01:25:02.6033333+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(3.2, 28.999999999999996%, 10%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EWA%3C/text%3E%3C/svg%3E)
W. Alex Livesley
0
Reputation points
edited the question 2024-07-07T06:01:06.8933333+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(224.00000000000003, 86%, 31%)' 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)
AmaranS
3,555
Reputation points Microsoft Vendor
1 answer
One of the answers was accepted by the question author.
Cosmos db Multipolygon - Which inner Polygon it belongs to ?
Hi everyone - I do have a Multipolygon defined with several fences. When I run a query using st_within, I get only a boolean which indicates my Location is within ANY of the polygon. The question in addition to this boolean, is it possible to know…
asked 2024-07-06T04:08:36.93+00:00
Mathew James
381
Reputation points
commented 2024-07-06T19:00:17.4866667+00:00
Amira Bedhiafi
18,981
Reputation points
1 answer
Deployment errors (cosmosdb, apim and graphrag-deploy) while deploying graphRAG
Hi, I'm facing three issues while deploying graphRAG using this command bash deploy.sh -p deploy.parameters.json : 1- cosmodb deployment: having this error log: Database account creation failed. Operation Id: xxxxxx, Error : Message:…
asked 2024-07-05T07:55:05.38+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, 19%, 28%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EAB%3C/text%3E%3C/svg%3E)
Achraf Bennis
5
Reputation points
answered 2024-07-05T22:51:41.2866667+00:00
Amira Bedhiafi
18,981
Reputation points
3 answers
CosmosDB: Deny CRUD Operations to Owner
Hi, I have cosmos db Account. I would like that a user that is Subscription Owner (Where cosmos db lives) don't have access to crud operations. No writes, no reads to cosmos db Container. How i can achieve that? I would like to maintain the owner…
asked 2024-07-03T12:10:13.2066667+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(243.2, 11%, 33%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EFB%3C/text%3E%3C/svg%3E)
Fábio Santos
65
Reputation points
answered 2024-07-05T09:39:07.0633333+00:00
Amira Bedhiafi
18,981
Reputation points
1 answer
Performance issue on CosmosDB for MongoDB
I am experiencing performance issue with CosmosDB for MongoDB (RU), when executing a query on a collection containing 300,000 documents. The query takes 43 seconds to execute on CosmosDB, whereas on my local MongoDB setup, it only takes 411 ms. Both env…
asked 2024-07-04T07:54:19.1266667+00:00
Sanjay Mange
5
Reputation points
answered 2024-07-04T09:22:10.0566667+00:00
ShaktiSingh-MSFT
14,291
Reputation points Microsoft Employee
1 answer
Request for Assistance in Migrating Azure Cosmos DB for PostgreSQL Cluster Between Subscriptions with Minimal Downtime
We have a requirement to migrate all Azure resources from an Azure Plan subscription to an EA Agreement subscription. Among these resources is an Azure Cosmos DB for PostgreSQL Cluster with a size exceeding 25TB. Unfortunately, Azure Resource Mover does…
asked 2024-06-30T15:05:28.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(0, 8%, 10%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EAB%3C/text%3E%3C/svg%3E)
Aakarsh Bhogadi
26
Reputation points
commented 2024-07-04T07:33:53.66+00:00
ShaktiSingh-MSFT
14,291
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
answered 2024-07-03T11:55:09.5633333+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, 73%, 11%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EKP%3C/text%3E%3C/svg%3E)
Krina Pestro
0
Reputation points
0 answers
Unable to connect to my cosmos mongo db from Azure web app after enabling pvt endpoints and vnet integration
I have a web app (linux) where i push my docker image via container registry which connects to the cosmos mongo database. It works fine when eveyrthing is via public network. When i enable private endpoints and vnet integration , my app works fine but it…
Azure Cosmos DB
Azure Cosmos DB
An Azure NoSQL database service for app development.
1,524 questions
Azure Static Web Apps
Azure Static Web Apps
An Azure service that provides streamlined full-stack web app development.
834 questions
Azure Startups
Azure Startups
Azure: A cloud computing platform and infrastructure for building, deploying and managing applications and services through a worldwide network of Microsoft-managed datacenters.Startups: Companies that are in their initial stages of business and typically developing a business model and seeking financing.
237 questions
asked 2024-06-13T06:56:16.95+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, 53%, 17%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ED7%3C/text%3E%3C/svg%3E)
DangShubhamADVDAADASSPLTTE1DT7-7504
0
Reputation points
edited the question 2024-07-03T04:22:25.5833333+00:00
Ryan Hill
26,866
Reputation points Microsoft Employee