Overview
dbt-core is the core component of dbt that enables analysts and engineers to manage data transformations and modeling using SQL and software engineering best practices. It turns transformation logic into reusable, testable, and deployable code, improving reliability of data pipelines.
Key Features
- SQL-first modeling with Jinja templating and macros.
- Engineering practices: tests, documentation, dependency graphs, and CI integration.
- Broad compatibility with major data warehouses and platforms.
Use Cases
- Enterprise data warehouses for BI and analytics.
- Collaborative analytics through code-based models and tests.
- Automated data platform deployments via CI/CD pipelines.
Technical Details
- Stack: SQL-centered with Python extensions for advanced workflows.
- Extensibility: plugins and adapters for different warehouses and runtimes.
- License: Apache-2.0.