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:
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 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;