Azure Cosmos DB
An Azure NoSQL database service for app development.
1,710 questions
2 answers
Azure Cosmos Postgresql issue with Role creation
Hi, We are using Azure Cosmos Postgresql DB and we are experiencing issues with Role creation. We created a role from console as well as az cli using below command - The command shows succeeded and the role is visible. However the same role is not…
asked 2024-08-23T08:53:50.2166667+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(70.4, 3%, 16%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EVM%3C/text%3E%3C/svg%3E)
Vipal Mehta
40
Reputation points
edited a comment 2024-12-27T10:23:13.82+00:00
Vipal Mehta
40
Reputation points
1 answer
One of the answers was accepted by the question author.
Find duplicate indexed field across collection & is it possible to restore backup to a new db account with unique key constraint
We have a cosmos database with mongo api, it has more than 50 million records currently and it has few fields indexed and it is also Sharded with a shardkey. due to some technical issue our application has inserted a duplicate transaction. We want to…
asked 2024-12-19T17:21:31.7333333+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(307.2, 18%, 39%)' 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)
Srinivas54
40
Reputation points
commented 2024-12-27T10:08:20.3333333+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(246.4, 4%, 33%)' 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)
Sina Salam
14,626
Reputation points
2 answers
One of the answers was accepted by the question author.
FIPS error with Cosmos Postgresql DB while running stored procedure
Hi Team, I am facing a strange error while executing stored proc which executes a query on another DB. The same proc works fine in our staging DB hosted on Cosmos Postgresql. We have similar configuration and settings for both the DB and we checked all…
asked 2024-12-19T17:59:18.16+00:00
Vipal Mehta
40
Reputation points
commented 2024-12-26T06:00:41.79+00:00
Vipal Mehta
40
Reputation points
1 answer
Retrieve detailed logs for actions performed against a cosmos container back in time
We have no audit logs setup in Cosmos DB. And last week the content in a container got wiped in one of our database. We can see in metrics that the container has been wiped and the time, but we can't see what caused it. Can we get more detailed…
asked 2024-12-19T16:02:46.0233333+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(22.400000000000002, 45%, 12%)' 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)
Anders Kardell
0
Reputation points
commented 2024-12-24T16:18:35.9066667+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, 60%, 34%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EMK%3C/text%3E%3C/svg%3E)
Mahesh Kurva
1,625
Reputation points Microsoft Vendor
1 answer
Got an error while trying to delete a MongoDB Cluster
While I am trying to delete a cluster failed with error: "An unknown error occurred for the operation. Tracking id: 09a0efb1-5922-4338-aad9-ffa4ceba130b. Please can someone help me
asked 2024-12-16T21:38:52.2033333+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(284.8, 87%, 37%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EMX%3C/text%3E%3C/svg%3E)
Milton Xavier Sarmiento
0
Reputation points
commented 2024-12-24T02:18:15.6433333+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(35.2, 49%, 13%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EVK%3C/text%3E%3C/svg%3E)
Vijayalaxmi Kattimani
740
Reputation points Microsoft Vendor
1 answer
How to enable geospatial index in cosmosdb during migration? there is no option is showing in feature section of cosmosdb?
I am not able to enable geospatial index in cosmosdb during migration.
asked 2024-12-21T05:15:26.48+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, 84%, 34%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ECS%3C/text%3E%3C/svg%3E)
Chandra Shekar
0
Reputation points
commented 2024-12-24T01:50:23.8+00:00
Vijayalaxmi Kattimani
740
Reputation points Microsoft Vendor
0 answers
PartitionKeyVersion is NULL for the Azure Cosmos Container
The Microsoft documentation states that when creating a new container, the PartitionKeyVersion should be either 1 or 2, not NULL. However, when using PowerShell script to create a container without specifying "PartitionKeyVersion," it is being…
asked 2024-12-17T09:17:08.2+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(300.8, 20%, 39%)' 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)
Sai Praneeth Eranti
170
Reputation points
commented 2024-12-23T03:58:01.91+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
16,086
Reputation points
1 answer
One of the answers was accepted by the question author.
How to read cosmosdb mongodb API objectId field from a synapse analytical collection link
I am linking Synapse serverless sql pool with Cosmosdb with Mongodb API. For background, MongoDb sets its _id and reference ids to objectId(). To do a SQL join on this field, we need to convert the value to string. This is how the data…
asked 2024-12-21T03:46:47.5433333+00:00
Oscar Garcia @ozkary
21
Reputation points
commented 2024-12-22T02:29:50.59+00:00
Vinodh247
26,451
Reputation points MVP
3 answers
One of the answers was accepted by the question author.
How to rename/clone the cosmos db colletion?
Hi Team, Below is our nosql cosmos db- Here, We want to make copy/clone of collection - 'MenuItemDetailsV2', with new name i.e. 'MenuItemDetailsV2_backup' Please suggest how we can do it. Business use-case- Take backup of…
asked 2022-04-08T06:22:10.627+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(60.8, 90%, 15%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ENP%3C/text%3E%3C/svg%3E)
Nilesh Prajapati
21
Reputation points
edited an answer 2024-12-21T14:36:30.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(124.80000000000001, 49%, 22%)' 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)
Greg Gum
11
Reputation points
2 answers
Issue with FullTextPolicy Persistence on CosmosDB Container
I am experiencing an issue when adding a FullTextPolicy to an existing CosmosDB container. The full text support feature has been enabled on the account. Although the full text index is created successfully, the full text policy does not persist, and…
asked 2024-12-17T19:39:08.77+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(208, 8%, 30%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EDW%3C/text%3E%3C/svg%3E)
David West
5
Reputation points
commented 2024-12-20T18:26:17.2166667+00:00
Mahesh Kurva
1,625
Reputation points Microsoft Vendor
1 answer
ADF failing CopyData
I have a copy data action that reads from kusto db with a query and has a cosmos db sink. I have validated that the cosmos and kusto are successfully connected, yet while debugging the pipeline I run into this error: Could this be rbac related? I have…
asked 2024-12-14T00:47:11.2866667+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(76.8, 93%, 17%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ESK%3C/text%3E%3C/svg%3E)
Saad Khan
1
Reputation point Microsoft Employee
commented 2024-12-20T07:05:10.79+00:00
AnnuKumari-MSFT
33,976
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-12-20T01:44:53.0133333+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, 65%, 17%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ETN%3C/text%3E%3C/svg%3E)
Thuy Nguyen
5
Reputation points Microsoft Employee
3 answers
Getting "'_FullTextWordCount' is not a recognized built-in function name" while attempting RRF ranking.
I'm attempting to use a hybrid (FullText and Vector) query as prescribed in https://zcusa.951200.xyz/en-us/azure/cosmos-db/nosql/query/rrf. The query: SELECT TOP 5 c.content FROM c WHERE c.context="[CONTEXT VALUE]" ORDER BY RANK…
asked 2024-12-03T23:06:09.5966667+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(272, 1%, 36%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EVJ%3C/text%3E%3C/svg%3E)
Vargas, Justin J
0
Reputation points
commented 2024-12-19T13:53:28.2333333+00:00
Vargas, Justin J
0
Reputation points
1 answer
One of the answers was accepted by the question author.
Setting up TTL on CosmosDB for Mongo
Hey there, We are using Azure Cosmos DB for Mongo for our database; server version is 6.0. We want to activate TTL for one of the collections, but the interface seems to be blocked and asking to create a TTL index. Here is what we see. We followed the…
asked 2024-12-17T09:47:29.25+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, 69%, 28%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EDI%3C/text%3E%3C/svg%3E)
Daniel Ivanov
20
Reputation points
accepted 2024-12-19T07:17:29.9033333+00:00
Daniel Ivanov
20
Reputation points
1 answer
One of the answers was accepted by the question author.
Is there a way to make CosmosDB Data Explorer respect ETag when updating a document in the browser?
Hi, I would like to be able to manually update certain things in my CosmosDB container without having to worry about an application potentially overwriting the change/having its change overwritten by me. I tried this with two browsers by opening the…
asked 2024-12-12T08:28:26.5133333+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, 88%, 18%)' 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)
Alfred Kristal
20
Reputation points
accepted 2024-12-17T08:04:51.9433333+00:00
Alfred Kristal
20
Reputation points
1 answer
One of the answers was accepted by the question author.
How is the property stored when it has a different datatype that the base schema?
In this MS Analytical store docs link , it says that the analytical store doesn't "include" a property if it's of a different type than it's base schema. Just out of curiosity , does it mean in the column store it stores null against that…
asked 2024-12-09T10:23:31.2566667+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(262.40000000000003, 86%, 35%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ENS%3C/text%3E%3C/svg%3E)
Nandu S Raj
80
Reputation points
accepted 2024-12-15T13:19:58.5266667+00:00
Nandu S Raj
80
Reputation points
0 answers
requests from synapse pipelines blocked by firewall policy of cosmDB.
hello team, the requests are getting originated from synapse analytics pipelines to nosql coosmosDB. the requests are getting blocked by firewall settings of cosmosdb as the request IPs are different one for every run and requesting through public…
asked 2024-12-04T16:21:38.2566667+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, 98%, 10%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EAG%3C/text%3E%3C/svg%3E)
ANKIT GHENGE
40
Reputation points
commented 2024-12-13T23:21:13.6133333+00:00
Oury Ba-MSFT
19,831
Reputation points Microsoft Employee
1 answer
Integer typed column with NULL values in Analytical Store getting converted to 0 in Azure Synapse
I have a container A- container A has a column colA with integer as it's datatype in the AnalyticalStore , how do I know that? When I import the projection for the source it get's imported as integer. But I have overwritten the schema and set colA to…
asked 2024-12-09T17:02:57.8666667+00:00
Nandu S Raj
80
Reputation points
commented 2024-12-13T03:55:33.6266667+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(99.2, 65%, 19%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ECB%3C/text%3E%3C/svg%3E)
Chandra Boorla
5,835
Reputation points Microsoft Vendor
0 answers
How to use System Assigned MI to access Blob Storage and Cosmos DB in Synapse Analytics
Hi, I am trying leverage the default system assigned managed identity a synapse workspace provides to access blob storage and cosmos db. I have already tried the following steps which I saw in various posts: Assign Role to Managed Identity: Navigate…
asked 2024-12-10T16:23:43.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(310.4, 88%, 40%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EHN%3C/text%3E%3C/svg%3E)
Haria, Neel
0
Reputation points
commented 2024-12-12T22:33:20.69+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, 18%, 29%)' 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)
Ganesh Gurram
2,305
Reputation points Microsoft Vendor
1 answer
Cosmos db 1RU point read latency never below 20 ms
Hi, so we have several asp net core apis .7 or 8 (app services) where we are seeing average latencies for 1 RU point reads are between 20-25 ms on average in the last 30 days. The lowest registered was 10 ms. Looking at the SLA we should almost…
asked 2024-12-09T15:51:44.4766667+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(217.60000000000002, 19%, 31%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EEE%3C/text%3E%3C/svg%3E)
Erik Eriksson
0
Reputation points
commented 2024-12-11T14:12:08.3133333+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, 69%, 29%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ESR%3C/text%3E%3C/svg%3E)
Sai Raghunadh M
1,605
Reputation points Microsoft Vendor