How to configure a Redshift Data Source

CSDan
Linear Actuator

How to configure a Redshift Data Source

To configure a Redshift Data Source in Paxata, you will need to enter the following parameters

Database URL  e.g. jdbc:redshift://<yourRedshiftHost>:<yourPortNumber>/<yourDatabaseName>
Username
Password





In addition to the above information, if you are configuring the Data Source for export from Paxata, you must choose whether to export to S3 or export using SQL insert statements.  

EXPORT using SQL insert statements
If you are using this export method, no additional parameters are required.

EXPORT to S3
If exporting to S3, regardless of authentication method, you must provide
  Bucket name
  Prefix e.g.  /
  Access Key
  Secret Key






0 Kudos
0 Replies