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'm writing a Data Flow in which I make an upsert to a Cosmos DB NoSQL database. My goal is to use a field called batch to keep track of the date of insertion of a particular document, that is,…
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…
I am fairly new to Azure cloud development. I have a function app coded in C# that: Gets a record from a storage table Deletes that record Updates fields on that record (including the partition key) inserts the new record…
I want to take the raw JSON body from an HTTP post and write it directly into my CosmosDB. Let's say the data looks like this: { "id": "123456", "storeName": "City Bar and Grille", "invoiceTotal": 65 } However, the documentsOut.AddAsync…
Below is the total requests metric of various 'operationtype' against a particular cosmosdb collection. What does particularly "Execute" and "Readfeed" operation type mean? Below metrics does not cover the operations performed via stored procs as mentioned here, so how to…
I have a CosmosDB (using a MongoDB api) running at a avg load of 30% (of its RUs). Very sporadically (like twice a week) there's a huge spike that takes it to 100% for about 1-2 minutes, so I usually…
I am deploying to an azure synapse environment queries using sqlcmd to serverless pool. The environment contains an SQL database that my deploying account has access to. I am creating first the credentials to access a cosmosDB with : CREATE…
I am trying to create a new Azure CosmosDB account in terraform account using: create_mode = "Restore" Basically I am trying to restore from an existing DB, and the code needs another input attribute, of the source DB: "source_cosmosdb_account_id" =…
I am setting the TTL on my Cosmos Container to 1 to force the deletion of all items, I then query SELECT VALUE COUNT(1) from c to check that all items are deleted before setting TTL back to its previous…