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)?