Reports in different time zones on same instance of Metabase

[wehankirsten]

So the cleanest way I found to do this is:

1. Set up users in Postgres for each timezone

2. Set up a mapping table for the users with the timezones:

3. join the mapping table in the queries in postgres:

4. Use DB routing in Metabase and map the users to the desired connection that uses the user associated with the desired timezones.

I tested this and it works. The only caveat for our use case is that we use jsonb unfolding and sometimes there are dates in the json so the conversion must happen in postgres at query time with the associated user which means that we must use views.

I hope this might help somebody with a similar use case!