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