Let’s talk Alteryx Copilot. Join the live AMA event to connect with the Alteryx team, ask questions, and hear how others are exploring what Copilot can do. Have Copilot questions? Ask 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