pg_azure_storage extension for CosmosDB PostgreSQL API

Question

Just learned that there is an extension called pg_azure_storage that available for CosmosDB for PostgreSQL.
In the demo, tabular files can be read directly from a storage account. But I couldn't find any related documentation about the capacity, usage or limitation of this extension.
Any pointers are appreciated.
Thank you.

Answer 1

Hi @Deyong Zhou ,

Welcome to Microsoft Q&A platform and thanks for using Azure Services.

As I understand your question, it is about the recent launch of Distributed PostgreSQL comes to Azure Cosmos DB.

Regarding the documentation about the topic, please refer to this Azure Cosmos DB for PostgreSQL and QuickStart section for detailed demonstration.

Hope this will help. If you have any specific query about the service, please let us know to further help in that.

Thanks!

------------------------------

• Please don't forget to click on or upvote button whenever the information provided helps you.
  Original posters help the community find answers faster by identifying the correct answer. Here is how
• Want a reminder to come back and check responses? Here is how to subscribe to a notification

Answer 2

@Deyong Zhou

1. Yes. This is a simple as SELECT * FROM azure_storage.blob_get('account','container','file.tsv', decoder := 'tsv') AS (a int, b int, c text);
2. No, we have not done any PostGIS integration. This does sound like an amazing feature.I would recommend posting in the feedback forum

Please let us know if you are looking for any additional information.

Regards
Geetha

Answer 3

Hello @Deyong Zhou

You can see related documentation on the extension at

https://learn.microsoft.com/azure/cosmos-db/postgresql/howto-ingest-azure-blob-storage