Too Long; Didn't Read
Data analysts mainly use SQL scripts to build their analysis. Each script will create a table into BigQuery (with drop/create or incremental strategy) Analysis is split into 3 parts: cleaning raw data cross data and building some common metrics build visualisation tables that we can plug to the dashboards (here we use Data Studio) Data analysts are not able to run directly dbt commands, but only makefile commands. We implemented a “magic method” that run all models that wasn’t tested since the last test execution. By doing this, we are sure that data analysts have tested the code before creating a PR.