Redshift connection

IP RESTRICTIONS

Make sure to allow traffic from one of the Paradime IPs in your firewall depending on the data location selected.

👉 See also: Paradime IP addresses.

Add Development Connection

You will be prompted to add a Development connection during the onboarding, or you can add more connections by going to account settings > connections, select Development Environment and enter the required fields.

Using Username & Password

Field Details

Below are list of fields and example to create a connection.

• 🏢 Workspace level fields are set by the the workspace Admin and not configurable for by user

• 👥 User level fields are set by each user (Admin/Developer) when setting the Development connection.

Field	Description	Example	Level
Profile Name	The profile name set in your dbt_project.yaml . See more here.	dbt-redshift	🏢 Workspace level
Target	The target name used to identify the connection. See more here.	dev	🏢 Workspace level
Host Name	The hostname of the Redshift database to connect to.	xxx.eu-west-2.amazonaws.com	🏢 Workspace level
Port	Usually 5439 for Redshift.	5439	🏢 Workspace level
Database	The name of your Redshift production database.	analytics	👥 User level
Username	The username created with access to the development database.	dev_user	👥 User level
Password	The password set for the user created in Redshift.	password_xyz	👥 User level
Schema	The default schema used to build dbt™️ objects at runtime.	dbt_john	👥 User level
Threads	The number of threads used in this connection. See more here.	8	👥 User level