Awesome Public dbt Projects 🌟

A curated list of awesome public dbt projects that the community can learn from. If you have a dbt project or know of one that should be included, please submit a pull request!

Table of Contents

• Introduction
• Projects
• Contribution Guidelines
• License

Introduction

dbt enables data analysts and engineers to transform their data using the same practices that software engineers use to build applications. This repository aims to gather public dbt projects that can serve as references, inspirations, or learning materials for the community.

Projects

• Jaffle Shop - The canonical dbt sample project. (with semantic layer.
• Spellbook - Blockchain data analytics.
• Filecoin Data - Filecoin data portal.
• CountMoney - Finance data pipeline orchestration.
• Danish Parliament Data - Danish Parliament data from Folketinget API.
• Taiwan Campaign Finance - Campaign finance analytics with duckdb and Mosaic Vgplot.
• Bird Data - Bird Data with Dagster, Evidence and duckdb.
• Datadex - Generic local friendly dbt project optimized for open data.
• NBA Data - Monte Carlo simulation of the NBA season, with meltano, duckdb and superset.
• GitLab Data Team - Gitlab data by the GitLab data team.
• SOMA - Standard Operating Metrics & Analytics - for b2b SaaS.
• Mattermost - Mattermost's data warehouse project.
• Flipside - SQL Tables/Views for Flipside Crypto.
• Twitter Trending - A small example visualizing live Twitter trending data using Redpanda and Materialize.
• Fake Star Detector for GitHub - Dagster project for analyzing fake stars on any GitHub repository.
• ngods stock market demo - stock market analysis demo with Iceberg, dbt, cube, metabase
• dbt_datawaves_wallet_labels - Ethereum Wallet labels built using dbt.
• Cal-ITP - California Integrated Travel Project.
• CalData - CalData's data infrastructure.
• Dagster Open Platform - Dagster Lab's open-source data platform.

Contribution Guidelines

1. Fork the repository on GitHub.
2. Clone the forked repository to your local machine.
3. Commit your changes to your own branch.
4. Push your work back up to your fork.
5. Submit a Pull request so that we can review your changes.

NOTE: Be sure to merge the latest from "upstream" before making a pull request!

License

CC0