Help us build a better product, earn the PaxPro Advocate badge: Six short questions, one cool badge.

Visit the official Paxata Documentation portal for all of your doc needs.

How to configure a Redshift Data Source

CSDanCSDan Posts: 32 ✭✭
edited October 15, 2018 1:47PM in Paxata Fundamentals
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>

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.

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

Sign In or Register to comment.