dbt

dbt enables data analysts and engineers to transform their data using the same practices that software engineers use to build applications.

What is dbt?

dbt enables data analysts and engineers to transform their data using the same practices that software engineers use to build applications.

Overview of dbt

What it is

dbt enables data analysts and engineers to transform their data using the same practices that software engineers use to build applications. dbt v2.0 is a ground-up rewrite in Rust, engineered for performance at scale. It parses, compiles, and runs projects faster than v1. The source code is available under the Apache 2.0 license.

Key features

  • Faster parse and compile times, especially on large projects.
  • Stricter language specification that enforces correctness at parse time.
  • More scalable artifacts in Parquet format, with JSON artifacts for backwards compatibility.
  • Easier installation as a single self-contained binary, no Python runtime required.
  • Completely revamped local documentation experience powered by new artifacts.
  • Supported on macOS (x86-64 and ARM), Linux (x86-64 and ARM), and Windows (x86-64).

Use cases

Analysts can transform data by writing SQL select statements, which dbt turns into tables and views in a data warehouse. Models form a dbt project and can build on each other, with dbt managing relationships and enabling visualization. Testing ensures data quality. The dbt platform provides enhanced collaboration.

Getting started

See the repository README for installation and quick-start instructions.

License and pricing

Open source under the Apache License 2.0. Pricing is open source (free).

Based on the project's public README and repository metadata.

Add this badge to your README

Featured on YunoDB Badge styles & help

Maintain this project? Show that it is featured on YunoDB.

Markdown[![Featured on YunoDB](https://yunodb.com/badge/dbt-labsdbt.svg)](https://yunodb.com/tools/dbt-labsdbt?utm_source=github&utm_medium=badge)
HTML<a href="https://yunodb.com/tools/dbt-labsdbt?utm_source=github&utm_medium=badge"><img src="https://yunodb.com/badge/dbt-labsdbt.svg" alt="Featured on YunoDB" height="20"></a>