I have been testing setting up different database connections using different users in Postgres. The users have different timezones set. When I query Postgres directly the timezone conversion happens no problem. When I set up the connection through Metabase, however, then it looks like Metabase overrides the timezone setting of the user completely.
This connection is set up with the timezone (nzst) user:
Is this a known metabase limitation? We have multiple clients in different timezones so I need a way to use database routing and user mapped timezones when connecting to the client postgres database.
