Pandas dataframe to Snowflake is not working on DATE datatypes

user_13973813 0
Viewed 115

I have a dataframe with column 'DATE_REGISTERED'.The format of the data in this dataframe is 'YYYY-MM-DD'. I am trying to use write_pandas method to load this data into a Snowflake table. But I am unable to achieve this as the code is throwing below error.

enter image description here

The input data is '2021-02-10' (10th of Feb 2021)

Any help is appreciated.

airflow snowflake-cloud-data-platform pandas directed-acyclic-graphs dataframe
1 Answers

I am able to fix this issue by simply converting the datatype of the column in DF to string. This worked and resolved my issue.

user_139738130
Related