Warehouse dashboards
Charts built from saved queries, next to the operational data.
Data Warehouse → Dashboards builds charts from saved queries.
A tile
| Query | A saved query, or an inline one |
| Visualisation | Line, bar, table, single value |
| Refresh | How often it re-runs |
| Range | Absolute or relative |
Single-value tiles
A single number with its period-over-period change is often the most useful tile on the page. "Orders today: 4,182 (+7% vs last Tuesday)" answers a question; a line chart of the last 90 days invites one.
Refresh cost
Every refresh runs the query. A dashboard with twelve tiles refreshing every minute is 17,280 warehouse queries a day.
Set the refresh to match how fast the data actually changes. A daily aggregation does not need a one-minute refresh, and the cost monitor will show you which dashboard is responsible when somebody asks about warehouse load.
Dashboards are not alerts
A dashboard tells you when somebody is looking. An alert tells you when nobody is.
If a tile matters enough that you check it every morning, it should be an alert. The dashboard is then for the shape; the alert is for the threshold.
Superset
For heavier analytical work, Superset dashboards embed directly.
Where this behaviour lives: frontend/src/app/dwh/dashboards/. If the code and this page disagree, the code is right — please fix the page.
Part of Data warehouse — Querying the warehouse, and alerting on what the query returns.