pg_azure_storage extension for CosmosDB PostgreSQL API

Deyong Zhou 16 Reputation points
2022-10-17T08:43:17.223+00:00

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.

Azure Cosmos DB
Azure Cosmos DB
An Azure NoSQL database service for app development.
1,469 questions
Azure Database for PostgreSQL
{count} votes

3 answers

Sort by: Most helpful
  1. ShaktiSingh-MSFT 13,991 Reputation points Microsoft Employee
    2022-10-17T11:14:54.993+00:00

    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 130616-image.png or upvote 130671-image.png 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

  2. GeethaThatipatri-MSFT 27,972 Reputation points Microsoft Employee
    2022-10-19T21:47:05.837+00:00

    @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

    0 comments No comments

  3. Hanefi Onaldi 0 Reputation points Microsoft Employee
    2023-02-27T18:43:12.73+00:00