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 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…
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…
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…
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…
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":…
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…
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…
How to clone cosmos gremlin api db from one environment to another environment
Hi All, We want to copy Azure comos db gremlin api data from one suscription to another subscription. Is there anyway to do that?
resiliency test on SQL Cosmos DB
I'm planning for the resiliency test on SQL Cosmos DB: I intended to halt operations on our SQL Cosmos DB. This action is necessary to monitor the application’s behavior in the absence of database connectivity. Is there any way to take one of DB offline…
CosmosDB Data Explorer is not connecting to my DB account. How can I fix?
Hi, I having been using my CosmosDB account for over a year without any issue. I am unable to connect to or view my DB account using the Cosmos Data Explorer. I've tried from the menu option on the portal, and from cosmos.azure.com, with the same…