[I] Polars datetime with timezone to Snowflake [arrow-adbc]

[via GitHub]

Niivii opened a new issue, #2843:
URL: https://github.com/apache/arrow-adbc/issues/2843

   ### 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](https://github.com/user-attachments/assets/837123da-86a9-433c-83d7-368e2e30c737)
   
   Ends up as CET in Snowflake (my account timezone):
   
   
![Image](https://github.com/user-attachments/assets/39307652-586a-44ce-8f65-b9b76cabf5d1)
   
   From what I understood this is because [Arrow types are not the same as in 
Snowflake](https://arrow.apache.org/adbc/main/driver/snowflake.html#type-support).
   
   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 !


-- 
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.

To unsubscribe, e-mail: issues-unsubscr...@arrow.apache.org.apache.org

For queries about this service, please contact Infrastructure at:
us...@infra.apache.org