Bruin Dashboards Step 3 of 5
Migrate Metabase Dashboards to Bruin
Treat generated YAML as a draft
The importer converts native SQL cards into metric, chart, and table widgets. It can compile simple MBQL when source metadata is present. Start by reading the generated YAML and the import warnings, then correct the SQL, filter mapping, visualization choice, and layout before you show it to anyone.
This is a reviewed DAC reference for a native SQL "daily revenue" line chart. It stays close to the source query on purpose:
name: Migration Fixture Dashboard
description: Reviewed DAC reference for the Metabase native-SQL dashboard
connection: analytics
rows:
- widgets:
- name: Daily revenue
type: chart
chart: line
col: 12
sql: |
SELECT
order_date,
SUM(amount) AS revenue
FROM public.orders
GROUP BY order_date
ORDER BY order_date
x: {field: order_date}
y: {field: [revenue]}
The importer is a starting point. Keep the first reviewed dashboard close enough to the source that a reader can compare the two queries without guessing what changed.