hi all,
Having an issue while loading a flag column which is of type Boolean in redshift database, from my recent project where I am trying to load a flag column with Boolean data type in target from a string field in Alteryx which is throwing an error stating that. "
Error: Output Data (62): DataWrap2ODBC: SendBatch: [Amazon][Amazon Redshift] (30) Error occurred while trying to execute a query: [SQLState 42804] ERROR: column "xyz" is of type Boolean but expression is of type text
HINT: You will need to rewrite or cast the expression.
Hence, I matched the data type within formula tool before loading as bool even then getting same error, also tried with different data types like int, string and setting the flag values like "1','yes','y','true."
nothing is working while loading getting same error.
lastly tried with string datatype and having the data length in formula tool set to '1073741823' and tried loading the target table, its working with this data length, any suggestions on any other way or method to achieve this without keeping such a huge data length.
Thanks in Advance!
Kaustubh Palav
