Cosmos DB copy in ADF comes from two regions instead of one region
I have one ADF instance in West US region and I have a Cosmos DB in East US. When running a copy activity in ADF from Cosmos to Azure SQL, I see the copy comes from East US and West US regions. The copy should come just from East US. Could this beavior…
Update to version 3 of the Azure Cosmos DB .NET SDK by 31 August 2024
We received this email stating "we'll retire version 2.x of this SDK on 31 August 2024." What does retirement mean? What will stop working and what will continue to work if i stay on version 2.x
How to run stored procedure for hierarchical partition container
I am trying to run stored procedure from Azure Portal UI. The container has hierarchical partition with two levels. When trying to give the partition key value im providing input as json: {"level1": "value1", "level2":…
Azure Synapse analytics with CosmosDB query is giving null values
Hi Team, we are storing data in Azure cosmos db for mongo and trying to query from Azure synapse serverless pool.when we query with Query items with full fidelity schema we are getting the values else we are getting string:value. can you please help us…
How to use mTLS to secure a sql database
Hi, I'm trying to an managed sql database in Azure using either a managed sql instance or cosmosdb with the postgres interface. However I would like to secure the communication towards it using mTLS since all of the communication will come from…
Batch upload document to Azure Cosmos DB using Perl
I have successfully set up Postman Collections to access Microsoft Azure Cosmos DB via REST APIs by following https://github.com/sajeetharan/CosmosDBPostmanGuide. The next step I need to perform is gather sample JSON data to be batch uploaded to our…
Azure durable functions Activity and CosmosDBInput binding usage
I am using azure durable functions where in from kafka trigger we invoke and orchestrator function which triggers various activities. With in trigger, we store the message with in cosmos db. However we want to further enrich the stored message with in…
Does Azure Cosmos DB for PostgreSQL support logical decoding?
Hi, I want to use debezium to stream CDC events from the Azure Cosmos DB for PostgreSQL cluster. But it seems that I cannot create a user (role) with REPLICATION privilege via the citus user. So how can I get a user with REPLICATION privilege? FYI:…
Metadata permissions clarity
Hello, Having a few doubts related to Metadata permissions. What is metadata read/write permissions? What is the use of it, and whether this permission is required for an user who majorly uses only Azure portal for managing the resources? How to…
How can I implement asynchronous loading into Azure Cosmos DB (Gremlin) with Python 3.10 correctly?
Hello, I have an Event Grid trigger Azure function that takes events, processes them, checks if a vertex exists in the Cosmos DB (Gremlin), and if not, adds this vertex to the database. When the number of events for processing is small, everything…
Why am I asked to update Azure Cosmos DB .NET SDK to version 3 by 31 August 2024? We've never been using version 2 to the best of my knowledge.
Hi, I've received the following email: Update to version 3 of the Azure Cosmos DB .NET SDK by 31 August 2024 You're receiving this email because you've used version 2.x of the Azure Cosmos DB .NET SDK. Because version 3 of the Azure Cosmos DB .NET SDK…
Request blocked by Auth - user does not have required RBAC permission Microsoft.DocumentDB/databaseAccounts/readMetaData
First error is trying to load the FlightExpression items in the azsupportrp-casemgmt-westus db in the azure portal I was told that the cosmos data explorer would resolve the AAD error above so I used this link to access the db…
Cosmos DB read operation timeout after second try with Error Code 500
I am having issues with Cosmos DB where the first read operation succeeds and returns result from DB as expected, but all subsequent reads fail with Error Code 500. The error message mentions a session token not being available. How can I resolve this…
Role required to read/write data from cosmos DB (SQL API) from ADF?
We are trying to read/write data from Azure data factory, since local authentication is disabled in cosmos we are trying to access cosmos DB using managed identity. However even with Cosmos DB Account Contributor role assigned to managed identity of…
Vector Database, Cosmos DB Container. Vector and Indexing policies.
Hello guys, I'm going nuts on this one. I'm trying to build an Azure Cosmos DB Container with the Vector feature, I have enabled the feature of Vector Search for NoSQL API (preview). I first tried to create the container in Azure portal and then…
Azure Cosmos db for mongo api service not showing all the features like data explorer, networking tab in portal
Noticing that azure portal for cosmos db for mongo api not showing all the features recently. Tabs like data explorer, networking and even the overview tab is missing some details. Tried logging out and logging back in but it did not fix the problem.
Cosmos DB Gremlin, DB and Collection Creation via APIs
Is there an API that we can use to Create DB and Collection/Graphs?
How to write a SQL query in ADF lookup activity for cosmos gremlin DB(json data)?
I have the gremlin cosmos db and i loaded the data as vertices and edges. when i am trying to read the data using adf look up activity(select * from grem_db_test), I am getting data in the json format which is fine. But why it's not supporting when i run…
Are custom functions (https://www.mongodb.com/docs/manual/reference/operator/aggregation/function/) available for Azure Cosmos DB for MongoDB?)
Hi, I would like to use the mongodb feature to query a collection using a custom javascript function as describe here https://www.mongodb.com/docs/manual/reference/operator/aggregation/function/. Is this available for Azure Cosmos DB for MongoDB? Or…
Looking for equivalent functionality between dmt and dtui - importing data with id field from JSON into Azure Cosmos
We've started to use the Azure data migration tool since TLS 1.2 support is no longer available in the old Azure documentdb migration tool (DTUI last version 1.83). What we're having issues with, and can't find clarifying documentation on, is when…