azure-cosmosdb-sqlapi

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…