Advanced dbt
Paid Uplimit course on advanced dbt topics.
A curated list of awesome dbt resources
This page lists names, links and short descriptions. The original list on GitHub is the source and belongs to its authors.
Paid Uplimit course on advanced dbt topics.
Paid Udemy course that covers theory, building a dbt project from scratch, and deploying to dbt Cloud.
Complete course covering both theory & practice through real-world Airbnb use-case.
Data engineering course on cutting edge tools including dbt.
Paid course offered by Uplimit covering the basics of dbt.
Free dbt Labs course on refactoring legacy SQL into modular dbt models.
Official free course by dbt Labs. Excellent for learning the basics of dbt.
Guides you through a setup paired with Snowflake, with extras.
Datacoves' cheat sheet covering the Jinja additions in dbt Core.
A comprehensive canvas guide to dbt, from the basics to advanced topics.
How tags set in dbt_project.yml, property files and config blocks combine and inherit.
Quick reference for the Jinja syntax used in dbt models and macros.
Tips from community members.
Excellent companion to your dbt practice with rich collection of tips.
Hands-on tutorial for building your first project in dbt Cloud.
Official dbt Labs style guide for models, SQL, YAML and Jinja.
Official dbt Labs guide to organizing staging, intermediate and mart models.
Standards for well organized base layer with Airbyte ingestion.
Clean out warehouse models which are not existent in the project.
GitLab Data Team's guide to setting up and working with dbt.
Checklist on items necessary for a successful dbt project.
One dbt project that runs some models on Snowflake and others on DuckDB, both reading and writing the same Iceberg tables through Snowflake's Horizon catalog, with no S3 bucket or IAM setup.
Best practices for running dbt on Redshift, including performance tuning and dbt code optimizations.
A dbt & Snowflake workshop on financial data.
An alternative guide to set up your dbt-external-tables workflow.
Things you should be aware of when using external tables with dbt.
Configuring BigQuery for your dbt project.
How to own your real-time transformation workflows like batch-based alternatives.
Demonstration of integration with Azure.
How Monzo built an extension framework for dbt.
Reflection on one-year usage of dbt.
Behind the community of analytics engineers.
Behind the upheaval of the analytics engineer profession.
Open-source notebook for running, exploring, and debugging dbt projects with interactive data analysis.
A modern web-based user interface for dbt-core projects.
An open UI for dbt providing model browsing, lineage visualization, run orchestration, documentation, environment management — without vendor lock-in. Designed for local, on‑prem, and air‑gapped deployments.
A local web application that provides a user-friendly interface to monitor and manage dbt runs.
Docs composer and column-level lineage in VS Code.
A Neovim plugin for dbt model editing.
VS Code extension for dbt: model lineage, query preview, autocompletion and documentation.
VS Code extension to preview and compare dbt CTEs on both sides of a diff.
CLI health check and linter for dbt projects (SQL, YAML, Jinja): 190+ custom rules, optional SQLFluff, 0–100 score, GitHub Actions CI, and coding-agent skills.
Rust-powered linter that checks dbt projects and their metadata against best practices.
Configure and enforce conventions for your dbt project.
Linter for dbt metadata.
Pre-commit hooks that check your dbt project (docs, tests, naming) before changes are committed.
Audits the dbt DAG and generates a summary report.
Highlights areas of a dbt project that are misaligned with dbt Labs' best practices.
Formats your dbt SQL code so you don't have to.
SQL linter that supports dbt and Jinja templating.
Checks dbt docs and tests coverage.
Enforce documentation and test coverage on your models.
Cookiecutter template for dbt projects.
Generate dbt yml files using the CUE language.
Automated YAML management and a Streamlit workbench to speed up dbt development.
CLI for creating, updating, and deleting dbt property files.
Macros that generate dbt code, and log it to the command line.
CLI tool for generating a scaffold for your dbt project.
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.
Write your dbt models using Ibis, the portable Python dataframe library.
A tool to help you stay in flow state while developing dbt models.
Feature Flags in dbt models.
All the basics to get a nice containerized dbt development environment.
Work with catalog.json, manifest.json, run_results.json and sources.json as Python objects.
A version manager for dbt.
Handy bash function to run changed models since last commit.
Search dbt models interactively from terminal.
Tools and setup tips that improve the dbt development experience.
Imports dbt semantic models (semantic_manifest.json) so an MCP server or LangChain retriever gives the LLM only the tables a question needs: about 91% fewer schema tokens on text-to-SQL, #1 on the BIRD Mini-Dev leaderboard.
Snapshots each warehouse table's DDL, joins and column values (value lists, null shares, ranges) into files committed to your repo, which coding agents read through an MCP server or a skill instead of querying the warehouse. Reads column lineage from a compiled dbt manifest, so a note on a source…
Agent skills (Claude Code, Codex) that author dbt models, tests, and MetricFlow semantic models as reviewable diffs, profile source warehouses read-only, and detect schema, grain, and semantic drift. Apache-2.0.
Gives coding agents instant dbt lineage: no dbt compile, no Python, no grep. Fast model-level lineage CLI parsing SQL files directly (or a manifest.json), with experimental column-level lineage too.
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%).
Governed, multi-tenant MCP access to customer data. Turn your dbt models into a secure, per-customer MCP for AI agents.
A curated collection of agent skills, built and maintained by dbt Labs, to help AI coding agents work more effectively with dbt.
MCP server that wraps the dbt CLI, so agents can run, test and inspect dbt projects.
Official dbt Labs MCP server: lets AI agents query the dbt Semantic Layer, discover models and lineage, and run dbt commands.
AI data analyst for Slack, Microsoft Teams and the web. Syncs your dbt project (model and column docs, SQL, lineage) to write more accurate SQL, and exports its dashboards back to dbt as exposures.
AI data analyst that builds a knowledge base from your dbt models and docs and answers questions in a web app or Slack (formerly dbt-llm-tools).
An AI-powered CLI tool for converting dbt SQL files to YAML using OpenAI.
CLI for Altimate's AI teammate that checks SQL and dbt projects against best practices.
An experiment in productionizing LLMs: a dbt pipeline that asks a language model whether two product records are the same item.
Generates dbt tests and model metadata from data contracts in the Open Data Contract Standard (ODCS) and runs them, so a contract stays the source of truth for your models.
Free browser tool that writes copy-ready SQL for freshness, row count, null rate, duplicate key and job heartbeat checks across 10 dialects.
Static checker that flags SUM, COUNT and AVG computed after joins that can repeat rows (fan outs and chasm traps). Infers the grain of every model from unique tests and the SQL itself, with no warehouse connection, so it runs in CI or pre-commit.
Fails the pull request when a model stops producing what a downstream consumer expects. Reads columns from catalog.json/manifest.json (falling back to a sqlglot parse of the SQL) and compares them against reverse-ETL destinations such as HubSpot CRM and against FastAPI/Pydantic services, in CI or…
Generate known-answer seed and test data for dbt models: declare the expected aggregates (revenue curves, rates, rollups) and assert your models return them exactly.
Generate dbt tests based on sample data.
Package to assert rows in-line with dbt macros.
How to use grouped checks in dbt-utils to keep your data on track.
A pytest plugin for testing your dbt projects.
Test-driven development in dbt with the dbt-unit-testing package.
Package which contains macros to support unit testing.
Guide on how to run unit tests in dbt dynamically.
Great Expectations-style tests as dbt macros. Maintained fork by Metaplane of the original calogica package, which is no longer supported.
Suggestions on testing your data powered by the community.
Unit test using source defer and generic custom tests.
Column-level drift detection and lineage-based root-cause analysis for dbt projects.
Agentic data quality framework that runs YAML rules against your warehouse (DuckDB, BigQuery, Snowflake, Databricks, Athena, PostgreSQL), then uses LLMs to diagnose failures, trace root causes, and propose SQL fixes. Pairs naturally with dbt models as the validation layer after dbt run.
Zero-config data quality CLI that complements dbt test with auto-detected anomalies (volume, schema drift, freshness, distribution, cardinality) on every materialized model after dbt run.
Open source observability and alerting across your data estate, with fast data quality test generation and execution.
CLI companion that turns dbt test results into detailed alerts on the platforms your team already uses.
Store dbt test results and visualize them in a BI dashboard built on 6 data quality KPIs.
Stale data detection with dbt and BigQuery dataset metadata.
Data observability for dbt: anomaly detection as dbt tests, plus a report of test results and run history.
Data observability platform on top of your dbt and BI stack.
Integration of Soda's data observability platform and dbt.
A dbt package for monitoring metrics and detecting anomalies.
Comments on every pull request with the downstream models, columns and dashboards a change breaks, plus a dbt run -s selector for the minimal rebuild. Parses the project directly, so CI needs no warehouse, dbt compile or Python; also ships as a CLI, TUI, VS Code extension and MCP server.
Makes every dbt command start faster by keeping dbt preloaded in a background daemon and forking it per call, with no configuration. Measured: dbt ls 3.9 s to 1.2 s, dbt --help 2.7 s to 30 ms, same output as plain dbt.
Diff large datasets within or across databases. Maintained continuation of Datafold's data-diff, which is archived.
terraform plan for dbt: diffs compiled SQL between two revisions to predict the DDL dbt run would emit. Names the columns an on_schema_change: sync_all_columns model will drop, the downstream models and data tests that drop breaks, and enforced-contract violations. Reads files only -- no warehouse…
A complete CI/CD process for a dbt project: defer (slim CI) and unit tests for CI, automatic deployment to lower environments, and Write-Audit-Publish with dbt clone for production.
A demo CI/CD implementation using GitHub Actions, including slim CI and unit tests.
Example setup that demonstrates best practices for testing and deploying dbt models.
Data-diff solution for dbt-ers with Snowflake.
Implement dbt Cloud's Slim CI job pattern with dbt Core.
Showcase of advanced options when running CI for dbt.
Detailed walkthrough of setting up Slim CI in dbt Cloud.
Data diffs in CI: see how a change affects the data before it's merged.
Perform DataOps & administrative CI/CD on your data warehouse.
Auto Trader's tool that validates a whole dbt project with BigQuery dry run jobs, catching invalid SQL in seconds without running any models.
How to set up slim CI on Bitbucket.
Use Snowflake zero-copy clones to run slim CI checks against production data.
A tidy, fail-safe way to run dbt in production with two parallel production environments.
Limit data in long-running CI checks to speed up development.
Checkpoints to consider when reviewing an analytics engineer PR.
Leverage GitHub Actions to set up CI/CD with dbt Core.
Open-source platform that runs dbt-core transformations alongside dlt-powered extract and load, with 36 connectors, cron scheduling, and run history in one web UI. AGPL-3.0, self-hostable with Docker Compose or Helm.
Hosted dbt-core scheduler. Connect your repo, pick dbt-core and adapter version, set a cron, run dbt-core in isolated Docker containers. No Airflow to manage.
CLI tool to copy data from any source to any destination with a single command. Load data into your warehouse before dbt transforms it. Supports 50+ sources including PostgreSQL, MongoDB, Salesforce, Shopify.
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 Bruin Cloud for teams who want dbt Cloud-like experience with ingestion included.
Open source Python library for loading data into your warehouse, ready for dbt.
Run your dbt Core projects as Apache Airflow DAGs and Task Groups.
Run dbt jobs on Modal, a serverless application platform.
Save by replacing dbt Cloud with GitHub Actions.
Prefect integration for running dbt Core and dbt Cloud jobs from your Prefect flows.
Primer about dbt on Azure Data Stack.
Load dbt models as Dagster assets and orchestrate them alongside the rest of your pipelines.
Leveraging the dbt manifest in Airflow.
Demonstration of a data orchestration project with Airflow.
Materializations for SCD Type 0, 1 and 2 tables on Snowflake with shared audit columns, soft-delete handling, a metadata-preserving full refresh and an scd2_join macro for temporal joins.
Python library for generating models from a declarative YAML configuration. It supports multiple data modeling approaches including Data Vault 2.0, Anchor Modeling, and Dimensional Modeling, with template packages for popular dbt libraries.
Macro to join dbt snapshots.
A step by step guide on how to build Kimball dimensional models with dbt.
Data Quality Observation of Data Vault layer.
Generate AutomateDV (formerly dbtvault) files from YAML metadata.
Generates a complete dbt project of Data Vault models for the datavault4dbt package from source metadata (successor of turbovault4dbt).
Macros for staging and creation of all DataVault-Entities you need, to build your own DataVault2.0 solution.
Package for generating and executing ETL for Data Vault 2.0 (formerly dbtvault).
TypeScript SQL parser and static analyzer: type inference, schema diagnostics, and column-level lineage. Reads Jinja-templated SQL (dbt models) natively, without rendering.
Self hostable column-level lineage for dbt core projects.
Visualize the column-level lineage of dbt models.
Extract column-level lineage from dbt projects.
A Column Level Lineage Graph for dbt.
Serve the site from dbt docs generate as a Databricks App, with a small Python server that handles the docs' client-side routing.
Interactive ER diagrams from a dbt manifest.json (keys and relationships inferred from tests) or QuickDBD/DBML text, readable at 200+ tables, with schema diffs as PR comments and a VS Code extension.
VS Code extension that puts a visual ERD designer inside your dbt repo. Two-stage (logical/physical) canvas, drift detection against manifest.json, auto-generated selectors.yml, and AI-readable semantic models (YAML/JSON) with a built-in harness for Claude, Copilot, Gemini, and Codex.
Documentation Build Tool - Generate YAML documentation for dbt models with optional AI assistance. Built with Streamlit for an intuitive and familiar web interface.
CLI that builds a browsable UI of your latest dbt run from the target folder.
Generate an ERD via dbdiagram.io from a dbt project.
Open source data catalog with governance and observability: view models, docs, test results and column-level lineage across dbt projects and downstream dashboards.
Automate the creation of dbt exposures from different sources.
A rewrite of dbt docs using Next.js with React Server Components and SSG.
How to deploy dbt docs as a static website with App Engine and GitHub Actions.
CLI to generate DBML file from dbt manifest.json.
Automatically generate ERDs and display in your docs site.
A GitHub action for exporting dbt model docs to a Notion database.
Generates ERDs from a dbt project.
A dbt package for Snowflake Dynamic Data Masking.
Macros to make it easier to protect your customers' data.
Tag-based masking policies management in Snowflake.
Semantic layer that turns every dbt model into a governed cube with dimensions, measures, joins and descriptions. Re-syncs from CI or on every push by parsing your project, without touching the warehouse.
Define metrics in code and generate the SQL to compute them. Powers the dbt Semantic Layer and replaces the deprecated dbt_metrics package.
Materialize Snowflake Semantic Views with dbt and reference them from downstream models.
Build a GraphQL API on top of your dbt project.
How to leverage dbt as a data catalog and semantic layer (joins, synonyms, etc.) that BI tools can just plug into.
A dbt<>Superset connector that leverages Superset's API capabilities and dbt's manifest.
Generate LookML from dbt.
Best practices in Business Intelligence standards for integrating with dbt.
Business Intelligence platform with deep dbt Cloud and CLI integration.
Eliminate the need for a data modeling semantic layer in BI.
Model synchronization from dbt to Metabase.
Generate Looker views for dbt models.
Push and pull metadata between dbt and Superset.
Open source Looker alternative with deep dbt integration.
Open source visualization layer for your Modern Data Stack.
Feature engineering macros (scaling, encoding, imputation) that run inline in your dbt models.
Linear regression in SQL using dbt.
Package for dbt that allows users to train, audit and use BigQuery ML models.
Landscape of ML utilities around dbt.
Macros to build a feature store right within your dbt project.
A SQL port of scikit-learn's preprocessing module, provided as cross-database dbt macros.
Guide for large scale dbt projects.
A dbt-core plugin to weave together multi-project dbt-core deployments.
How to get started with a team dbt workflow in a monorepo.
Mono-repo or not mono-repo?
Package by dbt Labs that analyzes warehouse compute, storage and query patterns and recommends clustering, materialization and warehouse sizing changes. GA on Snowflake, beta on Databricks, BigQuery and Redshift.
Reuses unchanged models and rebuilds only when their code or upstream data changed, cutting run time and warehouse cost. A free, self-hosted alternative to dbt State.
Automatically tag dbt-issued queries with informative metadata, on multiple warehouses (successor of dbt-snowflake-query-tags).
Builds a mart of tables from dbt artifacts in your warehouse, to monitor runs, models and tests over time.
A dbt package for monitoring Airflow DAGs and tasks.
Takes dbt runs and turns them into OpenTelemetry traces.
Combining ingestion-time partitioning and partition copy is a great way to achieve better performance for your models.
Package by dbt Labs to monitor Snowflake usage.
Database- and table-level usage insights from Snowflake.
A dbt package to help you monitor Snowflake performance and costs.
Using project artifacts to identify anomalies and room for refactoring.
A GitHub action for downloading dbt artifacts from dbt Cloud CI jobs.
Stream Deck plugin that shows the status of dbt Cloud models and jobs.
Package to calculate dbt Cloud usage-based cost.
Use-cases and examples for the dbt Cloud Discovery API.
Queries the dbt Cloud API to return some useful information about your models (number of tests, time they took to run etc…).
Cancels stale dbt Cloud CI runs when new commits arrive, so CI always tests the newest code.
Unofficial Python client for the dbt Cloud APIs.
Raycast integration to monitor dbt Cloud Jobs.
Manage dbt Cloud as infrastructure as code, now maintained by dbt Labs.
Currency exchange rate macros and models for dbt, powered by the UniRate API.
A free to use dbt package with helper macros.
A dbt package for Snowflake Streams.
A dbt package containing reconfigured macros.
A collection of dbt macros for working with Census data.
A self-updating dbt library that will maintain a list of current IANA/ICANN recognized top level domains.
Translate numbers into words.
Generate database constraints based on the tests in a dbt project.
Date logic and calendar functionality.
General macros and helpers.
Macros to stage your external sources.
Macros for data audits that compare columns values and schemas between tables.
Data profiling and doc block generator.
General macros library. A must have.
A code package from Microsoft for enabling dbt to work with Synapse Spark in Microsoft Fabric.
Generates Fabric Spark notebooks from dbt, by Insight; a fork of Microsoft's dbt-fabricspark.
The TimescaleDB adapter plugin for dbt.
A dbt adapter for working with Microsoft Fabric Data Warehouses.
A dbt adapter for working with Excel.
Trusted and community adapters listed by dbt Labs.
Production-ready template deploying dbt project to Snowflake using GH Actions.
A production grade ELT with tests, documentation and CI/CD (GHA) about french open data (housing, demography, geography, etc). Can be used to learn with voluminous and ambiguous data. Contributions are welcome.
Add 4 more integrations to your dbt CI pipeline: Slim CI, pre-commit hooks, Data Diffs, and Slack notifications.
Ingest, store, transform and serve insights from the official NBA API.
Daily updated fake data for dbt learning and projects.
A curated list of awesome public dbt projects.
MDS in a box deployed anywhere.
A demonstration of production gatekeepers in Snowflake and BigQuery.
Demo project for open source MDS.
F1 Data Pipeline.
E2E dbt project for scraping and transforming football data from Transfermarkt.
A dbt project for GitHub Archive data on BigQuery.
A workspace template for dbt demos.
A dbt project to monitor cloud costs.
Repo containing data and dbt template of the survey.
Explore the topic of fake GitHub stars.
Dagster's ability to create a global dependency graph between different dbt projects.
How to build a small and modern data infrastructure.
GitLab's open source dbt project.
A worked example to demonstrate how to model customer attribution.
A worked example to demonstrate how to model subscription revenue.
Set up your dbt environment with pre-installed extensions.
Demo stack combining dbt, Airflow and Great Expectations.
Sandbox project from dbt Labs, built around a fictional sandwich shop, for learning and testing.
Demonstration of Airflow integration.
Deploy BigQuery + Airflow.
Sample dbt project with Spotify user data.
Annual dbt Labs conference (formerly Coalesce), with keynotes and sessions on demand.
A conference for data teams.
Worldwide community driven analytics conference with a handful of talks fitting to the dbt stack.
Second edition of the analytics engineering conference.
List of community led dbt meetups.
Annual dbt conference full of fascinating use-cases.
Newsletter about dbt, with tips and tutorials on various topics.
A survey of pains, gains, and areas of investment for global data teams.
Weekly substack about metadata, the metrics layer and MDS.
Official dbt Labs newsletter on topics of the MDS.
Thought-provoking reads from the founder of Mode.
Weekly newsletter of recent trends in Data Engineering.
One of the most popular data engineering podcasts covering great concepts and new products.
Official podcast of dbt Labs.
Special guests discussing big data, business intelligence, modern data stack.
Official TikTok channel of dbt Labs.
A Slack community of aspiring analytics leaders discussing and sharing lessons learned and challenges from their experiences in using data.
Global online community of data enthusiasts. Podcasts and blogs, etc. are distributed with high frequency.
Automatically generate ERDs and display in your docs site.
Energy-filled hub of analytics engineers (Highly recommended).
Subreddit of data engineering topics.
awesome-dsh-plugin/awesome-dsh-plugin
A curated list of plugins for DeepSeek Harness (dsh) · DeepSeek Harness 插件精选列表
VoltAgent/awesome-openclaw-skills
The awesome collection of OpenClaw skills. 5,400+ skills filtered and categorized from the official OpenClaw Skills Registry.🦞
ai-boost/awesome-prompts
Curated prompts, frameworks and papers for LLMs and agents, with an engineering bias. Prompt engineering, context engineering, agent harnesses, red teaming.
piotrkulpinski/open-source-alternatives
Curated list of open source alternatives to proprietary software.
matiassingers/awesome-readme
A curated list of awesome READMEs
xixu-me/awesome-persona-distill-skills
Curated list of Agent Skills centered on people, relationships, commemorative scenes, and methodological perspectives