Redshift
Last updated
Last updated
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.
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.
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.
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
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.
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.
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
