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…
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 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…
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…
Which CosmosDB api to choose
Hi Team, I have a task where I will be using Azure function app to push the Windows 11 devices' windows update history to Azure CosmosDB. Could you please suggest what should I have configure at Azure function app so that it can push data to the…
Azure Cosmos DB for PostgreSQL | User: postgres | Unable to login To assign Superuser role to another user.
Hi Team, I created new Azure Cosmos DB for PostgreSQL and it created two default user accounts postgres citus Now I want to login using postgres account pgadmin4 tool. To assign SUPERUSER role to citus : **ALTER USER citus WITH SUPERUSER ** only…
how can I get permission to visit pg_current_logfile() in my Azure Cosmos DB for PostgreSQL Cluster
I want to access my log file in my database (Azure Cosmos DB for PostgreSQL Cluster), but my admin account don't have permission to visit pg_current_logfile().
Connect Azure CosmosDB using Managed Identities from Azure Function App both locally and on Azure
I create a Managed Identity for a Function app and assigned it to DocumentDB Account Contributor by following the two sections below …
Container table format
Hi In azure cosmos db what is the table format in container table .. Is it in JSON format or something else
I have written an end to end flow using Java SpringBoot which fetches entries from the container but i see that for this specific container the api fetches entries upto a certain limit say 8 after that it is unable to fetch record.
I am unable to fetch entries from a specific container after a certain limit, although this issue does not occur with other containers. I suspect the problem might be due to a field in this container that stores base64 strings of PDFs. Despite increasing…
Azure cosmos db postgresql data explorer showing The Network settings for this account are preventing access from Data Explorer. Please allow access from Azure Portal to proceed. how to resolve this?
Hello i have setup an Azure cosmosDB for Postgresql but imunable to connect to the database using PGadmin in my client machine even i have tried with the public access. the dataexplorer is showing me the error as in the screenshot.