Now that it's live, don't forget to accept your certification badge on Credly today! Learn more here.

Alteryx Designer Knowledge Base

Definitive answers from Designer experts.

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 (?,?,?)"

ntobon
Alteryx
Alteryx
Created

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
    • All versions
  • 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
No ratings