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.…
So I have a large cosmodb database of documents, I have an index and indexer that will iterate through an build this index. All works great. But if a document is removed from the source database the search index still…
I have an azure function to read and update the cosmos document . I enabled the identity and assigned the following roles to azure function identity(service principal). Somehow I'm seeing the following exception. Could you please let me know the…
I have a two vnets (vnet1 and vnet2) I established a peering between them. I have Web App service with outbound traffic vnet integration set to vnet1. I have a CosmosDb private endpoint in vnet2. I use account endpoint and…
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 have these following inputs. 1.Endpoint 2.Database 3.Collections Based on these inputs needs to establish a connection with Azure Cosmos Db from databricks Tried this approach: installed importted com.azure.cosmos.spark maven package in databricks cluster with the DBR of 11.3LTS and…
I am not sure if I am doing something wrong or cosmos db has a bug in the UI. We are storing a LONG (INT64) value in the database, it seems it is stored correctly, but it is shown wrong…
I'm trying to create on Azure Cosmos DB with MongoDB driver, a new collection. I've reached the limit of 100 collection for account cause it's a serverless account. Now I've deleted some old databases and collection a couple of days…
I have this Models Department.model.js const mongoose = require("mongoose"); const Schema = mongoose.Schema; const Department = new Schema({ departmentName: { type: String, required: true, }, text1: { type: String, required: false, }, text2: { type: String, required: false, }, text3:…