This site uses different types of cookies, including analytics and functional cookies (its own and from other sites). To change your cookie settings or find out more, click here. If you continue browsing our website, you accept these cookies.
To configure an ODBC connection to a Redshift database:
Navigate to ODBC Data Source Administrator
Select Redshift driver and click Configure
Enter you connection settings and credentials
Navigate to your Redshift Data Source and click "configure",
Select Additional Options
Check the option "Retrieve Entire Result Into Memory"
Confirm with OK.
Configure an Amazon Redshift Bulk Connection
Write-only Bulk Load support is available for standard and in-DB workflows for Redshift. For Redshift Spectrum standard workflows writing is only supported through Bulk Load.
Please note that an S3 account is required for the below steps.
In Designer draw an Output Data tool on the Canvas,
2019.1 and earlier or when using Classic Mode for Input Data / Output Data tool. This can be set under Alteryx - Options - User Settings - Edit User Settings - Defaults - "Use classic mode for the Input/Output tool menu options":
Click the Write to File or Database drop down menu and select Other Databases > Amazon Redshift Bulk
2019.2 and later:
Alteryx displays the Data connections window. To create new connection click Data Sources and select Amazon Redshift - Bulk or Amazon Redshift Spectrum - Bulk
Select a Data Source Name or create a new one in ODBC Data Source Admin
Optionally enter User name and password
Fill in AWS credentials to access 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.
The endpoint should be set to Default so that Amazon will automatically determine the endpoint to be used. The endpoint should be set manually if a specific endpoint is needed for either private S3 deployments or to select a specific region.
Optionally, 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.
S3 Error - Wrong Endpoint for Bucket Used The following error message occurs: The bucket you are attempting to access must be addressed using the specified endpoint. Please send all future requests to this endpoint. The above error message typically occurs if the bucket selected is not in the region the specified endpoint is in. Select the Default endpoint solve this issue.
Amazon Redshift: Check 'stl_load_errors' system table for error details
When writing to Amazon Redshift, the following error appears:
Data Stream In (x): The COPY failed with error: [Amazon][Amazon Redshift] (30) Error occurred while trying to execute a query: [SQLState XX000] ERROR: Load into table 'ayx1XXX' failed. Check 'stl_load_errors' system table for details.