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.
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.