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

Allow access

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

1. Go to your Google Cloud Platform Dashboard and select SQL in the left navigation menu.

   

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

   

3. Select Connectivity on the Edit instance page.

4. Select + Add network.

5. Enter a memorable name in the Name field. (We suggest "Fivetran.")

6. Enter Fivetran's IP in the Network field.

   

7. Click Done.

8. Click Save at the bottom of the page.

   

---

Create a user

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 grant the fivetran user the following privileges:

• CREATE: Allows the user to create new schemas in the database
• TEMPORARY: Allows the user to create temporary tables while using the database

GRANT CREATE, TEMPORARY ON DATABASE <database> TO fivetran;