Azure Cosmos DB

1 answer

Azure Cosmos Database and conversations chatbot

We have build a chatbot using Azure Open Ai and chatbot histories are saved in Azure Cosmos Data Base. How can we access these conversation and download them in a report or connect to Power BI ? What is the best way

asked

Manea, Daniela 0

answered

Dillon Silzer 54,291

1 answer

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';…

asked

David Baker 21

edited a comment

Sina Salam 3,476

3 answers

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…

asked

Wang Kangli 75

commented

Abbasi, Safan 0

2 answers

How do you set up a Cosmos DB custom endpoint in IoT Hubs?

Saving messages from the IoT Hub directly into Cosmos DB via a custom endpoint is a new feature currently in preview. I'm following the official instructions located here:…

asked

Meghan Clark 10

commented

Adrien Bourdeaux 0

1 answer

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…

asked

Ankur Gupta 0

commented

Ankur Gupta 0

3 answers

I already created an Index for MongoDB vCore, but when I query that database, I get the error 'Similarity index was not found for a vector similarity search query'

Here is my code for creating the collection. When I run it, I see that an index was created. However, when I try to query the database using a vector, it says that there is no index, as in the error above: import pymongo import openai from openai…

asked

Tyler Suard 55

answered

GeethaThatipatri-MSFT 27,017 Microsoft Employee

1 answer

Postgres Parameter Missing from Parameter List.

I am using Cosmos DB for Postgresql, with 2 worker node + 1 coordinator node. I want to set max_locks_per_transaction parameter for postgresql. I have a partioned table which I then sharded with Citus command, but I am unable to unshard, because I am…

asked

Vishnu Agarwal 0

commented

ShaktiSingh-MSFT 13,271 Microsoft Employee

1 answer

Azure Functions HTTP Trigger Not Updating Cosmos DB Visitor Count on Live Website

I'm working on a serverless resume website using Azure Functions with an HTTP trigger to increment a visitor count stored in Azure Cosmos DB. The functionality was working perfectly during development, but after deploying to the live website, the visitor…

asked

Mohammadfaizan Shaikh 0

edited the question

KapilAnanth-MSFT 34,766 Microsoft Employee

1 answer

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.…

asked

Gebriel Tadesse 0

answered

Amira Bedhiafi 15,046

1 answer

Need Consistency levels in Azure Cosmos DB for Postgresql (like in NoSQL)

Hi, I came across with a data inconsistency in my Citus cluster, when I did classic money transfer test: init.sql: create table mytbl (id serial primary key, amount int); insert into mytbl(amount) select 0 from generate_series(1, 1234567); select…

asked

Konstantin Morozov 0

edited the question

GeethaThatipatri-MSFT 27,017 Microsoft Employee

1 answer

Azure cosmos DB is not scaling

Hi team, I have a timeseries data that I want to store in azure cosmos db. I have a very simple document consisting of name, price, date, create_time, update_time. I have about 15 million entries in my collection though. This is a provisioned server with…

asked

hexawealth 0

answered

Sajeetharan 1,566 Microsoft Employee

2 answers

While fetching data from cosmos db conatiner and persisting the json file in ADLS Gen 2 through Synapse Pipeline, some objects in my json file are appearing as blank string causing data loss. This is happening in PROD only not in UAT and DEV.

Hi, The issue i am facing is with the Synapse Analytics Service - Pipeline. I have created a dataflow which is pulling data from cosmos db container in json format and storing that json file in ADLS Gen 2. When I check the json file in ADLS I see that…

asked

Vity Pandita 0

commented

Vity Pandita 0

1 answer

Is it possible and how to identify Rate Limit Exceedance in CosmosDB for MongoDB Using the Standard MongoDB SDK

Hi There, We are using standard mongodb SDK to access CosmosDB for MongoDB. Sometimes it reaches the rate limit and reject many requests. We need to identify this scenario and stop sending documents for a while. Could you please how to achieve it through…

asked

Aaron Tan 20

accepted

Aaron Tan 20

1 answer

How to pass a custom query to CosmosDB's Synapse Link & Does Synapse Link support predicate pushdown?

Hello! I have been trying to connect Synapse Notebook to Cosmos DB via Synapse Link, and I have a couple of questions regarding optimizations: If I want to process one day of data, I managed to find two ways of doing it: Pass a custom query with…

asked

Alibek Cholponbaev 20

accepted

Alibek Cholponbaev 20

2 answers

I want to store data from IoT Central to CosmosDB in real time.

Hello. I monitor telemetry data with IoT Central. I want to flow the telemetry data I am receiving in IoT Central to Cosmos DB in real time. Is there any way to do this? Thanks in advance.

asked

Hinata Katsunori 536

accepted

Hinata Katsunori 536

2 answers

Does CosmosDB for MongoDB honour the ordered writes parameter for inserts during bulk write operations?

I'm using the MongoDB Java Driver version 4.8.2 to insert around 10000 documents with upsert enabled using bulk write operations. I've enabled ordered writes and disabled the Server Side Retry feature. My MongoDB server version is 4.2. However, I'm…

asked

Kiruphasankaran Nataraj 0

commented

Oury Ba-MSFT 16,076 Microsoft Employee

1 answer

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…

asked

Subhajit Mondal 10

edited a comment

Krarzia, Mahmoud 0

1 answer

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…

asked

Sai Praneeth Eranti 75

commented

GeethaThatipatri-MSFT 27,017 Microsoft Employee

4 answers

In Azure OpenAI Studio, I'm working on Chat Playground, trying to connect to my own Azure Cosmos DB for MongoDB (vCore). I can't select an index name; there's no dropdown. What's the issue?

In Azure OpenAI Studio, I am currently engaged in the Chat Playground project, where I am endeavoring to establish a connection to my personal data source via Azure Cosmos DB for MongoDB (vCore). I have encountered a predicament during the selection of…

asked

Siravich Piboonworachat 5

answered

Robert Falcone 0

1 answer

How to limit an Authorized user, using Entra Id, to only retrieve records that the user owns, while using a Static Web App, Data API builder for ComosDB, and ownership is determined by a deviceID (a mac address) in the Body (IoT) data.

I have created a Static Web App, that is up and running, with a Database Connection to a Cosmos DB database. I have the necessary schema.gql, and config.json set up. The user needs to be able to connect to the Database using the /data-api/graphql…

asked

Adrian Wreyford 45

edited the question

ShaktiSingh-MSFT 13,271 Microsoft Employee

Filter

Content

1,440 questions with Azure Cosmos DB tags

Azure Cosmos Database and conversations chatbot

Cosmos Synapse link SQL query error

What should I do about the Azure Function Http trigger not connecting to Cosmos DB?

How do you set up a Cosmos DB custom endpoint in IoT Hubs?

golang sample to connect to cosmosdb-gremlin

I already created an Index for MongoDB vCore, but when I query that database, I get the error 'Similarity index was not found for a vector similarity search query'

Postgres Parameter Missing from Parameter List.

Azure Functions HTTP Trigger Not Updating Cosmos DB Visitor Count on Live Website

Understanding TCP Connection Limits for Azure Container Apps with Cosmos DB

Need Consistency levels in Azure Cosmos DB for Postgresql (like in NoSQL)

Azure cosmos DB is not scaling

While fetching data from cosmos db conatiner and persisting the json file in ADLS Gen 2 through Synapse Pipeline, some objects in my json file are appearing as blank string causing data loss. This is happening in PROD only not in UAT and DEV.

Is it possible and how to identify Rate Limit Exceedance in CosmosDB for MongoDB Using the Standard MongoDB SDK

How to pass a custom query to CosmosDB's Synapse Link & Does Synapse Link support predicate pushdown?

I want to store data from IoT Central to CosmosDB in real time.

Does CosmosDB for MongoDB honour the ordered writes parameter for inserts during bulk write operations?

Unable to update Cosmos DB documents with Hierarchical partition keys using Azure Stream Analytics job

Enforcing RBAC as the only authentication method in Cosmos DB

In Azure OpenAI Studio, I'm working on Chat Playground, trying to connect to my own Azure Cosmos DB for MongoDB (vCore). I can't select an index name; there's no dropdown. What's the issue?

How to limit an Authorized user, using Entra Id, to only retrieve records that the user owns, while using a Static Web App, Data API builder for ComosDB, and ownership is determined by a deviceID (a mac address) in the Body (IoT) data.