Local timezone when data is in UTC implicitly using Snowflake

I have a my data in Snowflake (many tables and databases), and have connected Metabase to this. In the tables timestamps are stored in TIMESTAMP_NTZ format, in UTC time. (like this: 2019-12-11 15:30:00.000).

If I set reporting time zone to UTC everything works fine. However, I want to use my local timezone for queries. I tried setting reporting time zone to my local zone, but then timestamps are not truncated to dates/days properly. It truncates to UTC which is not what I want.

date_trunc("day", CAST(mytable.datetime AS timestamp)) AS "dateday"

How can I query this data in my local time zone using Metabase (I have tried with latest version, 0.35.3)?

Hi @viblo
It sounds like you’re seeing this issue:
https://github.com/metabase/metabase/issues/8804 - upvote by clicking :+1: on the first post


I wrote a long comment on that github issue and voted. Im not 100% sure its the same thing, but at least I hope the issue I face is clear :slight_smile: