Edit

Share via


Azure storage extension in Azure Database for PostgreSQL flexible server

APPLIES TO: Azure Database for PostgreSQL - Flexible Server

The Azure Database for PostgreSQL flexible server extension for Azure Storage enables direct data movement between your PostgreSQL flexible server instance and Azure Storage accounts, supporting both import and export operations in multiple file formats. The use of this extension simplifies data workflows by allowing SQL-based access to blob storage, making it easier to integrate PostgreSQL with other Azure services.

It reduces the need for external Extract, Transform, and Load (ETL) and Extract, Load, and Transform (ELT) tools by enabling SQL native commands to interact with blob containers.

It works with public and private access configurations, including PostgreSQL flexible servers whose network interface is injected in a virtual network of your own infrastructure.

The extension supports sending requests to Azure Storage service using authorization with Shared Key, or using authorization with Microsoft Entra ID managed identity assigned to your server.

Given its superior security, Microsoft highly recommends the use of authorization with Microsoft Entra ID.

To be able to use the azure_storage extension from any of the databases of an Azure Database for PostgreSQL flexible server, you need to allow the extension, load its library, and create the extension in the database from where you want to use its functionality.