Get database name for Azure Cosmos DB for PostgreSQL

[vanta-cladelpino]

Hi, I'm not being able to find how to get the database name of a PostgreSQL Citus CosmosDB powered database using the js SDK.

I'm able to get information on the cluster or servers via the properties of https://azuresdkdocs.blob.core.windows.net/$web/javascript/azure-arm-cosmosdbforpostgresql/1.0.0-beta.1/classes/CosmosDBForPostgreSQL.html but none of these includes the database name.

thanks in advance!

---

Document Details

⚠ Do not edit this section. It is required for learn.microsoft.com ➟ GitHub issue linking.

• ID: d149e9db-dbe0-8136-12f8-7b1957a02b30
• Version Independent ID: 9a40e0b5-378c-58f2-3ec4-3810a6e505c2
• Content: CosmosDBForPostgreSQL class
• Content Source: preview-packages/docs-ref-autogen/@azure/arm-cosmosdbforpostgresql/CosmosDBForPostgreSQL.yml
• GitHub Login: @VSC-Service-Account

[kazrael2119]

will check

[kazrael2119]

@vanta-cladelpino ,I think you use a wrong package, @azure/arm-postgresql may the correct package you want
https://www.npmjs.com/package/@azure/arm-postgresql

[vanta-cladelpino]

@kazrael2119 Hmmm, I'm talking about Cosmos DB for PostgreSQL, and can fetch all the cluster/nodes information, plus the package has the exact name of the service, so I don't really think thats the case.

[kazrael2119]

@kazrael2119 Hmmm, I'm talking about Cosmos DB for PostgreSQL, and can fetch all the cluster/nodes information, plus the package has the exact name of the service, so I don't really think thats the case.

@vanta-cladelpino do you mean you want to get the database name which is created when creating a cluster?

[kazrael2119]

If as the above is your issue ,after my investigation, there's a parameter called databaseName on portal.

but in sdk , we can not set it and get it beacuse sdk is generated from swagger, so I think this is a service issue.

[github-actions]

Thanks for the feedback! We are routing this to the appropriate team for follow-up. cc @sajeetharan @abkolant-MSFT @pjohari-ms @simorenoh @v1k1.

[niklarin]

Correct, we recently introduced the custom database name in Azure Cosmos DB for PostgreSQL. It can be done only during cluster provisioning. Today this capability is enabled in the Azure portal only. We're working on updating REST APIs with this functionality (that would include GET for DB name). We expect the REST APIs update to be published in the next 6-8 weeks or so. Once REST APIs are updated the change will be brought down to Terraform, Azure SDKs, and Azure CLI.

[vanta-cladelpino]

thanks!!

[kazrael2119]

Correct, we recently introduced the custom database name in Azure Cosmos DB for PostgreSQL. It can be done only during cluster provisioning. Today this capability is enabled in the Azure portal only. We're working on updating REST APIs with this functionality (that would include GET for DB name). We expect the REST APIs update to be published in the next 6-8 weeks or so. Once REST APIs are updated the change will be brought down to Terraform, Azure SDKs, and Azure CLI.

Hi @niklarin , does the feature have been published? this month we have CosmosDBforPostgreSQL release request:https://github.com/Azure/sdk-release-request/issues/4461 , but in the generated code:#27007, it doesn't contains this feature. If publish is done, I think we can include this feature directly in this release

[niklarin]

@kazrael2119 No, not yet. Tentatively the next update for the REST APIs for Azure Cosmos DB for PostgreSQL will be done in October / November and will include quite a few additions including the DB name at provisioning time.

[lirenhe]

@kazrael2119, please help to check the next release to verify update and then close this item. Thanks.

[sajeetharan]

@lirenhe please do not open issues related to PgSQL on this repo!