Environment Details
When trying to write to Amazon Redshift, the following error occurs:
Error: "Output Data (10): DataWrap2ODBC::SendBatch: [Amazon][Amazon Redshift] (30) Error occurred while trying to execute a query: [SQLState 42P02] ERROR: there is no parameter $-32757 Insert into mytable (column1,column2,column3) Values (?,?,?)"
- Alteryx Designer
- Redshift ODBC
- Redshift Version 1.4.10.1000
Cause
ODBC driver compatibility issue.
Resolution
Upgrade to Amazon Redshift ODBC driver version 1.4.35.1000 or higher. To download the Amazon Redshift ODBC 64-bit Windows driver, click here
null