How do I build dashboards directly from dbt models?
A chart points at a dbt model by name and queries the table that model produces in the warehouse. When the model is rebuilt the dashboard reads the updated table without any manual export step.
Command
bruin runDefined in
YAML + SQL
Works with
Bruin + your warehouse
What you get
dbt model referencewarehouse-backed chartsautomatic refresh
How it works in code
dashboard:
name: marketing_overview
charts:
- title: Signups by channel
type: bar
model: dbt.stg_signups
query: |
SELECT channel, COUNT(*) AS signups
FROM dbt.stg_signups
GROUP BY channelRun bruin run and the dashboard reads directly from the dbt model output.
Related use cases
Dashboards as code
Define a dashboard as code
How do I define a dashboard as code?
Dashboards as codeBuild a metrics layer so metrics stay consistent
How do I build a metrics layer so metrics stay consistent?
Dashboards as codeKeep BI metrics consistent across tools
How do I keep BI metrics consistent across tools?
Dashboards that live in git
Open source. Write YAML, run one command, query your warehouse directly.