Note
Access to this page requires authorization. You can try signing in or changing directories.
Access to this page requires authorization. You can try changing directories.
The Azure Database for PostgreSQL extension for Azure Storage enables direct data movement between your PostgreSQL flexible server and Azure Storage accounts. It supports both import and export operations in multiple file formats. By using this extension, you simplify data workflows by allowing SQL-based access to blob storage, making it easier to integrate PostgreSQL with other Azure services.
This extension 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 by using authorization with Shared Key or by 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 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.