|Type of Support:||Read & Write; In-Database||Read & Write|
|Verified On:||Client version 126.96.36.1990||Client version 188.8.131.520|
|Connection Type:||ODBC (32- and 64-bit)||ODBC (32- and 64-bit)|
The ODBC driver can be downloaded from Amazon Redshift. An AWS account must be created.
In-Database processing requires 64-bit database drivers.
The ODBC driver can be downloaded from Amazon Redshift Spectrum. An AWS account must be created.
Alteryx tools used to connect
- Input Data Tool and Output Data Tool (Standard workflow processing)
- Connect In-DB Tool and Data Stream In Tool (In-database workflow processing)
In the ODBC Data Source Administrator:
- Select the Redshift driver and click Configure.
- Type in your Connection Settings and credentials.
- In the Additional Options area, select the Retrieve Entire Results Into Memory option.
- Save the connection by clicking OK.
To use the bulk connection via the Output Data tool:
- Click the Write to File or Database drop-down and select Other Databases > Amazon Redshift Bulk.
- Select a Data Source Name (or click ODBC Admin to create one). See ODBC and OLEDB Database Connections.
- (Optional) Type a User Name and Password.
- In the Amazon S3 section, type or paste your AWS Access Key and AWS Secret Key to access the data for upload.
- In the Secret Key Encryption drop-down, select an encryption option:
- Hide: Hide the password using minimal encryption.
- Encrypt for Machine: Any user on the computer will be able to fully use the connection.
- Encrypt for User: The logged in user can use the connection on any computer.
If the Bucket you select is not in the region of the endpoint you specify, the following error occurs: “The bucket you are attempting to access must be addressed using the specified endpoint. Please send all future requests to this endpoint.” Select Default to clear the error.
Regions created after January 30, 2014 support only Signature Version 4. The following regions require Signature Version 4 authentication:
- US East (Ohio) Region
- Canada (Central) Region
- Asia Pacific (Mumbai) Region
- Asia Pacific (Seoul) Region
- EU (Frankfurt) Region
- EU (London) Region
- China (Beijing) Region
- None (Default): No encryption method is used.
- SSE-KMS: Use server-side encryption with AWS KMS-managed keys. Optionally provide a KMS Key ID. When you select this method, Use Signature V4 for Authentication is enabled by default.
Optionally select Use Redshift Spectrum to connect to Spectrum tables.
You can optionally specify or adjust the following Redshift options. For more information, see the Amazon Redshift Database Developer Guide.
To create Spectrum tables with the Output Data tool, specify both the schema and table name.
- Primary Key: Select column(s) for the Primary Key and adjust the order of columns.
- Distribution Style: Select Even, Key, or All.
- Distribution Key: Select a column for the Distribution Key.
- Sort Style: Select None, Compound, or Interleaved.
- Sort Key: Select column(s) for the Sort Key and adjust the order of columns.
- Enable Vacuum and Analyze Operations: (Bulk connections only) Enabled by default. When enabled, VACUUM and ANALYZE maintenance commands are executed after a bulk load APPEND to the Redshift database.
- Size of Bulk Load Chunks (1 MB to 102400 MB): To increase upload performance, large files are split into smaller files with a specified integer size, in megabytes. The default value is 128.
- Enable backslash (\) as escape character: (Bulk connections only) Enabled by default. When enabled, a character that immediately follows a backslash character is loaded as column data, even if that character normally is used for a special purpose (for example, delimiter character, quotation mark, embedded newline character, or escape character).
Distribution Key is ignored if 'Key' is not selected for Distribution Style. Sort Key is ignored if 'None' is selected for Sort Style.