dbt

dbt (data build tool) applies software engineering rigor (testing, version control) to analytics, transforming raw warehouse data via SQL.

dbt is the modern standard for data transformation: it enables analytics engineers to build modular, maintainable data products directly in the cloud data warehouse. You define all transformations using simple SQL `SELECT` statements, centralizing business logic for clarity and collaboration. The framework enforces engineering best practices: specifically, Git for version control, automated testing to ensure data quality, and documentation generation for every model. This process delivers reliable, governed data pipelines at scale, moving analytics teams from raw data to trusted outputs with confidence.

https://www.getdbt.com