Hey everyone :smile: This is a common subject that...
# best-practices
s
Hey everyone 😄 This is a common subject that I imagine will come up again, but what are your prefered methods to perform CI in dbt ? It's not feasible for us to run
dbt-bigquery:build
on the entire warehouse, so I was thinking: • Create a target: ci • Set a marco on all staging tables that if target = ci, set limit to 100 rows • Build entire warehouse based on that. Does this seem feasible to you guys? Would this even be useful? I would take any and all suggestions on how to better this process
m
we are doing a lot of the dbt-checkpoint pre-commit checks in GitHub Actions on PRs https://github.com/dbt-checkpoint/dbt-checkpoint
we also do dbt-compile
we don’t do dbt-build currently, we don’t have a good CI-only target for that
s
And you aren't experiencing any issues with pushing bugs to production?
m
We’re still early enough in our adoption of dbt (and our stakeholders are early enough in their adoption of our warehouse) that I think that sort of issue happens, but isn’t very impactful yet
s
Makes sense, pretty cool you already have any CI at all then. I'll be looking to run DBT build in my own project, as well as maybe implement DBT project evaluator for best practices