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?