TIMESTAMP ISSUE INSERTING to redshift

kathbanc

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

already use the formula tool and this is the output 

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

apathetichell

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

raw_field_value	char(1024)	The pre-parsing value for the field "colname" that lead to the parsing error.
err_code	integer	Error code.
err_reason	character(100)	Explanation for the error.

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