awesome-dbt
github.com/hiflylabs/awesome-dbt ↗A curated list of awesome dbt resources
Use this list with your AI agent
Add the Context Awesome MCP server to Claude, Cursor, or any MCP client, then ask:
"Show me get started resources from awesome-dbt"
Installation instructions →What's inside
Get Started
- Accelerating and Scaling dbt for the Enterprise
Guide for large scale dbt projects. .
- Advanced dbt
Another paid course by Uplimit covering the advanced dbt topics.
- Analytics Engineering with dbt
Paid course offered by Uplimit covering the basics of dbt.
- Data Engineering Zoomcamp
Data engineering course on cutting edge tools including dbt.
- dbt Fundamentals
Official free course offered by dbt. Excellent for learning the basics of dbt Cloud.
- dbt in a real world scenario, A Beginner dbt tutorial
A beginner tutorial to understand dbt with a real world example.
How To
- Accelerating Data Teams with dbt & Snowflake
A dbt & Snowflake workshop on financial data.
- Automatically generate ERD
Automatically generate ERDs and display in your docs site.
- Best Practices for Leveraging Amazon Redshift and dbt
An overivew of best practices on how to integrate dbt with Redshift, that includes information about performance tunning and dbt code optimizations.
- Best Practices for Optimizing Your dbt and Snowflake Deployment
Pocket guide on optimization best practices with Snowflake.
- Best Practices for your dbt Style Guide
Standards for well organized base layer with Airbyte ingestion.
- Best Practices for your dbt Style Guide
Standards for well organized base layer with Airbyte ingestion.
Integrations
- Acryl DataHub
A unified data catalog, governance, and observability platform. Use it to view models, docs, test results, and column-level lineage across your dbt projects and downstream dashboards.
- Auto Alert - diqu
Automate and streamline the alerting/ notification process for dbt test results using this versatile CLI companion tool. Receive detailed alerts & test metadata seamlessly on various platforms, promoting improved collaboration on dbt project issues 🐞🚀.
- Bonnard
Governed, multi-tenant MCP access to customer data. Turn your dbt models into a secure, per-customer MCP for AI agents.
- Cube
APIs, Caching, and Access Control on top of dbt Metrics.
- Dagster and dbt: Better Together
Getting started with the dagster-dbt library.
- Datafold
Gives a quick print out summary of changes so you can move fast and (not) break stuff!
Data Quality
- Aegis DQ
Agentic data quality framework that runs YAML rules against your warehouse (DuckDB, BigQuery, Snowflake, Databricks, Athena, Postgres), then uses LLMs to diagnose failures, trace root causes, and propose SQL fixes. Pairs naturally with dbt models as the validation layer after
- BigQuery Stale data detection
Stale data detection with dbt and BigQuery dataset metadata.
- data-contract-validator
Fails the pull request when a model stops producing what a downstream consumer expects. Reads columns from
- DataKitchen Open Source Data Observability
Data breaks. Servers break. dbt and other tools break. Observability and alerting across and down your data estate. Save time with simple, fast data quality test generation and execution.
- dbt-expectations
Port between dbt and great_expectations to extend out-of-the-box tests.
- dq-tools
Make simple storing test results and visualisation of these in a BI dashboard leveraging 6 Data Quality KPIs.
Sample Projects
- airflow-dbt-demo
Demonstration of Airflow integration.
- Analytics Engineer Survey 2023
Repo containing data and dbt template of the survey.
- attribution-playbook
A worked example to demonstrate how to model customer attribution.
- awesome-public-dbt-projects
A curated list of awesome public dbt projects.
- aws athena x dbt
How to build a small and modern data infrastructure.
- Cloud Cost Monitoring
A dbt project to monitor cloud costs.
Utilities
- Altimate Code
Open-source data engineering harness with 100+ deterministic tools for building, validating, optimizing, and shipping data products — usable from any LLM, across your warehouses. Ranked #1 on ADE-Bench (78%).
- backfill
Terminal footer that pays you while dbt runs - one sponsored line on the bottom row during long commands (dbt Core and dbt Cloud CLI), 50% ad revenue share. Open-source Go CLI; never reads your code, queries, or output.
- Build Data Access Layer on dbt
Package to build GraphQL API on top of your dbt project.
- Clean your warehouse of old and deprecated models
Clean out warehouse models which are not existent in the project.
- cookiecutter-dbt
Cookiecutter template for dbt projects.
- datapilot
AI teammate for engineers to ensure best practices in their SQL.
Community
- Analyitics Engineer Podcast
Official podcast of dbt Labs.
- Analytics Engineer Roundup
Official dbt Labs newsletter on topics of the MDS.
- Benn Stacil's Newsletter
Tought-provoking reads from founder of Mode.
- Coalesce 2020
Annual dbt conference full of fascinating use-cases.
- Coalesce 2021
Second iteration of the analytics engineer conference.
- Coalesce conference recordings
Recordings of Coalesce conferenfes from 2022 and after.
User Stories
- Analyzing Fishtown's dbt project performance with artifacts
Using project artifacts to identify anomalies and room for refactoring.
- Beware of DBT Incremental Updates Against Snowflake External Tables
Things you should be aware of when using external tables with dbt.
- Building an extension framework for dbt
How Monzo built an extension framework for dbt.
- dbt and the Analytics Engineer — what's the hype about
Behind the upheaval of the analytics engineer profession.
- dbt development at Vimeo
Best practises from the Vimeo Data team.
- dbt + Materialize: Streaming to a dbt project near you
How to own your real-time transformation workflows like batch-based alternatives.
Showing a sample of 304 resources. View the full list on GitHub →