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?
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
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.
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…
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…
where can i find cosmsosdb encryption details
I need cosmosdb encryption details for audit
Cosmos DB metric incorrect
Hi folks, I've found a metric in my environment (ServiceAvailability) that is clearly just wrong in some way. By the looks of things either Total is incorrect (should be 4400) or Count is incorrect (should be 1), which is then throwing out the…
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…
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
Trouble reading cosmos DB account without key based authentication
I recently disabled localauth (key based authentication) in Cosmos DB account. Now, I am not able to access it, neither through data explorer nor through https://cosmos.azure.com/?feature.enableAadDataPlane=true. I am getting this error: principal does…
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…
Create Cosmos DB for MongoDB cluster
Hi guys, I keep getting this error while creating Azure Cosmos DB for MongoDB although there no place to config the previewFeatures when creating Azure Cosmos DB for MongoDB on Azure Portal
CosmosDB Analytical store delete changes in sql sink
Hi I am trying to capture delete changes from Azure cosmosdb analytical store using change data capture in Azure datafactory, Source is Cosmosdb, sink is Azure sql database. In between I am flattening my file using dataflow. My insert, update is…
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:…
All queries from from FHIR server to Cosmos DB failing
We are running an instance of the Azure FHIR Server using Cosmos DB. Since at least 12 hours ago, all queries to the FHIR server are failing with the following exception and trace: 2024-05-08T05:41:26.650255158Z fail:…
Change password in Azure CosmosDB MongoDB Vcore
I created the database mentioned above and I want to change the password. I checked online and this was the way to do it. But it seems Azure is not supporting it. So how do we change the password? db.changeUserPassword("accountUser",…
Trouble with UUID data when Migrating collection from one Cosmos DB for Mongo DB to another
We are using Azure Data Factory to move a non-prod collection from one Azure Cosmos DB for Mongo DB to another in the same resource group. The are both RU-based resources. I was able to use the "Ingest" template to create a simple pipeline with…
How to build Visualization charts for complex Json data stored in Azure Cosmos DB
Hi, We have a use case to build Visualization Dashboard(charts) on top of complex Json data stored in Azure Cosmos DB. we tried with different approaches 1)we have done some research regarding MongoDB Atlas which has inbuilt feature to develop charts but…
unable to update throughput settings of a sql database container in cosmos db via bicep
I am trying to update cosmos sql container throughput settings via bicep. Bicep deployment is successful however the configuration is not in place... anyone else is facing this? please help.. thank you resource db_account…
Synapse Scala | Read Cosmos DB Container data using managed identity
Hi Team, I tried reading Cosmos data using Managed Identity inside a Synapse Scala notebook, but it's not working as expected. Already provided access for synapse workspace by using below command New-AzCosmosDBSqlRoleAssignment -ResourceGroupName…