One to many: Moving from a monolithic dbt project to multi-project collaboration - Coalesce 2023

At the beginning of this year, Cityblock Health was afforded a unique opportunity: to rebuild their existing dbt project from scratch. Launched in mid-2019, the legacy project had grown organically into a tangled mess of 1800+ models, with further development becoming more and more difficult. Faced with the challenge of retroactively imposing order on the existing project, their leadership gave them the opportunity to start fresh instead. They jumped at the chance, and began applying many of the lessons they learned at Coalesce 2022 to set the new project up for success: - SQL linting, with SQLFluff - YAML linting, with yamllint - dbt best practices, with dbt-checkpoint and dbt-project-evaluator As a result, this core project has become the model for multi-project collaboration at Cityblock. Rather than a single monolithic project, the new state features a collection of smaller projects, each governed by a high bar for code quality. Speakers: Katie Claiborne, Staff analytics engineer, Cityblock Health; Nathaniel Burren, Analytics Engineer, Cityblock Health Register for Coalesce at https://coalesce.getdbt.com