Redshift

Paradime Redshift Connection: Integrate Redshift with Paradime for dbt™ projects. Enhance data management and querying.

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:

1. Click Settings in the top menu bar of the Paradime interface to access Account Settings

2. In the left sidebar, click "Connections"

3. Click "Add New" next to the Code IDE section

4. Select "Redshift"

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

Using IAM

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
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	🏢 Workspace level
User Email	The username created with access to the development database.	[e-mail]	👥 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