Permission on subscription when creating Azure Synapse workspace
I want to create a workspace subscript on Cosmos-bingads-bi, the website prompts me that I do not have the permission. Where should I apply for the permission?
Microsoft.Azure.Cosmos.CosmosException on PartitionKey
Hi. I have an old CosmosDB environment that was original accessed by DocumentDB client. the current partition key on the collection is listed in "settings" as /header.code and when a document is submitted I can see the value of the key in the…
How to read data users.csv.gz?
Hi, I am referring link https://learn.microsoft.com/en-us/azure/cosmos-db/postgresql/quickstart-distribute-tables And getting this error: citus=> SELECT * FROM create_extension('azure_storage'); create_extension (1 row) citus=> COPY…
How to get Employees Hierarchy
Hi, My requirement is as follows: I would like to obtain Employee Wise Hierarchy (Bottom Employees to Top Employees) using SP. Note (Role): NH is Level-1(Top Level) VH is Level-2 AVP is Level-3 RM is Level-4 DRM is Level-5 BM is Level-6 TH is Level-7…
CosmosDB API | How to get the logical data size for a given partition
Hi, I need to get the logical size of a given partition using the CosmosDB API, but I did not find anything in the SDK or with a web search. As there is a 20Gb limit on that logical size, it makes sense to have a way to get that size, so I probably…
I can't find the URL for my Azure Cosmos DB for MongoDB (vCore)
Hi, I want to create a simple HTTP Endpoint API but, I can't find the URL for my Azure Cosmos DB for MongoDB (vCore) are there any simple way like the Mongodb HTTPS endpoint API I have use Mongodb Atlas before and it's really easy and simple…
Assign Entra ID user to CosmosDB PostgreSQL role using CLI/BICEP/Powershell
Hi there, We are using CosmosDB PostgreSQL Cluster and wish to use Entra ID authentication for all users. We build our environment completely via IaC using Bicep and CLI, but can't find how to create the roles for the Entra…
Cosmos DB - Failed to change the ID after it has exceeded 300 characters.
On 2023-03-23, we create a new CosmosDB Account. And then we found something wrong. Failed to change the ID after it has exceeded 300 characters. we change the ID of the data to one over 300 characters. it succeeded After that, failed to change the…
Only one usage of each socket address (protocol/network address/port) is normally permitted.
I'm using .NET 6 Web API with COSMOSDB and facing issue like Only one usage of each socket address (protocol/network address/port) is normally permitted. when requesting many more APIs calls
Azure CosmosDB deployment - "LocationNotAvailableForResourceType
Hello, What is the proper resolution to add additional locations for azure cosmod db deployment? {"code":"LocationNotAvailableForResourceType","message":"The provided location 'eastus2euap' is not available for…
Document returned by AI Search is missing content
Hi, I am using AI Search to retrieve documents from Cosmos DB and my documents contain a list of objects that the index is configured to retrieve. For some documents, I can see the list of objects perfectly, but for others, the list is empty (when…
How to sign in to Azure CosmosDB Explorer with USME account
After I log in using USME account to CosmosDB explorer, it just shows up like this as if I never logged in. Can I get some help on logging in using USME account?
Is it possible to connect use dedicated gateway and integrated cache with managed identity from python sdk
I wanted to connect from azure function (python) to azure cosmos nosql database with managed identity credential. As far as I understand from https://learn.microsoft.com/en-us/azure/cosmos-db/how-to-configure-integrated-cache, I did not find anything…
Does Azure Cosmos DB support tinker pop/gremlin-go driver
Hello, I am looking at the documentation for Azure Cosmos DB Gremlin compatible client libraries: https://learn.microsoft.com/en-us/azure/cosmos-db/gremlin/support#compatible-client-libraries I am interested in a current go driver. I see gremcos listed…
SQL vs Cosmos database
I am new to Azure and currently evaluating database options for a project. I need to build a real-time application that requires low latency and can handle high read and write throughput. The application will involve storing user profiles, activity logs,…
Migration of data between cross Tenants cosmos DB accounts
Hi Team, We want to migrate data between two cosmos DB NOSQL accounts which are located in two different tenants. One cosmos DB is in "CORP Tenant"(microsoft.com) and another cosmos DB is in PME tenant. Please provide me some guidance on how to…
CosmosDb creation problem
Hello I am trying to create and configure a resource for CosmosDB from Azure free services. But when I click create, a feedback screen opens. I cannot create this resource. Is CosmosDb not free? Or where am I making a mistake? Thank you.
Is there a way to get cosmosdb (for nosql) container size and total container document count.
I want to get total items count (row count) and container size for a cosmosdb (nosql) container efficiently using a python client. Is there a way to do this efficiently.
Issues while fetching data from cosmos db using data factory
Hi All, I have been trying to fetch data from cosmos Db using a query which works well in cosmos Db explorer in Azure portal. But, the same query gives error while using it with Azure Data Factory. Query: SELECT * FROM c where…
When trying to enable the capability "EnableUniqueIndexReIndex", it always give the error message "Invalid capability EnableUniqueIndexReIndex"
When I try to enable the capability "EnableUniqueIndexReIndex", I always get the error message "Invalid capability EnableUniqueIndexReIndex". I tried with the az cli and with the bicep script that deploys the application. I have…