Azure Cosmos DB
An Azure NoSQL database service for app development.
1,494 questions
1 answer
CosmosDb ordering by datetime - high RU
Is there a reason why ordering by a datetime property takes a much higher amount of RU than other properties? However it appears the penalty is only paid on the first page of data. e.g. in one of our collections I get these results: SELECT * FROM c…
asked 2020-06-30T01:26:41.713+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, 42%, 11%)' 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)
Kai Gorman
1
Reputation point
commented 2020-07-29T16:00:54.45+00:00
Mike Ubezzi
2,776
Reputation points
1 answer
Logic App to push data from Cosmosdb into CRM and performing updates
I have created a logic app with the goal of pulling data from a container within cosmosdb (with a query), looping over the results and then pushing this data to CRM. When the data is pushed to CRM, an ID will be created and I wish to then update cosmosdb…
asked 2020-07-24T23:04:55.937+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, 5%, 10%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EJ%3C/text%3E%3C/svg%3E)
Jasmine2020
1
Reputation point
commented 2020-07-28T20:30:53.363+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, 38%, 15%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EQ%3C/text%3E%3C/svg%3E)
QuantumCache
20,106
Reputation points
1 answer
LogicApp that returns newly generated ID back to original source
Hello I am trying to create a LogicApp that first: Extracts data from CosmosDB, using a query Loops over the results Pushes the results data into CRM Sidenote: Once this data is pushed into CRM, CRM automatically generates an ID for each…
asked 2020-07-26T21:29:10.63+00:00
Jasmine2020
1
Reputation point
answered 2020-07-28T19:00:38.59+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, 44%, 13%)' 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)
Samara Soucy - MSFT
5,051
Reputation points
1 answer
Create mongo collection in cosmos with shared throughput with mongodb .net driver
I have an application which uses a cosmosdb with a mongoAPI. The application connects to the db with the MongoDb .net driver to create collections programatically, however it creates the collections without shared throughput. Is there a way to create a…
asked 2020-07-24T16:46:15.927+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, 57.99999999999999%, 16%)' 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)
m. knief
1
Reputation point
commented 2020-07-28T18:07:36.947+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.
Azure Cosmos DB mongo db api: attribute wise count for the records
Hi, I have my data stored in azure cosmos db (Mongo db API), sample of the data is as shown below: currently, i query based on the apptype, my requirement is to show the count of each attribute as well. eg: in the example below, there are two…
asked 2020-07-21T11:03:53.613+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(89.60000000000001, 76%, 18%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EAJ%3C/text%3E%3C/svg%3E)
Alpee Jain
96
Reputation points
commented 2020-07-28T16:00:22.28+00:00
Mike Ubezzi
2,776
Reputation points
2 answers
Azure Cosmos DB - Portal - Error 449 Retry on container creation
Hi there, I try to create a CosmosDB container on my Azure portal. For each attempt, an error 449 is thrown.. We have been adding containers frequently in the last months to this Database. With the API, same result. What could causing this ? …
0 answers
DDL opertaions against Azure Cosmos DB Cassandra API from Spark
Hi, I'm having very strange behavior on DDL operations against Cosmos DB w/ Cassandra API from Spark running in Databricks. When creating a keyspace and table as the following, it does execute the create statements with no errors, BUT it really…
asked 2020-07-07T22:29:17.973+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-07-28T05:37:14.93+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,581
Reputation points
1 answer
Logic App Twitter Connector and Multiple User Names with CosmosDB
Is there a way to have a Logic App or something similar trigger when a tweet is posted by a list of users from Cosmos DB? So many choices and articles, they all show hardcoded search terms. I need some guidance :-)
asked 2020-07-25T16:50:16.433+00:00
David McCarter
1
Reputation point MVP
answered 2020-07-27T09:57:25.517+00:00
Anurag Sharma
17,581
Reputation points
1 answer
One of the answers was accepted by the question author.
Cosmos DB. Why it is getting stuck?
Hi there In my Blazor Server the following code line just get stuck: container = await database.CreateContainerIfNotExistsAsync(typeof(T).Name, partitionId); T is my business class, partitionId is "/FacilityId". It just release the main…
asked 2020-07-17T18:15:05.86+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, 28.000000000000004%, 29%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ENR%3C/text%3E%3C/svg%3E)
Nikolay Renziglov
21
Reputation points
accepted 2020-07-23T14:08:51.02+00:00
Nikolay Renziglov
21
Reputation points
1 answer
How to write a Json file from a csv file
Hello I have got a csv file with an array inside, I need to create a sink data file(json) to be loaded within Cosmos DB, any idea about how to do it? With the csv files i dont have any problem to upload within cosmosDb because I didn't have any…
asked 2020-07-06T21:52:20.84+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, 71%, 19%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ECG%3C/text%3E%3C/svg%3E)
CORONADO GRANADOS Diana Milena
126
Reputation points
answered 2020-07-16T14:18:35.47+00:00
CORONADO GRANADOS Diana Milena
126
Reputation points
1 answer
One of the answers was accepted by the question author.
Azure portal cosmos db page layout problem
Hello, this morning i have gone into the azure portal for viewing the contents of cosmos db containers. There now appears to be a large blank panel on the right of the screen which means that the area for viewing the data is now squashed to a few…
![](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(240, 0%, 33%)' 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
Cosmos DB Migration Tool - SQL Database to Cosmos DB
Hi there, I have data saved in SQL Database, which I'm migrating. I used to save Lat and Lon into a separate column, but for the new implementation, I'm saving lat and lon as GeoJSON point. While migration, I want to save Lat and Lon as GeoJSON on…
asked 2020-07-04T04:50:15.533+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-07-15T20:08:05.06+00:00
Mike Ubezzi
2,776
Reputation points
1 answer
Can't connect to CosmosDB using Cqlsh
Following is the configuration I have In cassandra.yml file content client_encryption_options: require_client_auth: false protocol: TLSv1.2 cqlshrc.sample.ssl file content [authentication] username = username password = password …
asked 2020-07-06T04:31:22.7+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(230.39999999999998, 30%, 32%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EPS%3C/text%3E%3C/svg%3E)
Pushkal Sharma
1
Reputation point
commented 2020-07-09T02:25:18.237+00:00
Mike Ubezzi
2,776
Reputation points
1 answer
One of the answers was accepted by the question author.
Is Apply Free Tier Discount valid when creating an Azure Cosmos DB account with the Azure CLI?
I would like to create an Azure Cosmos DB account with Apply Free Tier Discount enabled using the Azure CLI. However, I didn't find any information that could be set as a parameter, even when I looked at the latest Azure CLI documentation. Is Apply…
asked 2020-07-07T15:00:13.537+00:00
Yuji Masaoka
56
Reputation points
accepted 2020-07-08T09:09:01.827+00:00
Yuji Masaoka
56
Reputation points
1 answer
CosmoDB Handling Request Throttling
Hi there, I'm wondering, how can I properly handle a throttled request, I have forever tried in my Polly, But I'm still getting throttled requests. https://pasteboard.co/Jev0xcQ.jpg Thanks
asked 2020-06-24T01:39:54.057+00:00
Tahmid Eshayat
286
Reputation points
commented 2020-07-04T04:44:22.72+00:00
Tahmid Eshayat
286
Reputation points
1 answer
One of the answers was accepted by the question author.
Cosmos DB Group By
Hi there, We have a requirement, where each of our equipment are sending data and we have to get the first data point of each day and we have to compare it with some other data. So when we are calling the SDK for data I want group the all the equipment…
asked 2020-06-22T03:13:16.6+00:00
Tahmid Eshayat
286
Reputation points
commented 2020-07-04T04:40:05.493+00:00
Tahmid Eshayat
286
Reputation points
0 answers
CosmosDB NodeJS SDK query Timeout
Hello, I am having an issue with a timeout using the Cosmos NodeJS SDK within an async Azure function (HTTP Trigger). I followed the tutorial found here to build the same example. Is this an issue with the async flow or the Cosmos connection? My code…
asked 2020-06-24T19:49:01.583+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, 38%, 30%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EJO%3C/text%3E%3C/svg%3E)
Jason Ortiz
1
Reputation point
commented 2020-07-01T20:13:53.207+00:00
Jason Ortiz
1
Reputation point
1 answer
List Usage API for DB Account is not working Properly
Hi Team , I was using below API to fetch the usages of the DB Account, I was not really successful for fetching the Document Count and other custom filter parameters (Index Size,Storage Capacity)... It is working only for Storage Metric which is…
asked 2020-06-23T12:43:35.147+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(147.20000000000002, 65%, 24%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ERT%3C/text%3E%3C/svg%3E)
Ravi Teja Manchikanti
46
Reputation points
commented 2020-07-01T01:32:25.4+00:00
Mike Ubezzi
2,776
Reputation points
1 answer
One of the answers was accepted by the question author.
Azure Data Factory Data Copy from Cosmos
We have one scenario, where we have to transfer/copy newly added/updated data from cosmos dB to a SQL Server every 2 hours. Currently, data copy copies all the files, can I configure to only copy the newly added/updated ? Thanks
asked 2020-06-26T03:57:27.08+00:00
Tahmid Eshayat
286
Reputation points
commented 2020-06-27T13:57:22.137+00:00
Tahmid Eshayat
286
Reputation points
1 answer
One of the answers was accepted by the question author.
Logic Apps and CosmosDB - Partition Key Troubles
Hello and thanks for reading! I am trying to migrate from an Azure Table Storage instance to CosmosDB as the backing store for my logic app. The logic app is a webhook from Azure DevOps that records selected release information into a table. I've…
asked 2020-06-17T16:09:14.903+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, 91%, 13%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EDL%3C/text%3E%3C/svg%3E)
David Leek
21
Reputation points
accepted 2020-06-26T20:11:18.19+00:00
David Leek
21
Reputation points