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 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 workspaceAdmin
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 |
| 🏢 Workspace level |
Target | The target name used to identify the connection. See more here. |
| 🏢 Workspace level |
Host Name | The hostname of the Redshift database to connect to. |
| 🏢 Workspace level |
Port | Usually |
| 🏢 Workspace level |
Database | The name of your Redshift production database. |
| 👥 User level |
Username | The username created with access to the development database. |
| 👥 User level |
Password | The password set for the user created in Redshift. |
| 👥 User level |
Schema | The default schema used to build dbt™️ objects at runtime. |
| 👥 User level |
Threads | The number of threads used in this connection. See more here. |
| 👥 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 workspaceAdmin
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 |
| 🏢 Workspace level |
Target | The target name used to identify the connection. See more here. |
| 🏢 Workspace level |
Profile Configuration | This is the coplete profile configurations for dbt. Which will include host name, port plus optional fields. See more here. | 🏢 Workspace level | |
User Email | The username created with access to the development database. |
| 👥 User level |
Password | The password set for the user created in Redshift. |
| 👥 User level |
Schema | The default schema used to build dbt™️ objects at runtime. |
| 👥 User level |
Threads | The number of threads used in this connection. See more here. |
| 👥 User level |
Last updated