We are celebrating the 10-year anniversary of the Alteryx Community! Learn more and join in on the fun here.
Start Free Trial

Alteryx Designer Desktop Discussions

Find answers, ask questions, and share expertise about Alteryx Designer Desktop and Intelligence Suite.

TIMESTAMP ISSUE INSERTING to redshift

kathbanc
8 - Asteroid

kathbanc_0-1751068070253.png

Need help here, this message prompts when inserting data to redshift . 

already use the formula tool and this is the output 

kathbanc_1-1751068143743.png

 

the data type also in redshift is timestamp without timezone. please help thanks

 

1 REPLY 1
apathetichell
20 - Arcturus

you should see more information in stl_loads_errors. What do you see in: 

raw_field_valuechar(1024)The pre-parsing value for the field "colname" that lead to the parsing error.
err_codeintegerError code.
err_reasoncharacter(100)Explanation for the error.

 

Is your Alteryx field a datetime? Is the value in one of the rows a null/empty?

Labels
Top Solution Authors