Redshift
Last updated
Was this helpful?
Last updated
Was this helpful?
IP RESTRICTIONS
Make sure to allow traffic from one of the Paradime IPs in your firewall depending on the data location selected.
👉 See also: .
You will be prompted to add a Development connection during the onboarding, or you can add more connections by completing the following steps:
Click Settings in the top menu bar of the Paradime interface to access Account Settings
In the left sidebar, click "Connections"
Click "Add New" next to the Code IDE section
Select "Redshift"
Below are list of fields and example to create a connection.
Profile Name
dbt-redshift
Target
dev
Host Name
The hostname of the Redshift database to connect to.
xxx.eu-west-2.amazonaws.com
Port
Usually 5439 for Redshift.
5439
Database
The name of your Redshift production database.
analytics
Username
The username created with access to the development database.
dev_user
Password
The password set for the user created in Redshift.
password_xyz
Schema
The default schema used to build dbt™️ objects at runtime.
dbt_john
Threads
8
Below are list of fields and example to create a connection.
Profile Name
dbt-redshift
Target
dev
Profile Configuration
User Email
The username created with access to the development database.
John@acme.io
Password
The password set for the user created in Redshift.
password_xyz
Schema
The default schema used to build dbt™️ objects at runtime.
dbt_john
Threads
8
The profile name set in your dbt_project.yaml . See more .
The target name used to identify the connection. See more .
The number of threads used in this connection. See more .
The profile name set in your dbt_project.yaml . See more .
The target name used to identify the connection. See more .
This is the coplete profile configurations for dbt. Which will include host name, port plus optional fields. See more .
The number of threads used in this connection. See more .
