I’ve been looking at other BI tools to extend the analysis and tools such as Metabase have some issues in handling timezones based on the user preferences within their tool vs the timezone on the DB.
a few questions around this:
- Can you tell me what timezone our DB is on?
- What is the best way for me to pass our timezone into the data as its loaded?
- In situations where we can’t modify our source data how should we handle timezone?