Comment on page

Redshift Connector

Install PipeRider with the Redshift connector and connect to a data source.

Installation
pip install 'piperider[redshift]'
Configuration (DBT)
Run the diagnose command in the dbt project
piperider diagnose
If you can successfully connect to Redshift using dbt, PipeRider can also connect to Redshift using the same profile settings. For details, please refer to the dbt Redshift adapter documentation.
Configuration (Non-DBT)
non-dbt use case is deprecated since v0.25.0
Initialize a new PipeRider project using piperider init and when prompted select Redshift as the data source.
The following information is required.
Redshift Endpoint URL
Authentication method (password or iam)
Example initialization steps
IAM steps
Please enter the following fields for redshift
[?] Redshift Endpoint: default.xxxxxxx.ap-northeast-1.redshift-serverless.amazonaws.com:5439/dev
[?] Authentication Methods: iam
   password
 > iam
​
[?] Redshift IAM Role (optional):
[?] Redshift Database Name: sp500
[?] Redshift Schema: public
Password steps
Please enter the following fields for redshift
[?] Redshift Endpoint: default.xxxxxxx.ap-northeast-1.redshift-serverless.amazonaws.com:5439/dev
[?] Authentication Methods: password
 > password
   iam
​
[?] Redshift User: [email protected]
[?] Redshift Password: ************
[?] Redshift Database Name: sp500
[?] Redshift Schema: public
Test connection settings
After configuring your connection settings, ensure that PipeRider can connect to your Redshift data source.
piperider diagnose
If connection timeout expired occurs, please try it later, in case, Redshift service was asleep.

Postgres Connector

Athena Connector

Last modified 6mo ago