Blue-Green Data Warehouse Deployments (Write-Audit-Publish) with BigQuery and dbt

On a current project with the data team at Quibi, we were confronted with the challenge of how to incorporate the agility of developing dbt models against our BigQuery data warehouse with a process that gave us peace of mind that the data exposed via our BI tools is audited and accurate before publishing it to data consumers.

I had a lot of fun talking to the dbt Community about how to implement Blue-Green deployments and the WAP pattern for BigQuery data warehouse projects with dbt at the last dbt Office Hours. I put together a few slides for the talk, available here, and the recorded talk is also available if you enjoy your slides narrated with an accent.