Have have following partion id on my container: /vesselId I am trying to add a collection of this object: public class CoachVessel { [JsonProperty("id")] public string vesselId { get; s...

If go to https://portal.azure.com, open our Azure Cosmos DB account (1) --> Data Explorer (2) --> Click on users (3) --> Click on New SQL Query: Azure will open a text box to enter a Quer...

Can I write an UPDATE statement for Azure Cosmos DB? The SQL API supports queries, but what about updates? In particular, I am looking to update documents without having to retrieve the whole docu...

I am new to cosmos db. I chose cosmos db (core sql), created a database having two containers say EmployeeContainer and DepartmentContainer. Now I want to query these two container and want to fetc...

I am integrated my spring boot application with azure CosmosDB-SQL API and for integration test cases i want to use in memory database but trying with H2 in memory it's not working

Below is the code that I have: List<PatchOperation> patchOperations = new List<PatchOperation>(); patchOperations.Add(PatchOperation.Replace("/endpointId", 100)); string id =...

A container has a function called ReadItemAsync. The problem is I do not have the partition key, but only the id of the document. What is the best approach to get just a single item then? Do I have...

I'm trying to patch a child object of a Cosmos Db document using the new Partial Document Update feature. However, I can't find a way to do it. If the document looks like below, how would you updat...

On https://portal.azure.com/ - Cosmos DB Data Explorer, I can execute SQL queries. The result output is 100: SELECT c.email FROM Clients c To reduce the number of network round trips required ...

I am trying to write a parameterized query that has IN clause. For Ex : Working code Input string : "'guid1','guid2','guid3'" public List<Employee> GetEmployeeIds(string ids){ Query...

Entity framework has some nice documentation about Embedding entities but I cannot figure out how to embed a simple string array IEnumerable<string>. Sample class public class Post { public ...

When I try to import CosmosClient from azure.cosmos, I get a ModuleNotFoundError, like the azure-cosmos library was not installed: $ python3.6 -c "from azure.cosmos import CosmosClient" ...

I am New to Cosmos DB. I am retrieving records using SQL API.now i want to add "Not In" in ARRAY_CONTAINS. I did lots of R&D for the same but not able to find out any solutions.

Trying to add a new item into a parent object's child collection. For example, in the code below, how would one go about adding a new Item to the Items collection? { "id": "SalesOrd...

I would like to reduce load on Azure Cosmos DB SQL-API, which is called from a .NET Core Web API with dependency injection. In App Insights, I have noticed that every call to the Web API results i...

We have recently started testing Cosmos DB as a persistent storage for our Orleans Cluster. Our scenario for Cosmos DB is as a Key-Value Store with low-latency and a high amount of Replace, Point R...

Suppose I've the following data in my container: { "id": "1DBF704E-1623-4844-DC86-EFA729A5C048", "firstName": "Wylie", "lastName": "Ramsey&...

I have Collection items in my cosmos db container.My sample data is { "objectID": "abc", "id": "123", "name": "gfh", "descriptio...

I've got a docker-compose project in Visual Studio which starts 3 services. One of them use cosmosdb. I've followed the instructions on https://hub.docker.com/r/microsoft/azure-cosmosdb-emulator/ ...

I'd like to store several different object types in a single Cosmos DB container, as they are all logically grouped and make sense to read together by timestamp to avoid extra HTTP calls. However, ...

I am trying to use the following query to see if I have duplicates in the DB SELECT c.VariantNo, count(1) AS jongel FROM c where c.brand = 'XXXX' AND c.Consumer = 'XXX_V2' GROUP BY c.VariantNo HAV...

I am creating a query to cosmos using Linq This is converted into SQL which is then run to do the search var modelName = "Mondeo"; var baseQuery = client.CreateDocumentQuery<Car>(StaticSett...

Goal: To return the count of distinct values of a particular document field within a partition of a Cosmos collection. Steps: If I run the following query on my Azure Cosmos database, SELECT D...

I've been following the official documentation here: https://learn.microsoft.com/en-us/azure/cosmos-db/sql-api-get-started#Query But I can't figure out how to correctly use a LINQ expression inste...

I've done a bit of research on using session token in cosmosdb's dotnet v3 sdk, and so far I found these two links that give me some hints on how to use it: utilize-session-tokens and how-to-conver...