Skip to content
83

Awesome dbt

A curated list of awesome dbt resources

1.8k stars194 forks295 entriesLast push Nov 9, 2026 (7 days ago)License GPL-3.0

This page lists names, links and short descriptions. The original list on GitHub is the source and belongs to its authors.

Learning >Courses

Advanced dbt

Paid Uplimit course on advanced dbt topics.

Mastering dbt: Beginner to Pro

Paid Udemy course that covers theory, building a dbt project from scratch, and deploying to dbt Cloud.

Link may be dead

Zero to Hero dbt

Complete course covering both theory & practice through real-world Airbnb use-case.

Link may be dead

Data Engineering Zoomcamp

Data engineering course on cutting edge tools including dbt.

In 2 lists

Analytics Engineering with dbt

Paid course offered by Uplimit covering the basics of dbt.

Refactoring SQL for Modularity

Free dbt Labs course on refactoring legacy SQL into modular dbt models.

dbt Fundamentals

Official free course by dbt Labs. Excellent for learning the basics of dbt.

Learn DBT from Scratch

Guides you through a setup paired with Snowflake, with extras.

Link may be dead

Learning >Tutorials & Cheat Sheets

dbt Jinja Functions Cheat Sheet

Datacoves' cheat sheet covering the Jinja additions in dbt Core.

The Ultimate Guide to dbt

A comprehensive canvas guide to dbt, from the basics to advanced topics.

Understanding the scopes of dbt tags

How tags set in dbt_project.yml, property files and config blocks combine and inherit.

Link may be dead

Jinja cheatsheet

Quick reference for the Jinja syntax used in dbt models and macros.

Tips and Tricks about working with dbt

Tips from community members.

dbt-tips

Excellent companion to your dbt practice with rich collection of tips.

dbt for Data Transformation – Hands-on

Hands-on tutorial for building your first project in dbt Cloud.

Learning >Best Practices

How we style our dbt projects

Official dbt Labs style guide for models, SQL, YAML and Jinja.

How we structure our dbt projects

Official dbt Labs guide to organizing staging, intermediate and mart models.

Best Practices for your dbt Style Guide

Standards for well organized base layer with Airbyte ingestion.

Clean your warehouse of old and deprecated models

Clean out warehouse models which are not existent in the project.

GitLab dbt Guide

GitLab Data Team's guide to setting up and working with dbt.

Your Essential dbt Project Checklist

Checklist on items necessary for a successful dbt project.

Learning >Platform Guides

Run dbt on Snowflake and DuckDB with shared Iceberg tables

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 Leveraging Amazon Redshift and dbt

Best practices for running dbt on Redshift, including performance tuning and dbt code optimizations.

Accelerating Data Teams with dbt & Snowflake

A dbt & Snowflake workshop on financial data.

Doing More With Less: Using DBT to load data from AWS S3 to Snowflake via External Tables

An alternative guide to set up your dbt-external-tables workflow.

Link may be dead

Beware of DBT Incremental Updates Against Snowflake External Tables

Things you should be aware of when using external tables with dbt.

Start Modeling Data

Configuring BigQuery for your dbt project.

dbt + Materialize: Streaming to a dbt project near you

How to own your real-time transformation workflows like batch-based alternatives.

Deploying and Running dbt on Azure Container Instances

Demonstration of integration with Azure.

Link may be dead

Learning >User Stories

Building an extension framework for dbt

How Monzo built an extension framework for dbt.

Link may be dead

Leveraging DBT as a Data Modeling tool

Reflection on one-year usage of dbt.

Link may be dead

Who's really using dbt?

Behind the community of analytics engineers.

dbt and the Analytics Engineer — what's the hype about

Behind the upheaval of the analytics engineer profession.

Link may be dead

Development >Editors, IDEs & UIs

Lunapad

Open-source notebook for running, exploring, and debugging dbt projects with interactive data analysis.

In 2 lists

dbt-ui

A modern web-based user interface for dbt-core projects.

dbt-Workbench

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.

dbt-command-center

A local web application that provides a user-friendly interface to monitor and manage dbt runs.

Turntable VS Code extension

Docs composer and column-level lineage in VS Code.

dbtpal

A Neovim plugin for dbt model editing.

dbt Power User

VS Code extension for dbt: model lineage, query preview, autocompletion and documentation.

cte-diff

VS Code extension to preview and compare dbt CTEs on both sides of a diff.

Development >Linting & Conventions

dbt-doctor

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.

dbtective

Rust-powered linter that checks dbt projects and their metadata against best practices.

dbt-bouncer

Configure and enforce conventions for your dbt project.

dbt-score

Linter for dbt metadata.

dbt-checkpoint

Pre-commit hooks that check your dbt project (docs, tests, naming) before changes are committed.

oliver-twist

Audits the dbt DAG and generates a summary report.

dbt-project-evaluator

Highlights areas of a dbt project that are misaligned with dbt Labs' best practices.

sqlfmt

Formats your dbt SQL code so you don't have to.

SQLFluff

SQL linter that supports dbt and Jinja templating.

In 4 lists

dbt-coverage

Checks dbt docs and tests coverage.

dbt-meta-testing

Enforce documentation and test coverage on your models.

Development >Code Generation

cookiecutter-dbt

Cookiecutter template for dbt projects.

dbt-cue

Generate dbt yml files using the CUE language.

dbt-osmosis

Automated YAML management and a Streamlit workbench to speed up dbt development.

dbt-invoke

CLI for creating, updating, and deleting dbt property files.

dbt-codegen

Macros that generate dbt code, and log it to the command line.

dbt-coves

CLI tool for generating a scaffold for your dbt project.

Development >Developer Utilities

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.

dbt-ibis

Write your dbt models using Ibis, the portable Python dataframe library.

fst: flow state tool

A tool to help you stay in flow state while developing dbt models.

dbt-feature-flags

Feature Flags in dbt models.

dbt-container-skeleton

All the basics to get a nice containerized dbt development environment.

dbt-artifacts-parser

Work with catalog.json, manifest.json, run_results.json and sources.json as Python objects.

dbtenv

A version manager for dbt.

Run changed models based on Git status

Handy bash function to run changed models since last commit.

fzf-dbt

Search dbt models interactively from terminal.

How we set up our computers for working on dbt projects

Tools and setup tips that improve the dbt development experience.

AI & LLMs >Agents, MCP & Skills

schemagate

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.

In 2 lists

dbprint

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…

Dex

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.

In 11 listsDetails

dlin

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.

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%).

Bonnard

Governed, multi-tenant MCP access to customer data. Turn your dbt models into a secure, per-customer MCP for AI agents.

In 2 lists

dbt-agent-skills

A curated collection of agent skills, built and maintained by dbt Labs, to help AI coding agents work more effectively with dbt.

dbt-cli-mcp

MCP server that wraps the dbt CLI, so agents can run, test and inspect dbt projects.

dbt MCP Server

Official dbt Labs MCP server: lets AI agents query the dbt Semantic Layer, discover models and lineage, and run dbt commands.

AI & LLMs >AI Assistants & Tools

Dot

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.

Ragstar

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).

turboYAML

An AI-powered CLI tool for converting dbt SQL files to YAML using OpenAI.

datapilot

CLI for Altimate's AI teammate that checks SQL and dbt projects against best practices.

Entity matching with LLMs in dbt

An experiment in productionizing LLMs: a dbt pipeline that asks a language model whether two product records are the same item.

Testing & Data Quality >Testing

Data Contract CLI

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.

SQL Data Checks

Free browser tool that writes copy-ready SQL for freshness, row count, null rate, duplicate key and job heartbeat checks across 10 dialects.

grainguard

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.

data-contract-validator

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…

Misata

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.

dbt-testgen

Generate dbt tests based on sample data.

dbt-assertions

Package to assert rows in-line with dbt macros.

Power up your data quality with grouped checks

How to use grouped checks in dbt-utils to keep your data on track.

pytest-dbt-core

A pytest plugin for testing your dbt projects.

Writing Unit Tests for dbt

Test-driven development in dbt with the dbt-unit-testing package.

dbt-unit-testing

Package which contains macros to support unit testing.

Environment-dependent Unit Testing in dbt

Guide on how to run unit tests in dbt dynamically.

Link may be dead

dbt-expectations

Great Expectations-style tests as dbt macros. Maintained fork by Metaplane of the original calogica package, which is no longer supported.

How do you test your data

Suggestions on testing your data powered by the community.

How to unit test sql transforms in dbt

Unit test using source defer and generic custom tests.

Testing & Data Quality >Data Observability

Upstrace

Column-level drift detection and lineage-based root-cause analysis for dbt projects.

Aegis DQ

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.

In 2 lists

Scherlok

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.

In 3 lists

DataKitchen Open Source Data Observability

Open source observability and alerting across your data estate, with fast data quality test generation and execution.

In 2 lists

diqu

CLI companion that turns dbt test results into detailed alerts on the platforms your team already uses.

dq-tools

Store dbt test results and visualize them in a BI dashboard built on 6 data quality KPIs.

BigQuery Stale data detection

Stale data detection with dbt and BigQuery dataset metadata.

Link may be dead

Elementary

Data observability for dbt: anomaly detection as dbt tests, plus a report of test results and run history.

In 2 lists

Metaplane

Data observability platform on top of your dbt and BI stack.

In 3 lists

Soda

Integration of Soda's data observability platform and dbt.

re_data

A dbt package for monitoring metrics and detecting anomalies.

CI/CD

dbt-lineage

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.

speedrunner

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.

In 3 lists

reladiff

Diff large datasets within or across databases. Maintained continuation of Datafold's data-diff, which is archived.

dbt-plan

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…

Guide to Running DBT in Production

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.

DBT CI/CD Demo with BigQuery and GitHub Actions

A demo CI/CD implementation using GitHub Actions, including slim CI and unit tests.

dbt-ci-cd

Example setup that demonstrates best practices for testing and deploying dbt models.

dbt-data-diff

Data-diff solution for dbt-ers with Snowflake.

How to Create CI/CD Pipelines for dbt Core

Implement dbt Cloud's Slim CI job pattern with dbt Core.

Link may be dead

dbt-beyond-the-basics

Showcase of advanced options when running CI for dbt.

Continuous Integration and Automated Build Testing with dbt Cloud

Detailed walkthrough of setting up Slim CI in dbt Cloud.

Link may be dead

Datafold

Data diffs in CI: see how a change affects the data before it's merged.

DDO

Perform DataOps & administrative CI/CD on your data warehouse.

dbt-dry-run

Auto Trader's tool that validates a whole dbt project with BigQuery dry run jobs, catching invalid SQL in seconds without running any models.

Slim CI/CD with Bitbucket Pipelines

How to set up slim CI on Bitbucket.

Test SQL Pipelines against Production Clones using DBT and Snowflake

Use Snowflake zero-copy clones to run slim CI checks against production data.

Link may be dead

Performing a blue/green deploy of your dbt project on Snowflake

A tidy, fail-safe way to run dbt in production with two parallel production environments.

How we speed up our CI runs by 10x using Slim CI

Limit data in long-running CI checks to speed up development.

How to review an analytics pull request

Checkpoints to consider when reviewing an analytics engineer PR.

How to set up a dbt data-ops workflow, using dbt cloud and Snowflake

Leverage GitHub Actions to set up CI/CD with dbt Core.

Orchestration & Ingestion

Datanika

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.

ModelDock

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.

ingestr

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.

In 6 listsDetails

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 Bruin Cloud for teams who want dbt Cloud-like experience with ingestion included.

In 6 listsDetails

dlt (data load tool)

Open source Python library for loading data into your warehouse, ready for dbt.

In 2 lists

Orchestrate dbt Core jobs with Airflow and Cosmos

Run your dbt Core projects as Apache Airflow DAGs and Task Groups.

modal-dbt

Run dbt jobs on Modal, a serverless application platform.

Why I moved my dbt workloads to GitHub and saved over $65,000

Save by replacing dbt Cloud with GitHub Actions.

Link may be dead

prefect-dbt

Prefect integration for running dbt Core and dbt Cloud jobs from your Prefect flows.

Run dbt in Azure Data Factory

Primer about dbt on Azure Data Stack.

Link may be dead

Dagster dbt integration

Load dbt models as Dagster assets and orchestrate them alongside the rest of your pipelines.

Building a Scalable Analytics Architecture with Airflow and dbt

Leveraging the dbt manifest in Airflow.

Building a robust data pipeline with the dAG stack: dbt, Airflow, Great Expectations

Demonstration of a data orchestration project with Airflow.

Data Modeling

dbt-scd2-utils

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.

metadv

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.

trange_join

Macro to join dbt snapshots.

How to create Kimball dimensional models with dbt

A step by step guide on how to build Kimball dimensional models with dbt.

dq-vault

Data Quality Observation of Data Vault layer.

dbtvault-generator

Generate AutomateDV (formerly dbtvault) files from YAML metadata.

TurboVault Engine

Generates a complete dbt project of Data Vault models for the datavault4dbt package from source metadata (successor of turbovault4dbt).

datavault4dbt

Macros for staging and creation of all DataVault-Entities you need, to build your own DataVault2.0 solution.

AutomateDV

Package for generating and executing ETL for Data Vault 2.0 (formerly dbtvault).

Data Governance >Lineage

sqllens

TypeScript SQL parser and static analyzer: type inference, schema diagnostics, and column-level lineage. Reads Jinja-templated SQL (dbt models) natively, without rendering.

dbt-colibri

Self hostable column-level lineage for dbt core projects.

dbt-column-lineage

Visualize the column-level lineage of dbt models.

dbt-column-lineage-extractor

Extract column-level lineage from dbt projects.

dbt-lineagex

A Column Level Lineage Graph for dbt.

Data Governance >Docs, Diagrams & Catalogs

dbt Docs on Databricks Apps

Serve the site from dbt docs generate as a Databricks App, with a small Python server that handles the docs' client-side routing.

quickdbd-cli

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.

ERD Studio

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.

docbt

Documentation Build Tool - Generate YAML documentation for dbt models with optional AI assistance. Built with Streamlit for an intuitive and familiar web interface.

metaplane cli

CLI that builds a browsable UI of your latest dbt run from the target folder.

dbt_to_dbdiagram

Generate an ERD via dbdiagram.io from a dbt project.

DataHub

Open source data catalog with governance and observability: view models, docs, test results and column-level lineage across dbt projects and downstream dashboards.

dbt-exposures-crawler

Automate the creation of dbt exposures from different sources.

Speeding up the dbt™ docs by 20x with React Server Components

A rewrite of dbt docs using Next.js with React Server Components and SSG.

dbt Docs as a Static Website

How to deploy dbt docs as a static website with App Engine and GitHub Actions.

Link may be dead

dbterd

CLI to generate DBML file from dbt manifest.json.

Automatically generate ERD

Automatically generate ERDs and display in your docs site.

dbt-docs-to-notion

A GitHub action for exporting dbt model docs to a Notion database.

In 14 listsDetails

dbt-erdiagram-generator

Generates ERDs from a dbt project.

Security & Privacy

dbt-snow-mask

A dbt package for Snowflake Dynamic Data Masking.

dbt-privacy

Macros to make it easier to protect your customers' data.

dbt-tags

Tag-based masking policies management in Snowflake.

BI & Semantic Layer

Cube

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.

MetricFlow

Define metrics in code and generate the SQL to compute them. Powers the dbt Semantic Layer and replaces the deprecated dbt_metrics package.

dbt_semantic_view

Materialize Snowflake Semantic Views with dbt and reference them from downstream models.

dal

Build a GraphQL API on top of your dbt project.

"Semantic-free" is the future of Business Intelligence

How to leverage dbt as a data catalog and semantic layer (joins, synonyms, etc.) that BI tools can just plug into.

Link may be dead

How HomeToGo connected dbt and Superset to make metadata more accessible and reduce analytical overhead

A dbt<>Superset connector that leverages Superset's API capabilities and dbt's manifest.

Link may be dead

looker-gen

Generate LookML from dbt.

Business Intelligence Standards

Best practices in Business Intelligence standards for integrating with dbt.

FlexIt Analytics

Business Intelligence platform with deep dbt Cloud and CLI integration.

Self-service Business Intelligence

Eliminate the need for a data modeling semantic layer in BI.

Link may be dead

dbt-metabase

Model synchronization from dbt to Metabase.

dbt2looker

Generate Looker views for dbt models.

dbt-superset-lineage

Push and pull metadata between dbt and Superset.

Lightdash

Open source Looker alternative with deep dbt integration.

In 3 lists

Superset

Open source visualization layer for your Modern Data Stack.

In 2 lists

Machine Learning

dbt-ml-inline-preprocessing

Feature engineering macros (scaling, encoding, imputation) that run inline in your dbt models.

dbt_linreg

Linear regression in SQL using dbt.

dbt_ml

Package for dbt that allows users to train, audit and use BigQuery ML models.

dbt + Machine Learning: What makes a great baton pass?

Landscape of ML utilities around dbt.

dbt-feature-store

Macros to build a feature store right within your dbt project.

dbt-ml-preprocessing

A SQL port of scikit-learn's preprocessing module, provided as cross-database dbt macros.

Scaling dbt >Large Projects & Mesh

Accelerating and Scaling dbt for the Enterprise

Guide for large scale dbt projects.

dbt-loom

A dbt-core plugin to weave together multi-project dbt-core deployments.

dbt Monorepo Workflow

How to get started with a team dbt workflow in a monorepo.

How to configure your dbt repository

Mono-repo or not mono-repo?

Scaling dbt >Performance, Monitoring & Cost

dbt-cost-optimization

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.

dbt-hodor

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.

dbt-query-tags

Automatically tag dbt-issued queries with informative metadata, on multiple warehouses (successor of dbt-snowflake-query-tags).

dbt_artifacts

Builds a mart of tables from dbt artifacts in your warehouse, to monitor runs, models and tests over time.

dbt-dag-monitoring

A dbt package for monitoring Airflow DAGs and tasks.

dbt_otel_export

Takes dbt runs and turns them into OpenTelemetry traces.

BigQuery Ingestion-Time Partitioning and Partition Copy With dbt

Combining ingestion-time partitioning and partition copy is a great way to achieve better performance for your models.

Link may be dead

snowflake-resource-monitoring

Package by dbt Labs to monitor Snowflake usage.

usagedata

Database- and table-level usage insights from Snowflake.

dbt-snowflake-monitoring

A dbt package to help you monitor Snowflake performance and costs.

Analyzing Fishtown's dbt project performance with artifacts

Using project artifacts to identify anomalies and room for refactoring.

dbt Cloud

dbt-cloud-download-artifacts-action

A GitHub action for downloading dbt artifacts from dbt Cloud CI jobs.

dbt-streamdeck

Stream Deck plugin that shows the status of dbt Cloud models and jobs.

dbt_cloud_run_cost

Package to calculate dbt Cloud usage-based cost.

Discovery API use-cases

Use-cases and examples for the dbt Cloud Discovery API.

Raycast dbt Metadata

Queries the dbt Cloud API to return some useful information about your models (number of tests, time they took to run etc…).

GitHub Action: Cancel Running CI Job

Cancels stale dbt Cloud CI runs when new commits arrive, so CI always tests the newest code.

dbtc

Unofficial Python client for the dbt Cloud APIs.

Raycast dbt Jobs

Raycast integration to monitor dbt Cloud Jobs.

Terraform provider for dbt Cloud

Manage dbt Cloud as infrastructure as code, now maintained by dbt Labs.

Packages

dbt-unirate

Currency exchange rate macros and models for dbt, powered by the UniRate API.

dbt_diving

A free to use dbt package with helper macros.

dbt-incremental-stream

A dbt package for Snowflake Streams.

dbt-reconfigured

A dbt package containing reconfigured macros.

dbt-census-utils

A collection of dbt macros for working with Census data.

dbt_tld

A self-updating dbt library that will maintain a list of current IANA/ICANN recognized top level domains.

dbt-translate

Translate numbers into words.

dbt_constraints

Generate database constraints based on the tests in a dbt project.

dbt-date

Date logic and calendar functionality.

dbt-fivetran-utils

General macros and helpers.

dbt-external-tables

Macros to stage your external sources.

dbt_audit_helper

Macros for data audits that compare columns values and schemas between tables.

dbt-profiler

Data profiling and doc block generator.

dbt_utils

General macros library. A must have.

Adapters

dbt-fabricspark

A code package from Microsoft for enabling dbt to work with Synapse Spark in Microsoft Fabric.

dbt-fabricsparknb

Generates Fabric Spark notebooks from dbt, by Insight; a fork of Microsoft's dbt-fabricspark.

dbt-timescaledb

The TimescaleDB adapter plugin for dbt.

dbt-fabric

A dbt adapter for working with Microsoft Fabric Data Warehouses.

dbt-excel

A dbt adapter for working with Excel.

Supported Adapters

Trusted and community adapters listed by dbt Labs.

Sample Projects

dbt-snowflake-template

Production-ready template deploying dbt project to Snowflake using GH Actions.

Part 1 Modelling on PostgreSQL

Part 2 ETL on PostgreSQL via Airflow

Part 3 Modelling on BigQuery

Part 4 ETL on BigQuery via Airflow

Part 5 Modelling on Amazon Athena

Part 6 ETL on Amazon Athena via Airflow

Make Open Data

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.

datafold-dbt-ci-advanced

Add 4 more integrations to your dbt CI pipeline: Slim CI, pre-commit hooks, Data Diffs, and Slack notifications.

NBA_Data_Modeling

Ingest, store, transform and serve insights from the official NBA API.

dbt-fake

Daily updated fake data for dbt learning and projects.

awesome-public-dbt-projects

A curated list of awesome public dbt projects.

mdsinabox

MDS in a box deployed anywhere.

gee_production_gatekeepers

A demonstration of production gatekeepers in Snowflake and BigQuery.

mdsfest-opensource-mds

Demo project for open source MDS.

f1-data-pipeline

F1 Data Pipeline.

transfermarkt-datasets

E2E dbt project for scraping and transforming football data from Transfermarkt.

In 2 lists

dbt_github_archive_bigquery

A dbt project for GitHub Archive data on BigQuery.

dbt_workspace

A workspace template for dbt demos.

Cloud Cost Monitoring

A dbt project to monitor cloud costs.

Part 1 – Redshift

Part 2 – Glue

Part 3 – EMR on EC2

Part 4 – EMR on EKS

Part 5 – Athena

Analytics Engineer Survey 2023

Repo containing data and dbt template of the survey.

Tracking the Fake GitHub Star Black Market with Dagster, dbt and BigQuery

Explore the topic of fake GitHub stars.

Data-aware orchestration

Dagster's ability to create a global dependency graph between different dbt projects.

AWS Athena x dbt

How to build a small and modern data infrastructure.

GitLab Data Team

GitLab's open source dbt project.

Link may be dead

attribution-playbook

A worked example to demonstrate how to model customer attribution.

mrr-playbook

A worked example to demonstrate how to model subscription revenue.

Use dbt inside Visual Studio Code development containers

Set up your dbt environment with pre-installed extensions.

dag-stack

Demo stack combining dbt, Airflow and Great Expectations.

Jaffle Shop

Sandbox project from dbt Labs, built around a fictional sandwich shop, for learning and testing.

airflow-dbt-demo

Demonstration of Airflow integration.

dbt-github-workflow

Deploy BigQuery + Airflow.

Spotify User Analytics

Sample dbt project with Spotify user data.

Community >Events & Talks

dbt Summit

Annual dbt Labs conference (formerly Coalesce), with keynotes and sessions on demand.

Data Council Austin 2023

A conference for data teams.

Data Council Austin 2022

Worldwide community driven analytics conference with a handful of talks fitting to the dbt stack.

Coalesce 2021

Second edition of the analytics engineering conference.

dbt meetups

List of community led dbt meetups.

Coalesce 2020

Annual dbt conference full of fascinating use-cases.

Community >Newsletters & Reports

#dbtips

Newsletter about dbt, with tips and tutorials on various topics.

Link may be dead

State of Analytics Engineering 2023

A survey of pains, gains, and areas of investment for global data teams.

Metadata Weekly

Weekly substack about metadata, the metrics layer and MDS.

Analytics Engineer Roundup

Official dbt Labs newsletter on topics of the MDS.

Benn Stancil's Newsletter

Thought-provoking reads from the founder of Mode.

Data Engineering Weekly

Weekly newsletter of recent trends in Data Engineering.

Community >Podcasts

Data Engineering Podcast

One of the most popular data engineering podcasts covering great concepts and new products.

In 5 listsDetails

The Analytics Engineering Podcast

Official podcast of dbt Labs.

Drill to Detail Podcast

Special guests discussing big data, business intelligence, modern data stack.

Community >Forums & Social

dbt Labs TikTok

Official TikTok channel of dbt Labs.

Locally Optimistic

A Slack community of aspiring analytics leaders discussing and sharing lessons learned and challenges from their experiences in using data.

DataTalks.Club

Global online community of data enthusiasts. Podcasts and blogs, etc. are distributed with high frequency.

In 2 lists

Automatically generate ERD

Automatically generate ERDs and display in your docs site.

dbt Slack

Energy-filled hub of analytics engineers (Highly recommended).

r/dataengineering

Subreddit of data engineering topics.

In 2 listsLink may be dead
See category
99

Awesome DeepSeek Harness (DSH) Plugin

awesome-dsh-plugin/awesome-dsh-plugin

A curated list of plugins for DeepSeek Harness (dsh) · DeepSeek Harness 插件精选列表

Fresh★ 25k1416 entriesPushed today
98

Awesome OpenClaw Skills

VoltAgent/awesome-openclaw-skills

The awesome collection of OpenClaw skills. 5,400+ skills filtered and categorized from the official OpenClaw Skills Registry.🦞

Fresh★ 54k843 entriesPushed 16 days ago
96

Awesome Prompts

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.

Fresh★ 9.3k365 entriesPushed today
96

Awesome Open Source Alternatives

piotrkulpinski/open-source-alternatives

Curated list of open source alternatives to proprietary software.

Fresh★ 6.9k860 entriesPushed today
95

Awesome README

matiassingers/awesome-readme

A curated list of awesome READMEs

Fresh★ 22k144 entriesPushed 5 days ago
94

Awesome Persona Distill Skills

xixu-me/awesome-persona-distill-skills

Curated list of Agent Skills centered on people, relationships, commemorative scenes, and methodological perspectives

Fresh★ 4.7k72 entriesPushed today