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
Open-source agentic schema for reliable data outputs with native dbt integration. Go from dbt model to agent-ready metrics via CLI.
- 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!
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.
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.
Orchestration
- Auto-generating an Airflow DAG using the dbt manifest
Yet another article on extracting value from the manifest file.
- Bruin
Run and schedule dbt-style SQL transformations without Airflow. Adds data ingestion (50+ sources) and built-in data quality to the transformation layer. Open-source CLI or managed
- Building a robust data pipeline with the dAG stack: dbt, Airflow, Great Expectations
Demonstration of a data orchestration project with Airflow.
- Building a Scalable Analytics Architecture with Airflow and dbt
Leveraging the dbt manifest in Airflow.
Data Quality
- BigQuery Stale data detection
Stale data detection with dbt and BigQuery dataset metadata.
- 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.
- Elementary
A dbt package that provides data anomaly detection as dbt tests.
- Environment-dependent Unit Testing in dbt
Guide on how to run unit tests in dbt dynamically.
Showing a sample of 294 resources. View the full list on GitHub →