Azure Cosmos DB
An Azure NoSQL database service for app development.
1,520 questions
1 answer
How to update DocumentDb from Microsoft.Azure.DocumentDB.Core
Hello, As we are updating our code base from netcoreapp3.1 to net5.0, one of the thing we have to do is update the Azure SDK we are using (KeyVault / Blob / Cosmos / ...) This question is about the CosmosDb part as we are consuming is with…
asked 2020-09-24T09:20:47.14+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(211.20000000000002, 73%, 30%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EHA%3C/text%3E%3C/svg%3E)
HERTOGS Alexandre (EXT) GbsuCldDit
1
Reputation point
commented 2020-09-26T18:13:56.047+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(297.6, 97%, 38%)' 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)
Anurag Sharma
17,586
Reputation points
2 answers
One of the answers was accepted by the question author.
Azure Cosmos DB Geospatial Calculation ST_WITHIN and ST_DISTANCE
Hi there, We are using Azure Cosmos DB to store our telemetry data. We have implemented a (geo zone/ geo-fence) feature where we have to check if a point is within a Polygon. To do this, we are using ST_WITHIN(gps_point(GeoJSON),…
asked 2020-09-06T03:39:21.47+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(275.2, 93%, 36%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ETE%3C/text%3E%3C/svg%3E)
Tahmid Eshayat
286
Reputation points
commented 2020-09-25T13:24:44.833+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(281.6, 93%, 37%)' 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)
Navtej Singh Saini
4,221
Reputation points Microsoft Employee
1 answer
One of the answers was accepted by the question author.
Capacity estimations
I recently completed a POC to demonstrate using Cosmos DB in lieu of other data stores currently utilized by my company. As I prepare information to present, I need to be able to speak to cost, part of which involves storage requirements. At the moment…
asked 2020-09-08T13:05:59.057+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, 94%, 20%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EJD%3C/text%3E%3C/svg%3E)
Jay D Zimmerman
21
Reputation points
accepted 2020-09-23T14:50:20.607+00:00
Jay D Zimmerman
21
Reputation points
1 answer
One of the answers was accepted by the question author.
Azure Function with IoT Hub Trigger and Cosmos DB output
I have an IoT device that sends data in a binary format to an IoT Hub. From there, I need to store the data in Cosmos DB, after presumably converting it to JSON format. My idea has been to set up an Azure Function with an IoT Hub trigger and a…
asked 2020-09-11T21:25:17.92+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(182.40000000000003, 8%, 27%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EMH%3C/text%3E%3C/svg%3E)
Matt Heagerty
46
Reputation points
commented 2020-09-23T14:11:34.7+00:00
Matt Heagerty
46
Reputation points
2 answers
Cosmos DB Throughput and Monitoring
Hello there, I am trying to setup alerting on our Cosmos DB containers. I have a question around the throughput and the Total Request Unit metric in alerting: Say I have a container with fixed throughput of 400 RU/s, does this translate to 400*60 =…
asked 2020-09-10T20:39:16.827+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(32, 19%, 13%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ETC%3C/text%3E%3C/svg%3E)
Tristan Chen
1
Reputation point
answered 2020-09-11T13:09:35.297+00:00
Stanislav Zhelyazkov
21,931
Reputation points MVP
2 answers
Problem with cosmos db mongo db connection
Hi, I would like to ask about data migration. I want to migrate data from my cosmos DB MongoDB 3.2 to cosmos DB MongoDB 3.6 and decided to use ADF. Two weeks ago everything worked well, but now I have an error 2200. I double-checked connection strings.…
asked 2020-08-10T14:07:59.113+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' %3EC%3C/text%3E%3C/svg%3E)
chodkows
11
Reputation points
commented 2020-09-10T15:46:34.673+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(134.4, 9%, 23%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EKM%3C/text%3E%3C/svg%3E)
KranthiPakala-MSFT
46,437
Reputation points Microsoft Employee
1 answer
Managing/auto-rotating Azure cosmos Db keys using Azure key vault
Does azure cosmos db and key vault provide ways using which the secret can be managed using keyvault similar to Azure Storage account overview-storage-keys-powershell? Funcitonalities required are Onboarding a cosmos db account to keyvault…
asked 2020-08-25T11:33:01.157+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, 64%, 40%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ESN%3C/text%3E%3C/svg%3E)
Saravanan Nakkeeran
1
Reputation point
commented 2020-09-08T18:40:04.27+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(204.8, 44%, 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)
Saurabh Sharma
23,781
Reputation points Microsoft Employee
1 answer
One of the answers was accepted by the question author.
TimeoutError and TransportException, DNS resolution timed out
Hi, We're using Azure CosmosDB with the SQL API from the NodeJS SDK. Everything worked fine until last weekend, but since yesterday some of our requests take much longer than usual and occasionally they fail with this error: …
asked 2020-09-01T08:53:31.817+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(214.4, 63%, 30%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EGK%3C/text%3E%3C/svg%3E)
Gerrit K
96
Reputation points
commented 2020-09-04T13:34:42.373+00:00
Navtej Singh Saini
4,221
Reputation points Microsoft Employee
1 answer
Cosmos db Gremlin API repeat query taking more than 15 seconds to query the data
We are using COSMOS DB Gremlin API for Graph DB. We are storing contact information between two people (vertices) along with some metadata of interaction saved as edge property. A person can connect with any number of people ranging from few to 1000s of…
asked 2020-08-24T14:50:42.907+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(176, 7.000000000000001%, 27%)' 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)
Shardul Pradhan
1
Reputation point
commented 2020-08-28T22:58:35.827+00:00
Navtej Singh Saini
4,221
Reputation points Microsoft Employee
1 answer
[Cosmos DB] Randomly get unauthorized using primary password
We've been receiving the unauthorized status upon connecting to the cosmos db when using primary read-only password, and this happens randomly. We also tried with the secondary password, the same issue is happening that it sometimes connects to the db or…
asked 2020-08-19T19:20:13.537+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(150.4, 87%, 24%)' 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)
Sungho Hong
1
Reputation point
commented 2020-08-28T17:07:44.697+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' %3EKM%3C/text%3E%3C/svg%3E)
KalyanChanumolu-MSFT
8,316
Reputation points
1 answer
Copy from CosmosDB to CosmosDB Error: "Request size is too large" using Data Factory
I am using the basic Copy wizard in ADF v2. I have a source Cosmosdb in one Subscription, and moving to a new Cosmosdb in a new subscription Database and Containers are configured the same. I have one container that copies 212 of 216 documents and…
asked 2020-08-18T05:18:59.823+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(281.6, 30%, 37%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EKM%3C/text%3E%3C/svg%3E)
Keith Miller
1
Reputation point
commented 2020-08-27T06:24:01.037+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(108.80000000000001, 9%, 20%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EHM%3C/text%3E%3C/svg%3E)
HarithaMaddi-MSFT
10,136
Reputation points
0 answers
Estimate creating index on cosmos DB - mongo
Hi, I migrated database from mongo-db into cosmos db. I followed below url https://datamigration.microsoft.com/scenario/mongo-to-cosmos?step=1 After migrating data into cosmos db, I created index on collection by query: …
asked 2020-08-20T07:23:46.87+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, 83%, 28%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EMM%3C/text%3E%3C/svg%3E)
Migrate mongodb
1
Reputation point
commented 2020-08-26T07:02:02.167+00:00
Anurag Sharma
17,586
Reputation points
0 answers
Cosmos DB Mongo Optimize cost reads writes
Hi, I migrated from mongo db into cosmos db and I have a trouble with cost. Detail information as below: StorageSize 300GB Collections 200 Object 1500M DataSize …
asked 2020-08-20T10:49:33.303+00:00
Migrate mongodb
1
Reputation point
commented 2020-08-26T04:52:27.097+00:00
KalyanChanumolu-MSFT
8,316
Reputation points
0 answers
Error writing data with output bindings
I have an Azure Cosmos DB input binding from which I can query and view existing records However, I've added an Azure Cosmos DB & Azure Queue Storage output bindings to my Azure Function, following the tutorial here. I can read existing…
asked 2020-08-14T22:06:31.257+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(156.8, 21%, 25%)' 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)
Jesse Cofie
1
Reputation point
commented 2020-08-19T11:26:18.297+00:00
Jesse Cofie
1
Reputation point
2 answers
Access Data in cosmodb using mongodb API with SQL Server PolyBase fails with error
I am trying to access data in my azure cosmosdb using SQL Server PolyBase (cosmosdb was created using "Azure Cosmos DB for MongoDB API) Alert me|Edit|Change type Question You cannot vote on your own post 0 Hi All, I am…
asked 2020-07-20T14:57:31.11+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, 98%, 34%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EMS%3C/text%3E%3C/svg%3E)
Mohammad Sufian
1
Reputation point
commented 2020-08-18T16:50:11.047+00:00
Navtej Singh Saini
4,221
Reputation points Microsoft Employee
0 answers
Error while creating collection in cosmos db
Hello everyone, While creating new collection I am getting below error, Does someone have idea on it? All the suggestions are welcome. 2020-08-18 04:55:50.645 DEBUG 10092 --- [ restartedMain] c.a.d.c.internal.RxDocumentClientImpl : Creating a Collection.…
asked 2020-08-18T09:21:26.367+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, 96%, 17%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EMG%3C/text%3E%3C/svg%3E)
Megha Garg
1
Reputation point
commented 2020-08-18T12:25:16.99+00:00
KalyanChanumolu-MSFT
8,316
Reputation points
1 answer
Cosmos DB SDK ReadNextAsync() Throws Exception When Query Has Zero Results (UWP)
Hello, I am using the latest cosmos db sdk (3.12.0 when posted) from a new UWP app. When I call resultSetIterator.ReadNextAsync() I am getting an exception IF the query produces no results. The exception is a CosmosException stating "Response…
asked 2020-08-12T20:07:09.35+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, 46%, 19%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EDG%3C/text%3E%3C/svg%3E)
Dan Guthrie
1
Reputation point
commented 2020-08-18T04:40:25.177+00:00
KalyanChanumolu-MSFT
8,316
Reputation points
1 answer
One of the answers was accepted by the question author.
SQL API vs MongoDB API
Hello !!! I am in a dilemma between the SQL API and the MongoDB API. I have 2 major questions 1) I like MongoDB. But as I can see from the Documentation, I cannot leverage the Azure Function trigger with MongoDB API. I would like to know what other…
asked 2020-08-11T11:49:14.14+00:00
Ahsan Habib
126
Reputation points
accepted 2020-08-13T08:19:03.207+00:00
Ahsan Habib
126
Reputation points
0 answers
azure cosmos db error while creating collection
Hi Team, I am facing below error while creating collection in cosmos database. -- Analytical storage cannot be enabled along with encryption at rest using customer managed keys. please provide me help in solving this error sooner. Thanks &…
asked 2020-08-07T06:23:43.68+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(57.599999999999994, 13%, 15%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EKM%3C/text%3E%3C/svg%3E)
kiran machan
26
Reputation points
commented 2020-08-08T13:29:38.683+00:00
Moamen Hany
1,091
Reputation points MVP
1 answer
Does Cosmos DB support feature like "adaptive capacity"
For the "hot partition" problem, AWS dynamoDB supports adaptive capacity, where the hot partition can have increased limit as long as the total capacity across partitions is still under the limit. …
asked 2020-07-30T21:32:43.467+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, 67%, 17%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EJG%3C/text%3E%3C/svg%3E)
JingJing Gu
1
Reputation point
commented 2020-08-06T09:44:48.107+00:00
KalyanChanumolu-MSFT
8,316
Reputation points