I span up two docker containers: one which houses a CosmosDb emulator image container and another which houses my function app. Both of these containers run in linux using Docker Desktop. I needed to be able to access the cosmosDb…
I am trying to write data to Cassandra table (cosmos DB) via Azure DBR job (spark streaming). Getting below exception: Query [id = , runId = ] terminated with exception: Failed to open native connection to Cassandra at {<name>.cassandra.cosmosdb.azure.com:10350} ::…
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…