Skip to content

Polars datetime with timezone to Snowflake #2843

@Niivii

Description

@Niivii

What would you like help with?

I noticed a problem where a polars dataframe with a timezone timestamp column is not send with the correct offset to Snowflake.

For example, UTC timestamp in polars:

Image

Ends up as CET in Snowflake (my account timezone):

Image

From what I understood this is because Arrow types are not the same as in Snowflake.

Am I correct that if I alter the session timezone to UTC, I will end up with the UTC timestamptz in Snowflake ?

What if I have a dataframe with different timezones. Will they all be converted to the timezone of the session ?

Thanks !

Metadata

Metadata

Assignees

No one assigned

    Labels

    Type

    No type

    Projects

    No projects

    Milestone

    No milestone

    Relationships

    None yet

    Development

    No branches or pull requests

    Issue actions