CODEWITHSUNDEEP
pandasdataframeairflowsnowflake-cloud-data-platformdirected-acyclic-graphs
Rajalakshmi
Rajalakshmi

Reputation: 771

Pandas dataframe to Snowflake is not working on DATE datatypes

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.

Upvotes: 1

Views: 755

Answers (1)

Rajalakshmi
Rajalakshmi

Reputation: 771

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.

Upvotes: 3

Related Questions