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 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…
azure cosmos db error: Error querying documents: An operation on a socket could not be performed because the system lacked sufficient buffer space or because a queue was full.
each time i want to open a collection i got this error ! Error querying documents: An operation on a socket could not be performed because the system lacked sufficient buffer space or because a queue was full. (management.azure.com:443), Payload:…
Create Cosmos DB for MongoDB cluster
Hi guys, I keep getting this error while creating Azure Cosmos DB for MongoDB although there no place to config the previewFeatures when creating Azure Cosmos DB for MongoDB on Azure Portal
All queries from from FHIR server to Cosmos DB failing
We are running an instance of the Azure FHIR Server using Cosmos DB. Since at least 12 hours ago, all queries to the FHIR server are failing with the following exception and trace: 2024-05-08T05:41:26.650255158Z fail:…
Trouble reading cosmos DB account without key based authentication
I recently disabled localauth (key based authentication) in Cosmos DB account. Now, I am not able to access it, neither through data explorer nor through https://cosmos.azure.com/?feature.enableAadDataPlane=true. I am getting this error: principal does…
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",…
Trouble with UUID data when Migrating collection from one Cosmos DB for Mongo DB to another
We are using Azure Data Factory to move a non-prod collection from one Azure Cosmos DB for Mongo DB to another in the same resource group. The are both RU-based resources. I was able to use the "Ingest" template to create a simple pipeline with…
How to build Visualization charts for complex Json data stored in Azure Cosmos DB
Hi, We have a use case to build Visualization Dashboard(charts) on top of complex Json data stored in Azure Cosmos DB. we tried with different approaches 1)we have done some research regarding MongoDB Atlas which has inbuilt feature to develop charts but…
unable to update throughput settings of a sql database container in cosmos db via bicep
I am trying to update cosmos sql container throughput settings via bicep. Bicep deployment is successful however the configuration is not in place... anyone else is facing this? please help.. thank you resource db_account…
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…
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…
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…