dbt Core
Transform data in your warehouse using modular SQL and software engineering best practices.
Why consider dbt Core?
dbt Core is an open-source command-line tool that enables data analysts and engineers to transform data in their warehouse using modular SQL select statements with automated testing and documentation.
Learn dbt Core by building
Practical setup notes, real use cases, and copy-ready examples in one focused guide.
In this guide3 sections
Overview of dbt Core
dbt (data build tool) applies software engineering workflows (modular code, version control, testing, documentation, CI/CD) to analytics engineering. Instead of writing unwieldy stored procedures, analysts write plain SELECT statements; dbt handles table and view materialization inside Snowflake, BigQuery, Redshift, or PostgreSQL.
Installing dbt Core
pip install dbt-postgresdbt init my_analytics_projectcd my_analytics_projectWriting and Running Models
In models/customers.sql:
with customer_orders as ( select customer_id, count(id) as total_orders, sum(amount) as lifetime_value from {{ source('raw_data', 'orders') }} group by 1)select * from customer_orders;Execute transformations and automated schema tests:
dbt rundbt testdbt docs generate && dbt docs servedbt Core is licensed under the Apache License Version 2.0.
Related tools
More options with a similar category or technology profile.
diskus
Minimal, fast alternative to du -sh written in Rust using multi-threaded directory traversal.
peco
Simplistic interactive filtering tool for Unix pipelines, process lists, and file trees.
Dapr CLI
Command-line tool for managing Dapr distributed application runtime environments and sidecars.
Freeze
Generate beautiful image screenshots and SVGs of code snippets and terminal outputs.