Redshift
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 Code IDE Connection
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"
Using Username & Password

Field Details
Below are list of fields and example to create a connection.
Profile Name
The profile name set in your dbt_project.yaml
. See more here.
dbt-redshift
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
Using IAM

Field Details
Below are list of fields and example to create a connection.
Profile Name
The profile name set in your dbt_project.yaml
. See more here.
dbt-redshift
Profile Configuration
This is the coplete profile configurations for dbt. Which will include host name, port plus optional fields. See more here.
cluster_id: CLUSTER_ID
host: hostname.region.redshift.amazonaws.com
user: alice
iam_profile: analyst
region: us-east-1
dbname: analytics
schema: analytics
port: 5439
User Email
The username created with access to the development database.
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
Last updated
Was this helpful?