PostgreSQL GCP Warehouse Setup Guidelink
Choose connection optionlink
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
- Incoming connections to your Postgres port (usually
Allow accesslink
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.
Create a userlink
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;