Automate dbt Semantic Layer Checks with GitHub Actions

Run a dbt MetricFlow canary on GitHub Actions after every pipeline refresh and get an email only when a metric moves.

**Who it's for:** Analytics engineers who define metrics in dbt.

**The problem:** A metric canary only helps if it runs after each data refresh.

**The solution:** The pipeline sends a repository_dispatch event when its refresh finishes. GitHub Actions signs into Google Cloud with no stored key, checks every pinned metric in BigQuery, and emails only when one moves.

**Takeaways:**

  • A Monday cron backs up the dispatch.
  • Branch runs write to a CI dataset, never production.
  • Someone still pins settled months and finds why a number moved.

Resources