Azure Cosmos DB
An Azure NoSQL database service for app development.
1,437 questions
1 answer
One of the answers was accepted by the question author.
Azure Cosmos DB container sorting of records
Hi everyone, We have an Azure Cosmos DB container that gets populated with batched entries and currently they get sorted by the "c_ts" JSON value. I would like them to be sorted by "creationDate" value in Oldest to Newest order. …
asked 2024-02-20T21:55:08.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(268.8, 23%, 36%)' 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)
Chris Buley
26
Reputation points
commented 2024-04-02T15:50:24.5733333+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(131.20000000000002, 18%, 22%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EPP%3C/text%3E%3C/svg%3E)
Priya Ponnuram
0
Reputation points
1 answer
How to retrieve data from Cosmosdb using REST API
I'm currently working on retrieving data from Cosmos DB using the REST API, but I've encountered an issue with the authorization header. When I attempt the operation, I'm met with the following error…
asked 2024-03-19T10:14:50.0066667+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, 7.000000000000001%, 36%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EAT%3C/text%3E%3C/svg%3E)
Abhishek Tiwari
0
Reputation points
commented 2024-04-01T23:50:06.5766667+00:00
GeethaThatipatri-MSFT
27,012
Reputation points Microsoft Employee
2 answers
Getting internal serrver error while using query document connector
hi using the query below. This runs fine on the data explorer. However, getting an internal server error while using in query document connector in Power Automate. Can someone please assist? SELECT DISTINCT value c.OfficeBranch From…
![](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, 42%, 36%)' 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)
1 answer
How to prevent Cosmos DB-triggered function app from triggering in disaster recovery region
We are setting up disaster recovery infrastructure, and our Cosmos DB-triggered function apps are firing unexpectedly in the secondary region. Both our change feed function apps in production and DR environments are pointed to the same Cosmos DB resource…
asked 2024-03-29T15:00:32.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(185.6, 28.999999999999996%, 27%)' 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)
Andrew Goldstein
0
Reputation points
commented 2024-04-01T21:59:49.05+00:00
Grmacjon-MSFT
15,606
Reputation points
1 answer
One of the answers was accepted by the question author.
I am trying to provision a Azure Cosmos DB for PostgreSQL Cluster instance using arm template but I don't see a field to set the database name.
I am following this doc - https://learn.microsoft.com/en-us/azure/templates/microsoft.dbforpostgresql/servergroupsv2?pivots=deployment-language-arm-template to provision a Azure Cosmos DB for PostgreSQL Cluster but there is no field to specify the…
asked 2024-04-01T09:18:58.1233333+00:00
Anshul Sharma
20
Reputation points
commented 2024-04-01T16:50:47.6366667+00:00
Anshul Sharma
20
Reputation points
2 answers
Serverless SQL pool query returns NULL for column values
Hi , I have enabled analytical store for my cosmos DB , and trying to create views for the tables in Serverless SQL pool. When I query some table via synapse , It returns NULL for some columns. But I am sure that those columns exist with values in…
asked 2022-01-02T03:36:06.803+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, 67%, 28%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EMR%3C/text%3E%3C/svg%3E)
Mahesh Raja Mahalingam
81
Reputation points
answered 2024-04-01T11:19:57.2833333+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, 59%, 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)
Anup Kasat (TATA CONSULTANCY SERVICES LTD)
0
Reputation points Microsoft Vendor
2 answers
When will the "Filter Vector Search" feature be GA? Seems like this one should be expedited as its a basic need
When will https://learn.microsoft.com/en-us/azure/cosmos-db/mongodb/vcore/vector-search#filtered-vector-search-preview capability be GA? This is a basic requirement for using mongodb vcore for the semantic search use case to improve performance. Would be…
asked 2024-03-25T12:15:07.1766667+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(236.8, 38%, 32%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3END%3C/text%3E%3C/svg%3E)
Nikhil Digde
0
Reputation points
commented 2024-04-01T04:55:32.5266667+00:00
Nikhil Digde
0
Reputation points
1 answer
One of the answers was accepted by the question author.
How to fix MAC signature found in the HTTP request is not the same as the computed signature. Server used following string to sign , in cosmosdb after key rotation
I rotated all the keys at once in the keys plane on the portal. (All older than 470 days). After that getting: Message: {"Errors":["The MAC signature found in the HTTP request is not the same as the computed signature. Server used…
asked 2024-03-30T03:45:24.0533333+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, 76%, 29%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EAW%3C/text%3E%3C/svg%3E)
Adrian Wreyford
45
Reputation points
edited a comment 2024-03-30T15:03:09.9466667+00:00
Adrian Wreyford
45
Reputation points
1 answer
One of the answers was accepted by the question author.
Azure synapse Serverless SQL pool query returns NULL for column values
I have enabled analytical store for my cosmos DB . When I query table via synapse (serverless SQL pool ) , It returns NULL for some columns. But I am sure that those columns exist with values in COSMOS DB I understood the reason for getting null…
asked 2024-03-21T13:59:04.4566667+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, 41%, 26%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EKY%3C/text%3E%3C/svg%3E)
kadirappa yadav
20
Reputation points
commented 2024-03-30T10:27:16.9466667+00:00
Amira Bedhiafi
14,881
Reputation points
1 answer
One of the answers was accepted by the question author.
Cannot Access Azure Cosmos DB for MongoDB(vCore)
I created a Cosmos DB an hour back and I cannot seem to connect to it. I get the following issue: I have this networking setup:
asked 2024-03-29T05:42:56.89+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, 67%, 15%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EZZ%3C/text%3E%3C/svg%3E)
Ziggy Zulueta
455
Reputation points MVP
commented 2024-03-30T01:52:05.69+00:00
Ziggy Zulueta
455
Reputation points MVP
2 answers
Concerns on using Azure cosmos db for a multi tenant architecture.
I am creating a B2B SaaS, which is a multi tenant application. At first I decided to use azure SQL database, however I feel cosmos DB would be a better fit for my needs. The issues I face are mainly on the limitations set for azure cosmos DB resource…
asked 2024-03-25T06:55:18.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(64, 62%, 16%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EGT%3C/text%3E%3C/svg%3E)
Gebriel Tadesse
0
Reputation points
edited a comment 2024-03-29T05:01:55.5266667+00:00
Gebriel Tadesse
0
Reputation points
1 answer
How to create second role assignment for an existing role
I receive an error Updating SQL Role Assignment Principal ID is not permitted. You may only update the associated Role Definition. when I'm trying to create new role assignment with existing role. But I'm not updating role assignment, I'm creating a new…
asked 2024-03-21T18:54:43.2733333+00:00
Konstantin Kulikov
5
Reputation points
edited a comment 2024-03-28T21:14:33.88+00:00
GeethaThatipatri-MSFT
27,012
Reputation points Microsoft Employee
2 answers
CosmosDB Data Migration Tool - Does that support Delta updates?
Hi there Can someone please confirm if Azure CosmosDB Data Migration Tool (https://github.com/Azure/azure-documentdb-datamigrationtool/releases/tag/1.8.3) supports delta updates, i.e., what happens when we re-run the tool to import into a target…
asked 2024-02-28T03:33:13.1466667+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(83.2, 5%, 18%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ETM%3C/text%3E%3C/svg%3E)
Taranjeet Malik
401
Reputation points
edited an answer 2024-03-28T07:42:55.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(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
13,271
Reputation points Microsoft Employee
1 answer
One of the answers was accepted by the question author.
How to union all two tables in CosmosDB？
How to union all two tables in Cosmos DB? Thanks
asked 2024-03-26T08:25:33.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(268.8, 68%, 36%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EXK%3C/text%3E%3C/svg%3E)
Xu, Kyson K
151
Reputation points
commented 2024-03-27T01:21:00.1666667+00:00
Xu, Kyson K
151
Reputation points
0 answers
Not able to connect to cosmos Db in synapse using managed identity in Notebook
YI have try the below steps to connect Azure Cosmos DB using Apache Spark 2 in Azure Synapse Link: Step1: Go to Linked and select the Azure Cosmos DB linked service and test the connection. Step2: Select the container and click on actions => New…
asked 2024-03-22T11:03:06.8333333+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, 1%, 12%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ESD%3C/text%3E%3C/svg%3E)
Sonali Dubey
0
Reputation points Microsoft Employee
commented 2024-03-26T22:04:17.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(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
3,255
Reputation points Microsoft Vendor
2 answers
Cosmosdb acquiring SSL Certificate
Hi I am using Cosmosdb with mongodb API. By default SSL set to true. I need to download SSL CA certificate. However, I couldn't find any source to download it. How can I retrieve SSL CA certificate for my CosmosDB?
asked 2024-03-25T13:23:04.3+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(316.8, 84%, 40%)' 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)
Mert Pehlivan
0
Reputation points
edited an answer 2024-03-26T15:30:03.6066667+00:00
GeethaThatipatri-MSFT
27,012
Reputation points Microsoft Employee
1 answer
Trouble booting up Cosmos DB emulator on localhost
I'm having trouble starting up the Cosmos DB emulator. After loading, the tab shows localhost:8081, but the window displays the following error: "could not complete a secure connection with the following error below: ERR_SSL_PROTOCOL_ERROR". …
asked 2024-03-20T00:22:20.7566667+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(240, 89%, 33%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EGM%3C/text%3E%3C/svg%3E)
Genaro Martínez
0
Reputation points Microsoft Employee
commented 2024-03-26T03:49:11.11+00:00
ShaktiSingh-MSFT
13,271
Reputation points Microsoft Employee
4 answers
Azure cosmos db pricing for restore and backup
I am currently using Azure Cosmos DB for my database needs, and I am interested in understanding how to accurately calculate the cost of data backup and restore. I have enabled continuous backup with a 30-day retention period for my Azure Cosmos DB…
asked 2024-03-19T05:39:01.4033333+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(131.20000000000002, 26%, 22%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EL%3C/text%3E%3C/svg%3E)
lakshmi
551
Reputation points
commented 2024-03-26T03:43:22.72+00:00
ShaktiSingh-MSFT
13,271
Reputation points Microsoft Employee
2 answers
One of the answers was accepted by the question author.
Retirement Announcement - Update to version 3 of the Azure Cosmos DB .NET SDK by 31 August 2024
Because version 3 of the Azure Cosmos DB .NET SDK includes updated features and improved performance, we'll retire version 2.x of this SDK on 31 August 2024. As a result, you'll need to update your SDK to version 3 by that date. If you have a question,…
asked 2021-08-26T23:17:33.397+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, 26%, 28%)' 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)
HimanshuSinha-msft
19,376
Reputation points Microsoft Employee
commented 2024-03-25T22:11:36.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(70.4, 87%, 16%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ERA%3C/text%3E%3C/svg%3E)
Rajith Alwis
0
Reputation points
0 answers
ADF Pipeline Error When Moving Data from one CosmosDB Account to Other
Hi I'm trying to setup a Data Flow to move documents from one CosmosDB collection to another and getting the following error: Job failed due to reason: at Sink 'TargetdevicemanagementeventsINsitpemssharedcosmos': {"innerErrorMessage":"All…
asked 2024-03-20T00:51:13.5633333+00:00
Taranjeet Malik
401
Reputation points
commented 2024-03-25T00:00:55.76+00:00
Taranjeet Malik
401
Reputation points