Cant choose Key for upsert, in Copy Data-activity
I want to copy Data from an Azure SQL to a comsosdb container, with the copy data activity of Azure Synapse. As I cannot enter the uniqe key column, for the upsert behaviour, i receive a unique key violation error. Why is there no option to select the…
Query Conversion to Point Reads
Hello , Is there a way to identify eligible queries that can be transformed into point read queries using metrics or a Kusto query?
Please update to Azure Cosmos DB extension version 4.x for Azure Functions.
I had receiving a mail. tell me to update Azure Cosmos DB from version 3.x to 4.x. but I didn't use this server. why I can received the mail. Can you tell me how to check it or which function use it. I didn't have and idea. thank you.
Design two containers in Azure Cosmos DB for anonymous and sign-in users
We want to store the user's click on website into Azure Cosmos DB. We want to design two containers in a single Azure database, SampleDB. One container is to store the documents for anonymous user clicks on product detail page, one container is to store…
How to connect to Azure Cosmos DB for MongoDB vCore via a private endpoint from app service?
Hi everyone, I'm having trouble connecting to the mongodb from one of my web app. It used to work perfectly until a private endpoint was configured. I tried to replace the domain name in the connection string with the FQDN. I got this…
Missing Cosmos DB Built-in Data Reader and Cosmos DB Built-in Data Contributor roles
Hi, I'm trying to to connect to a CosmosDB using the Java Azure SDK, and I'm getting a 403 with the following message: Request blocked by Auth **** : Request is blocked because principal [*****] does not have required RBAC permissions to perform…
Microsoft.Azure.Cosmos.CosmosException : Response status code does not indicate success: ServiceUnavailable (503); Substatus: 20001;
I am using Cosmos Client to run a query. I am getting this error continuously. I have added retry mechanism and even reran the project multiple times, but I am getting the same error. Is there any change I have to do in the resource to get rid of this…
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:…
Microsoft Azure CosmosDB for MongoDB Deprecated Classic Metrics: Data+Index Size Consumed Per Partition Key Range
Hi All, Given the Monitor Classic Metrics was deprecated. I would like to know is there any way to know the data size consumed per partition key for CosmosDB (MongoDB)? I had explored the Metrics in Monitoring blade at Azure Portal, but seems I could…
The best database in Azure to manage real time data operations.
Hello Experts, I have to manage some real time stock updates between more than 2 online portals and we are thinking to go with Azure Services. And also think to store data in Azure Database services. Hence, we are looking for the database that must be…
Received Error 'Unexpected end of JSON input' When Browsing Cosmos DB with the Data Explorer in Portal
Hi There, I wonder what happens behind the scene. I don't need to do anything to fix it, just keep refreshing the web page until it works, it could take 2 mins or 1 hour to get it work. Thanks.
The input authorization token can't serve the request. The wrong key is being used or the expected payload is not built as per the protocol.
Hi all engineers, hoping to get some assistance on above error. Looks like permission issue. Created a user and assigned the role however, when the user is trying to modify the code, getting an error. If anyone in this channel has any solution, it would…
Cosmos DB Rest API - unable to get document after passing partition key
Trying to get a document by its id using the following API (https://learn.microsoft.com/en-us/rest/api/cosmos-db/get-a-document). However, after providing the value for x-ms-documentdb-partitionkey I keep getting a not found error message despite the…
Having problem with Azure sandbox storage account
Hi, I am having issue to access to storage account in Azure sandbox environment. I have login to Azure sandbox environment, but not able to access to Azure storage account even though my subscription is selected as sandbox. Capture.PNG
Azure Cosmos DB create index error cosmosSearchOptions code 197 InvalidIndexSpecificationOption
I am following this tutorial about taking advantage of Azure Cosmos DB for Mongo DB vCore's vector similarity search functionality. To do so, I created a Cosmos DB resource using "Try Azure Cosmos DB" with a resource group located in East US. I…
Missing Cosmos DB Built-in Data Reader and Cosmos DB Built-in Data Contributor roles in Access Control (IAM)
I'm trying to assign roles to managed identity in Cosmos DB, through browser using Access Control (IAM). Unfortunately two build in roles Cosmos DB Built-in Data Reader and Cosmos DB Built-in Data Contributor are not there. How can I add managed…
where can i find cosmsosdb encryption details
I need cosmosdb encryption details for audit
How to use Azure Cosmos DB REST (Data plane) API with AAD RBAC?
I am attempting to make a REST request following these instructions which states "The Azure Cosmos DB RBAC is currently supported with the 2021-03-15 version of REST API." Yet when I make a request I get the response "Invalid API version.…
Not getting access with newly created user in cosmosdb for mongodb
I have created user in consmosdb for mongodb api with built-in role but while accessing with newly created user getting Error: invalid salt length provided
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…