I’m having an issue where datetime Pandas dataframe columns are not being created as datetime columns in Snowflake. I created a basic proof of concept:

@asset
def dagster_df_dates():
    return pd.DataFrame(pd.date_range("2023-01-01", "2023-01-31"), columns=["A"])

In Snowflake this column is created as a varchar. What am I doing wrong?

Hi Graham - i think there’s a conversion happening in the snowflake io manager. If i remember correctly, snowflake was incorrectly storing pandas datetime values, so we added a conversion step so the data got stored correctly. this might be fixed now, i’ll check it out and see