dbt

dbt (data build tool) is the standard framework for data transformation in modern data stacks. It enables data analysts and engineers to write modular SQL transformations as version-controlled code with testing, documentation, and lineage tracking built in. dbt Core is open-source and dbt Cloud adds a managed platform with scheduling, CI/CD, and collaboration features. Used by data teams at Spotify, GitLab, and JetBlue for building reliable, tested, documented analytics pipelines that transform raw warehouse data into analysis-ready models.