How to obtain the endpoint URL for CosmosDB for Postgresql Cluster?

Question

How to obtain the endpoint URL for CosmosDB for Postgresql Cluster?

Jacky Lam 210

Hi,

I want to use CLI to obtain the endpoint URL for a CosmoDB for Postgresql Cluster resource. I try both az postgre and az comosdb, but it also returns resource not found. For example:

az cosmosdb show --name cosmospostgrepreprdjl1 --resource-group ABC

az postgres server show -g ABC --name cosmospostgrepreprdjl1

where cosmospostgrepreprdjl1 is the name showing on the resource list of a resource group ABC

Jacky

GeethaThatipatri-MSFT 29,552 Reputation points Microsoft Employee Moderator

2023-06-15T22:24:24.0933333+00:00

Hi,@Jacky Lam Thanks for the ask and using the Microsoft Q&A platform.

If I understand correctly you are trying to get the endpoint URL for a Cosmos DB for PostgreSQL cluster resource using the Azure CLI, but you are getting a "resource not found" error. Let me repro this and provide you with more details

Regards

Geetha

Accepted answer

0 additional answers

Your answer

GeethaThatipatri-MSFT 29,552 Reputation points Microsoft Employee Moderator

2023-06-15T22:24:24.0933333+00:00

Hi,@Jacky Lam Thanks for the ask and using the Microsoft Q&A platform.

If I understand correctly you are trying to get the endpoint URL for a Cosmos DB for PostgreSQL cluster resource using the Azure CLI, but you are getting a "resource not found" error. Let me repro this and provide you with more details

Regards

Geetha

Answer 1

Hi, @Jacky Lam We don’t support native Azure CLI commands for Azure Cosmos DB for PostgreSQL yet. You can use ‘az rest’ as a thin wrapper for REST API calls though.

As you probably know, you can get connection strings for various languages and frameworks/tools on the ‘Connection strings’ tab in the cluster properties in Azure portal.

If you need to get a connection string programmatically you would need to construct it in the required syntax by getting variables such as the name of the node you need to connect to.

You can list nodes in a cluster using this API call and list clusters in a resource group using this API call. Also relevant to it is our current format of the node DNS names. Please note that this format is valid for recently created clusters, namely for those created on June 6<sup>th</sup>, 2023 and later. This page describes the old format too.

Let me know if you need any additional information.

Regards

Geetha

Share via

How to obtain the endpoint URL for CosmosDB for Postgresql Cluster?

0 additional answers

Your answer