How to load all objects from Event Grid into Cosmos DB for Gremlin
Hello, I created a blob_trigger Azure function that takes an input blob and retrieves objects from it. These objects are then sent to Event Grid. Additionally, there is a second event_grid_trigger Azure function that should take these objects and load…
Synapse Scala | Read Cosmos DB Container data using managed identity
Hi Team, I tried reading Cosmos data using Managed Identity inside a Synapse Scala notebook, but it's not working as expected. Already provided access for synapse workspace by using below command New-AzCosmosDBSqlRoleAssignment -ResourceGroupName…
Change password in Azure CosmosDB MongoDB Vcore
I created the database mentioned above and I want to change the password. I checked online and this was the way to do it. But it seems Azure is not supporting it. So how do we change the password? db.changeUserPassword("accountUser",…
How do I create a dynamic SQL query for Cosmos DB using Azure Data Factory?
I am doing a simple data flow where I have a source from a cosmos db container, I want to get the latest data that is greater than a _ts value that I store in a variable (SELECT * FROM c WHERE c_ts > @variables('LastRunDateTS')). How can I pass this…
What should I do about the Azure Function Http trigger not connecting to Cosmos DB?
I am learning the module called "Chain Azure Functions together using input and output bindings". The previous modules are learning without any problem and can successfully access the http trigger via url. But in this module, I have…
CosmosDB Analytical store delete changes in sql sink
Hi I am trying to capture delete changes from Azure cosmosdb analytical store using change data capture in Azure datafactory, Source is Cosmosdb, sink is Azure sql database. In between I am flattening my file using dataflow. My insert, update is…
How to control Priority-based executions in Azure Cosmos DB
Hi Team , I would like to know , How I can leverage this feature in a better way . Suppose , RU consumption is 100% if I want to do a transaction , How can I make it a priority ? Should I specify priority "high" at the time of querying like…
Join cosmos DB when processing streaming data from eventhub in Synapse
Hi Team, Good morning! Would like to check that when we using spark notebook in Synapse to process Eventhub streaming data, we join the streaming data from Eventhub with CosmosDB data. We try both way of connecting CosmosDB transcational store with OLTP,…
Azure Cosmos DB container sorting of records
Hi everyone, We have an Azure Cosmos DB container that gets populated with batched entries and currently they get sorted by the "c_ts" JSON value. I would like them to be sorted by "creationDate" value in Oldest to Newest order. …
Enforcing RBAC as the only authentication method in Cosmos DB
Hello , How can I enforce Role-Based Access Control (RBAC) as the only authentication method in Cosmos DB? I received this recommendation on one of my Cosmos accounts last year, and I would like to know if there are any Microsoft documentation…
Cosmos DB Security if given public access & how to access from outside VNET if changed to private.
I was wondering what are the security implications with creating a CosmosDB account with Public access? And if there is any way to access by a NodeJS app which is outside the VNET if the db is set to be private. Let me explain a bit in detail. I'm…
Azure vCode based cosmos DB for mongo DB Quick Start
I have created Azure vCode based cosmos DB for mongo DB account. When i click on "Quick Start" for further testing. It always throws me error "Connection Failed We are unable to connect to the temporary workspace." I have configured…
Cosmos free tier Opt out option is not available.
Is it possible to opt out of the free pricing tier for Azure Cosmos DB once a compute pricing model and API are chosen? According to Microsoft documentation, it seems that once a compute pricing model and API are selected, opting out of the free tier is…
Unable to update Cosmos DB documents with Hierarchical partition keys using Azure Stream Analytics job
I have document in Cosmos DB with Hierarchical partition keys. I want to patch certain property value. But while running the job I am getting this error👇 The streaming job failed: Stream Analytics job has validation errors: Error connecting to…
Why does updating the firewall IP configuration in Azure Cosmos DB result in slow performance?
When utilizing GitHub Actions to update the networking firewall settings of CosmosDB, the process of adding a single IP address requires approximately 8 minutes to complete. Similarly, the removal of an IP address from the firewall settings also takes an…
Understanding TCP Connection Limits for Azure Container Apps with Cosmos DB
I'm developing an ASP.NET Web API for handling CRUD operations with Cosmos DB and plan to deploy it on Azure Container Apps. My setup involves using multiple CosmosClient instances connected to different accounts, aiming for a multi-tenant architecture.…
How to set/check database-level throughput for CosmosDB with MongoDB API?
Hi I'm using CosmosDB with MongoDB API and I currently use a database instance to save IoT time series data from multiple machines in a dedicated collection per machine. Recently, all of the azure resources were moved (through a service provider) from…
Azure Cosmos DB Data Explorer
Hello! I'm looking for the "Data Explorer" in Azure Cosmos DB (MongoDB Atlas), I cannot find it anywhere on my view. Is it because I am still on the Free subscription? Or has this feature been removed? TIA
golang sample to connect to cosmosdb-gremlin
Hi, need a golang sample to connect to cosmosdb-gremlin over wss, preferably using Primary key or connection string? So far I have tried gremlingo, gramess etc but nothing resulted in successful connection. Thanks on advance for any pointers. So far I…
Cosmos Synapse link SQL query error
Hi, we have a Synapse SQL View onto a Cosmos container (using Synapse link). When we run a SELECT * on the view we sometimes get this error: Resolving CosmosDB path has failed with error 'CosmosDB request failed with status code '449';…