Open source · dbt
dbt: analytics engineering with SQL
SQL transformations, macros/tests, docs, and governance for warehouses/Lakehouse
dbt (data build tool) is an open-source analytics engineering framework that uses SQL to define models and dependencies. It supports macros/Jinja, materializations, seeds, data tests, and autogenerated docs, building maintainable semantic layers and transformations on warehouses or Lakehouse.
SQL as code
Define models, dependencies, and macros in SQL + Jinja with table/view/incremental materializations.
Tests & docs
Built-in/custom tests, schema YAML, autogenerated docs and lineage.
Environments & workflows
CLI/self-hosted/dbt Cloud with CI/CD, previews, and permissions.
Ecosystem integrations
Works with major warehouses/Lakehouse and orchestrators/BI (Airflow, Dagster, Prefect).
适用场景 / Use cases
- Maintainable transformation layer on warehouses
- Semantic modeling for metrics/dimensions/facts
- Data quality testing and documentation
- Analytics engineering workflows with orchestration/BI