Amazon Redshift

 

Type of Support: Read & Write; In-Database
Validated On: Client version 1.3.7.1000
Connection Type: ODBC (32- and 64-bit)
Driver Details: The ODBC driver can be downloaded from Amazon Redshift. An AWS account must be created.

Write-only Bulk load support is available for standard and In-DB workflows.

In-Database processing requires 64-bit database drivers.

 

Alteryx tools used to connect:

Additional Details

Configuring an ODBC Connection

In the ODBC Data Source Administrator:

  1. Select the Redshift driver and click Configure.
  2. Type in your Connection Settings and credentials.
  3. In the Additional Options area, select the Retrieve Entire Results Into Memory option.
  4. Save the connection by clicking OK.

Configuring an Amazon Redshift Bulk Connection

To use the bulk connection via the Output Data tool:

  1. Click the Write to File or Database drop-down and select Other Databases > Amazon Redshift Bulk.
  2. Select a Data Source Name (or click ODBC Admin to create one). See ODBC and OLEDB Database Connections.
  3. (Optional) Type a User Name and Password.
  4. In the Amazon S3 section, type or paste your AWS Access Key and AWS Secret Key to access the data for upload.
  5. In the Secret Key Encryption drop-down, select an encryption option:
  6. In the Endpoint drop-down, select Default to allow Amazon to determine the endpoint automatically based on the bucket you select. To specify an endpoint for private S3 deployments, or if you know a specific bucket region, you can alternately select an endpoint (S3 region), enter a custom endpoint, or select from one of ten previously-entered custom endpoints.
  7. 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.

  8. (Optional) Select Use Signature V4 for Authentication to use Signature Version 4 instead of the default Signature Version 2. This will increase security, but connection speeds may be slower. This option is automatically enabled for regions requiring Signature Version 4.
  9. Select a Server-Side Encryption method for uploading to an encrypted Amazon S3 bucket. For more information on Amazon S3 encryption methods, see the Amazon Simple Storage Service Developer Guide.
    • 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.
  10. In Bucket Name, type the name of the AWS bucket in which your data objects are stored.

Configuring Output Options

You can optionally specify or adjust the following Redshift options. For more information, see the Amazon Redshift Database Developer Guide.