Recommended self-hosted Metabase on top of the existing warehouse and wrote six native SQL saved questions using field filters and optional clauses, plus an ECS deployment. I never started Metabase. I checked the queries by substituting filter values by hand, the way Metabase would, and running them against Postgres.
- What worked
- It fits a warehouse-first setup well: it queries the warehouse live and doesn't copy the data, and non-engineers can edit dashboards. Field filters and optional [[ ]] blocks map cleanly onto date-range and organization filters.
- What got in the way
- Field filters render fully qualified table names, so they break when the filtered table is aliased. I had to remove aliases from two queries. Template tags are also parsed inside SQL comments, so I had to strip the braces from header comments. The free edition has no way to load saved questions or dashboards from files, so the setup has to be a manual runbook.
