With dbt, data analysts and engineers can build analytics the way engineers build applications.
Project description
[!WARNING] dbt Core v1 development has moved to the
1.latestbranch. Themainbranch now hosts dbt Core v2.0 (alpha) — a ground-up rewrite in Rust that is the foundation of the Fusion engine. If you're looking for the Python implementation of dbt Core, switch to1.latest.
dbt enables data analysts and engineers to transform their data using the same practices that software engineers use to build applications.
About dbt Core v2.0
🚧 dbt Core v2.0 is in alpha. Behavior, APIs, and on-disk formats may change before the stable release.
dbt Core v2.0 is engineered for performance at scale — parsing, compiling, and running projects in a fraction of the time compared to v1. It's released under the Apache 2.0 license and is the foundation of the Fusion engine.
The big shifts from v1:
- Faster — parse and compile times are dramatically improved, especially on the largest dbt projects.
- Stricter — a tightly-defined language specification enforces correctness at parse time.
- More scalable artifacts — v2.0 produces Parquet artifacts that can be easily queried, joined, and analyzed to understand your dbt project. The artifacts encompass everything in the JSON artifacts (e.g.
manifest.json), which continue to be produced for backwards compatibility. - Easier to install — distributed as a single self-contained binary, with no Python runtime or dependency management required.
- A completely revamped local documentation experience — dbt docs is now powered by those new artifacts and capable of scaling to large projects.
Supported operating systems and architectures
dbt Core v2.0 and its drivers are compiled per operating system and architecture.
Legend:
- 🟢 — Supported today
- 🟡 — Not yet supported
| Operating system | x86-64 | ARM |
|---|---|---|
| macOS | 🟢 | 🟢 |
| Linux | 🟢 | 🟢 |
| Windows | 🟢 | 🟡 |
Understanding dbt
Analysts using dbt can transform their data by simply writing select statements, while dbt handles turning these statements into tables and views in a data warehouse.
These select statements, or "models", form a dbt project. Models frequently build on top of one another – dbt makes it easy to manage relationships between models, and visualize these relationships, as well as assure the quality of your transformations through testing.
Getting started
Start by choosing a distribution. dbt Core is the baseline distribution of dbt. Fusion extends dbt Core with additional SQL comprehension abilities. Both distributions are free to install and can run locally.
- If you need an Apache 2.0 licensed tool and the ability to review every line of code inside of it, install dbt Core.
- If you need a free CLI you can use locally, install Fusion. It can do more than dbt Core out of the box and you can seamlessly enable other advanced features over time if you choose to.
Regardless of the distribution you choose, each is part of a single framework with a single language specification, meaning your business logic is portable in both directions.
Explore the dbt platform for an enhanced collaboration experience. Read the introduction and viewpoint
Join the dbt Community
- Be part of the conversation in the dbt Community Slack
- Read more on the dbt Community Discourse
Reporting bugs and contributing code
- Want to report a bug or request a feature? Let us know and open an issue
- Want to help us build dbt? Check out the Contributing Guide
Code of Conduct
Everyone interacting in the dbt project's codebases, issue trackers, chat rooms, and mailing lists is expected to follow the dbt Code of Conduct.
License
dbt Core is licensed under the Apache License 2.0.
Project details
Release history Release notifications | RSS feed
Download files
Download the file for your platform. If you're not sure which to choose, learn more about installing packages.
Source Distributions
Built Distributions
Filter files by name, interpreter, ABI, and platform.
If you're not sure about the file name format, learn more about wheel file names.
Copy a direct link to the current filters
File details
Details for the file dbt_core_experimental_parser-2.0.0.dev26-py3-none-win_amd64.whl.
File metadata
- Download URL: dbt_core_experimental_parser-2.0.0.dev26-py3-none-win_amd64.whl
- Upload date:
- Size: 53.9 MB
- Tags: Python 3, Windows x86-64
- Uploaded using Trusted Publishing? No
- Uploaded via: dbt-ci/2.0.0-dev.26
File hashes
| Algorithm | Hash digest | |
|---|---|---|
| SHA256 |
3c3989d9eb223131a9a1cd40b0ba6edb475d139fa175c65a6d1ca5ee455d99f1
|
|
| MD5 |
5855effde8f2bcd048d12a5d18e0c0a5
|
|
| BLAKE2b-256 |
4839b8754c55fc67c09dc0a9520cd6194fba8a73cd60e0ad2051d7814e310c57
|
File details
Details for the file dbt_core_experimental_parser-2.0.0.dev26-py3-none-manylinux_2_28_x86_64.whl.
File metadata
- Download URL: dbt_core_experimental_parser-2.0.0.dev26-py3-none-manylinux_2_28_x86_64.whl
- Upload date:
- Size: 48.5 MB
- Tags: Python 3, manylinux: glibc 2.28+ x86-64
- Uploaded using Trusted Publishing? No
- Uploaded via: dbt-ci/2.0.0-dev.26
File hashes
| Algorithm | Hash digest | |
|---|---|---|
| SHA256 |
06e627473bbb6e26e28f4147cb05a3bb0406ab80d5cb3623a6af26bab96deda5
|
|
| MD5 |
26e39642c1be1efa767bc5006e77db41
|
|
| BLAKE2b-256 |
f95b53efecf064f582eed21de8585169650cbc57efbb3e463c5cb59da821f6a8
|
File details
Details for the file dbt_core_experimental_parser-2.0.0.dev26-py3-none-manylinux_2_28_aarch64.whl.
File metadata
- Download URL: dbt_core_experimental_parser-2.0.0.dev26-py3-none-manylinux_2_28_aarch64.whl
- Upload date:
- Size: 44.6 MB
- Tags: Python 3, manylinux: glibc 2.28+ ARM64
- Uploaded using Trusted Publishing? No
- Uploaded via: dbt-ci/2.0.0-dev.26
File hashes
| Algorithm | Hash digest | |
|---|---|---|
| SHA256 |
ce411168d2b2d9c3db4b6a12196a12e9a0cdf7e1b1cd421a7ef7e78a9f2cd8c1
|
|
| MD5 |
101c0d95dab8abb2d817c879c3c34b96
|
|
| BLAKE2b-256 |
34e574420c5e504818452425551973699296434299d6df5c79f9ed66a6d8a701
|
File details
Details for the file dbt_core_experimental_parser-2.0.0.dev26-py3-none-macosx_11_0_arm64.whl.
File metadata
- Download URL: dbt_core_experimental_parser-2.0.0.dev26-py3-none-macosx_11_0_arm64.whl
- Upload date:
- Size: 43.6 MB
- Tags: Python 3, macOS 11.0+ ARM64
- Uploaded using Trusted Publishing? No
- Uploaded via: dbt-ci/2.0.0-dev.26
File hashes
| Algorithm | Hash digest | |
|---|---|---|
| SHA256 |
1eaa7d09233ea78fc2314e53ac4a3ded9e747bec54be0a6bfc252ad05e00b269
|
|
| MD5 |
d896357f5625387edab9381d41c6a843
|
|
| BLAKE2b-256 |
57fbc4f27ba10a3e9b05e8376e9b9eee8c509278d22993477a06bb9aa8387937
|
File details
Details for the file dbt_core_experimental_parser-2.0.0.dev26-py3-none-macosx_10_12_x86_64.whl.
File metadata
- Download URL: dbt_core_experimental_parser-2.0.0.dev26-py3-none-macosx_10_12_x86_64.whl
- Upload date:
- Size: 48.2 MB
- Tags: Python 3, macOS 10.12+ x86-64
- Uploaded using Trusted Publishing? No
- Uploaded via: dbt-ci/2.0.0-dev.26
File hashes
| Algorithm | Hash digest | |
|---|---|---|
| SHA256 |
9e5c113b679e5eadaf452a146f915b0425bda0a1288131ab8ff10dc5e9e47099
|
|
| MD5 |
e1353b9cf16d4e4de503ebcb9dcd0b8b
|
|
| BLAKE2b-256 |
04f92df6de9e3e2a1e57605bd1e05527d782f443c9f9ad09b91bf876a5dd015d
|