Generic PostgreSQL Warehouse Setup Guide
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:
Connect to your Postgres warehouse and run the following query to create a 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;