I have proxy problems with my .NET app. When running it locally behind a corporate proxy I cannot access the Cosmos DB since it receives the calls from my VPN IP and not the whitelisted proxy-server IP. I manage my…
I want to use multiple COUNT columns in cosmos DB GROUP BY query. I have tried with a query something like this. SELECT c.departmentName, CASE WHEN c.age > 50 THEN COUNT(c.EmpId) ELSE 0 END AS category1, CASE WHEN c.age <=…
I am trying to create a container in which the only property that should be indexed is the /id property. The documentation states: If the indexing mode is set to consistent, the system properties id and _ts are automatically indexed.…
I have a database that has documents with a Version property and Tier property example: { id: "1055984d-01bd-4fbf-877f-0c18ce91552e", Version: 1, Tier: "basic" }, { id: "1055984d-01bd-4fbf-877f-0c18ce91552e", Version: 2, Tier: "standard" } I want to be able to query my documents…
I created my first cosmos db database. In that database, I created a container name person with pid as the partition key. Now I want to create a new container in same database with name order with "pid" as the…
I have for example the below JSON file: [ { "id": "document1", "source": { "pass": { "ploy": { "school": [{ "sourcen": "data" }, { "sourcen": "data1" }, { "sourcen": "data1" } ] } } } }, { "id": "document2", "source":…
My cosmos db query SELECT * FROM c WHERE c.id = "1437156155" AND c.npi = 1437156155 npi is partition key It is consuming 2.83 RUS how to perform Point read so that it consume 1RU sample document { "npi": 1518966761,…
I want to run a poller on azure cosmos container which will run at regular intervals and fire a select query something like -: SELECT * FROM c ORDER BY c._ts DESC LIMIT 100 After selecting the rows, I will…
I have something similar to the following json structure and I need to search for an specific filename in the Azure CosmosDB data explorer (no matter the position), I have been trying differents ways and also using CROSS APPLY FLATTEN…
I have a CosmosDbQuery that works fine but is a bit slow and expensive: SELECT c.actionType as actionType, count(1) as count FROM c in t.processList WHERE c.processTimestamp > @from GROUP BY c.actionType To optimise my query i would like to…