The initial requirement to use PostgreSQL on Azure as a destination is to enable the extension that allows reading files from Blob Storage.
First, navigate to the Azure portal and locate your database. On the main page of the database, expand the Settings option in the sidebar and select Server parameters.
On the loaded screen, filter the configuration parameters by "azure.extension," and then click on the value list in the VALUE column of the azure.extension row in the table.
Find and select the AZURE_STORAGE option from the available list, and then click Save at the top of the page to apply the new configuration to the list of allowed extensions.
After adding the extension to the allowed list, execute the following query to install the additional functionalities related to Storage:
CREATE EXTENSION azure_storage;
To finalize, grant admin permission for the extension to the user of the credential that will be used on the platform with the following query:
GRANT azure_storage_admin TO erathosuser;
Firewall
To establish a connection from the database to the Erathos platform without the need for an SSH tunnel through a machine that has access to the database, you will need to add the IP address 35.212.87.86 as an allowed rule in the firewall.
Navigate to the main page of the chosen database and select the Networking option within Settings. Scroll to the Firewall rule name table and choose a name of your preference to identify our platform. Then, add the platform's IP as the Firewall rule name and End IP address. Apply the new rule by clicking Save at the top of the page.
