I have a pandas dataframe in which the date is having datetime64 dtype but when I am writing this dataframe to snowflake, the date values are showing invalid.
| date_1 |
|---|
| Invalid Date |
| Invalid Date |
| Invalid Date |
while in dataframe I have values like below :
| date_1 |
|---|
| 2021-04-12 |
| 2021-05-12 |
| 2021-06-12 |
the data type in snowflake is TIMESTAMP_NTZ(9) whereas in pandas dataframe it is datetime64
What can be the reason?
CodePudding user response：
Seems to be a data type mapping issue. Please review: https://docs.snowflake.com/en/user-guide/python-connector-pandas.html#snowflake-to-pandas-data-mapping