Azure Cosmos DB

0 answers

Is there a way to make CosmosDB Data Explorer respect ETag when updating a document in the browser?

Hi, I would like to be able to manually update certain things in my CosmosDB container without having to worry about an application potentially overwriting the change/having its change overwritten by me. I tried this with two browsers by opening the…

asked

Alfred Kristal 0

edited the question

Alfred Kristal 0

1 answer

Integer typed column with NULL values in Analytical Store getting converted to 0 in Azure Synapse

I have a container A- container A has a column colA with integer as it's datatype in the AnalyticalStore , how do I know that? When I import the projection for the source it get's imported as integer. But I have overwritten the schema and set colA to…

asked

Nandu S Raj 40

commented

Chandra Boorla 4,690 Microsoft Vendor

0 answers

How to use System Assigned MI to access Blob Storage and Cosmos DB in Synapse Analytics

Hi, I am trying leverage the default system assigned managed identity a synapse workspace provides to access blob storage and cosmos db. I have already tried the following steps which I saw in various posts: Assign Role to Managed Identity: Navigate…

asked

Haria, Neel 0

commented

Ganesh Gurram 1,920 Microsoft Vendor

1 answer

How is the property stored when it has a different datatype that the base schema?

In this MS Analytical store docs link , it says that the analytical store doesn't "include" a property if it's of a different type than it's base schema. Just out of curiosity , does it mean in the column store it stores null against that…

asked

Nandu S Raj 40

commented

Ganesh Gurram 1,920 Microsoft Vendor

1 answer

Cosmos db 1RU point read latency never below 20 ms

Hi, so we have several asp net core apis .7 or 8 (app services) where we are seeing average latencies for 1 RU point reads are between 20-25 ms on average in the last 30 days. The lowest registered was 10 ms. Looking at the SLA we should almost…

asked

Erik Eriksson 0

commented

Sai Raghunadh M 1,295 Microsoft Vendor

1 answer

Does Azure cosmos DB for Postgresql support oracle_fdw extension?

Can you please confirm if Azure Cosmos DB for Postgresql provides oracle_fdw extension to enable creating foreign tables in Postgresql that connects to the Oracle tables or schemas? I know it's been mentioned that oracle_fdw is available for Azure…

asked

Nick Chuah 0

commented

NIKHILA NETHIKUNTA 3,765 Microsoft Vendor

1 answer

IotHub custom endpoints, 9 of 10 used, Azure portal keeps failing to create 10th

Good day, Been trying over and over for quite some time to create the 10th custom endpoint in our IotHub, in the Azure Portal. I keep getting an internal error and told to contact support, but don't have a support plan. We are not on the free tier but…

asked

Adrian Wreyford 45

answered

Sander van de Velde | MVP 33,636 MVP

0 answers

Azure Data Factory Map Drift generating expressions with functions that don't exist

I'm building a data factory pipeline for my NOSQL cosmos DB. one of my columns is an array of objects. the data preview seems to be able to identify it fine but when I try to derive columns for it using the "Map Drift" button it will try to…

asked

David Petika 0 Microsoft Employee

commented

Smaran Thoomu 18,230 Microsoft Vendor

3 answers

Can't connect to free tier mongo cluster

I am trying to connect to my Free Tier mongo cluster. Through MongoDB Compass I get this error: Server record does not share hostname with parent URI. It seems like a DNS issue, anyone else who has encountered the same issue?

asked

Michael Katsoulakis 0

answered

ShaktiSingh-MSFT 16,001

2 answers

Best way to read from MongoDB change streams from within Azure

Hello! We have an application that needs events from our MongoDB change stream and insert the change event into Data Lake storage. We cannot use MongoDB Triggers to call an Azure Function because we have no way of authenticating the Trigger (we have been…

asked

Jaime Becker 20

commented

Vijayalaxmi Kattimani 575 Microsoft Vendor

1 answer

Cosmos DB failover using private endpoints in 2 regions | privateDnsZones/A mismatch

Hello, I cannot find a valid documentation for this setup. Issue: privateDnsZones recordset type "A" do not reflects private endpoints regionality. Initial set up: CosmosAccount georeplicated: read-write=EAST US, read=WEST US --> so…

asked

Pasquini, Matteo (Admin) 40

answered

Mahesh Kurva 1,155 Microsoft Vendor

1 answer

Getting "'_FullTextWordCount' is not a recognized built-in function name" while attempting RRF ranking.

I'm attempting to use a hybrid (FullText and Vector) query as prescribed in https://learn.microsoft.com/en-us/azure/cosmos-db/nosql/query/rrf. The query: SELECT TOP 5 c.content FROM c WHERE c.context="[CONTEXT VALUE]" ORDER BY RANK…

asked

Vargas, Justin J 0

commented

NIKHILA NETHIKUNTA 3,765 Microsoft Vendor

0 answers

requests from synapse pipelines blocked by firewall policy of cosmDB.

hello team, the requests are getting originated from synapse analytics pipelines to nosql coosmosDB. the requests are getting blocked by firewall settings of cosmosdb as the request IPs are different one for every run and requesting through public…

asked

ANKIT GHENGE 40

commented

ANKIT GHENGE 40

0 answers

BCDR for cosmobd: error AZ migration capability is disabled for subscription

I am trying a failover in the cosmodb and I could offline the primary region and now the prefered region is online and able to write and read the data. Now I am trying the fallback to primary region again and tried to make primary region online again but…

asked

Polamuri Krishna Chandra 10

commented

Oury Ba-MSFT 19,886 Microsoft Employee

1 answer

Serverless Throttling?

Hi. I have written a method using the guidance at https://learn.microsoft.com/en-us/azure/cosmos-db/nosql/tutorial-dotnet-bulk-import. To shorten the code I have removed most logging. It looks something like this (questions follow): public async…

asked

MikeM-8643 20

accepted

MikeM-8643 20

5 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 80

commented

Sieradzki, Benjamin 0

1 answer

Cosmos DB and Container RU Configuration and cost

Hello: qq about Cosmos DB and Container RU Configuration and cost. I know you I set RU on DB or Container Level when I create it or even on both, but wonder how does billing works. For simplicity, let's say I have just one DB and one Container under…

asked

Oleg Aronov 131

commented

Oury Ba-MSFT 19,886 Microsoft Employee

1 answer

Cosmos Synapse Link - SQL Serverless Query

Please describe your issue below I have a Cosmos database in Well-Defined schema mode. I have a Synapse Serverless SQL instance. I have documents in Cosmos with objects that contain fields with null values. When I create a View for the Container in SQL…

asked

David Baker 0

answered

phemanth 12,320 Microsoft Vendor

1 answer

Data Loading Delay from Azure SQL DB to Cosmos DB Containe

We are experiencing an issue when loading data from Azure SQL to Cosmos DB. The process is extremely slow; for example, loading just 5 million rows takes around 3.5 hours. Additionally, we are unable to load data into a hierarchical partition-enabled…

asked

Mahesh Sanga 0 Microsoft Employee

commented

Chandra Boorla 4,690 Microsoft Vendor

1 answer

How to change networking to connect IoTHub to CosmosDB in private subnet

Hey community! The question: How do I connect my Azure IoTHub to my CosmosDB in private subnet? How I can change the CosmosDB networking/firewall settings to accept traffic coming from a (public) IoTHub service endpoint? Brief description: I have an…

asked

Quincy 10

answered

Andriy Bilous 11,536 MVP

Filter

Content

1,700 questions with Azure Cosmos DB tags

Is there a way to make CosmosDB Data Explorer respect ETag when updating a document in the browser?

Integer typed column with NULL values in Analytical Store getting converted to 0 in Azure Synapse

How to use System Assigned MI to access Blob Storage and Cosmos DB in Synapse Analytics

How is the property stored when it has a different datatype that the base schema?

Cosmos db 1RU point read latency never below 20 ms

Does Azure cosmos DB for Postgresql support oracle_fdw extension?

IotHub custom endpoints, 9 of 10 used, Azure portal keeps failing to create 10th

Azure Data Factory Map Drift generating expressions with functions that don't exist

Can't connect to free tier mongo cluster

Best way to read from MongoDB change streams from within Azure

Cosmos DB failover using private endpoints in 2 regions | privateDnsZones/A mismatch

Getting "'_FullTextWordCount' is not a recognized built-in function name" while attempting RRF ranking.

requests from synapse pipelines blocked by firewall policy of cosmDB.

BCDR for cosmobd: error AZ migration capability is disabled for subscription

Serverless Throttling?

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

Cosmos DB and Container RU Configuration and cost

Cosmos Synapse Link - SQL Serverless Query

Data Loading Delay from Azure SQL DB to Cosmos DB Containe

How to change networking to connect IoTHub to CosmosDB in private subnet