PostgreSQL GCP Warehouse Setup Guide

Choose connection option

Decide whether to connect to your warehouse directly or connect using an SSH tunnel.

To connect using an SSH tunnel, follow these instructions.
To connect directly, configure your firewall and/or other access control systems to allow:
- Incoming connections to your Postgres port (usually 5432) from Fivetran's IP
- Outgoing connections to all ports (1024 to 65535) at Fivetran's IP

The Fivetran data processing servers need access to your warehouse database.

Go to your Google Cloud Platform Dashboard and select SQL in the left navigation menu.
Find the database you wish to connect to Fivetran in the list of Instances. Click on the menu button (represented as three vertical dots) for that database and select Edit.
Select Connectivity on the Edit instance page.
Select + Add network.
Enter a memorable name in the Name field. (We suggest "Fivetran.")
Enter Fivetran's IP in the Network field.
Click Done.
Click Save at the bottom of the page.

Connect to your Postgres database and run the following query to create a password, replacing <password> with your chosen password:

CREATE USER fivetran PASSWORD <password>;

Run the following query to allow the fivetran user to create schemas:

GRANT CREATE ON DATABASE <database> TO fivetran;