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>
UsernamePassword
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 statementsIf you are using this export method, no additional parameters are required.
EXPORT to S3If exporting to S3, regardless of authentication method, you must provide
Bucket name Prefix e.g. /
Access Key Secret Key