Top Rating
- Top Contributors
  Discover the Top Open Source contributors by country or by language
- Interviews
  Discover real stories from Open Source developers
Discover

Discover your Favorite Language
Discover the top trending repositories and projects on Github. Explore the latest trends in your preferred languages.

Perl

PHP

Clojure

Ruby

Lua

Emacs Lisp

Julia

Haskell

More Languages
Awesome

Awesome repositories
Discover the most awesome repositories and projects of your favorite languages. Inspired by the Awesome-* lists trend in GitHub.

Rust

Scala

F#

Ada

Nix

Swift

C#

Elm

More Languages
By Country

Rankings by Country
Discover the community of talented open source contributors in each country.

🇬🇦 Gabon

🇵🇲 Saint Pierre and Miquelon

🇦🇶 Antarctica

🇱🇰 Sri Lanka

🇹🇩 Chad

🇸🇽 Sint Maarten

🇬🇳 Guinea

🇿🇼 Zimbabwe

All Countries Compare Countries

dbt-labs/dbt-labs-experimental-features

Stars
139
Rank 262,954 (Top 6 %)
Language Makefile
License
Apache License 2.0
Created over 4 years ago
Updated 5 months ago

dbt-labs/dbt-labs-experimental-features

dbt-labs

There are no reviews yet. Be the first to send feedback to the community and the maintainers!

dbt support for database features which are not yet supported natively in dbt-core

dbt Labs: Experimental Features

This repository includes projects that extend of existing dbt features, experiment with new database features not yet natively supported in dbt, or otherwise demonstrate cool stuff you can do with just Jinja macros in your project—no forks necessary.

In all cases, these are demo projects, not intended as ready-to-use packages. If you want to use code from this repository in your own project, you're more than welcome to clone and install as a local package, or just copy-paste :)

BigQuery Incremental Strategies

These features shipped in dbt v0.16.0! See changelog and docs
The project here provided the substrate for a discourse post benchmarking different incremental strategies on BigQuery

Materialized views

This project adds support for materialized_view as a new dbt materialization. It includes implementations for Postgres, Redshift, Snowflake, and BigQuery, through a mix of new macros and overrides of built-in dbt macros. See the project README for details. For another take on dbt + materialized views, check out the dbt-materialize plugin.

Lambda views

This lab demonstrates a number of options for lambda views, as discussed in this discourse article. Additional details about the various approaches can be found in at lambda-views/README.md.

Snapshot testing

This lab demonstrates how to use snapshots to detect dbt model regressions, as discussed in this discourse article. Additional details on how to test this code for yourself can be found at snapshot-testing/README.md.

Dynamic data masking on Redshift

This lab demonstrates how to implement dynamic data masking on Redshift.

Check out this discourse article for more information.

Time on Task

This lab demonstrates two strategies for measuring Time on Task.

Check out this devhub article for more information.

Resources:

Learn more about dbt in the docs
Check out Discourse for commonly asked questions and answers
Join the chat on Slack for live discussions and support
Find dbt events near you
Check out the blog for the latest news on dbt's development and best practices

dbt-core

dbt enables data analysts and engineers to transform their data using the same practices that software engineers use to build applications.

dbt-utils

Utility functions for dbt projects.

metricflow

MetricFlow allows you to define, build, and maintain metrics in code.

dbt-codegen

Macros that generate dbt code

dbt-project-evaluator

This package contains macros and models to find DAG issues automatically

corp

Assets related to the operation of Fishtown Analytics.

dbt-spark

dbt-spark contains all of the code enabling dbt to work with Apache Spark and Databricks

dbt-external-tables

dbt macros to stage external sources

jaffle_shop

A self-contained dbt project for testing purposes

dbt-audit-helper

Useful macros when performing data audits

dbt_metrics

Macros for calculating metrics

dbt-snowflake

dbt-snowflake contains all of the code enabling dbt to work with Snowflake

dbt-bigquery

dbt-bigquery contains all of the code required to make dbt operate on a BigQuery database.

dbt-project-maturity

snowplow

Data models for snowplow analytics.

docs.getdbt.com

The code behind docs.getdbt.com

dbt-jsonschema

dbt-docs

Auto-generated data documentation site for dbt projects

dbt-meshify

A dbt-core python package that automates the management and creation of dbt groups, contracts, access, and versions.

jaffle_shop_duckdb

Get started with dbt in less than 1 minute from `git clone` to `dbt docs serve` for free!

dbt-event-logging

a dbt package to make auditing dbt runs easy.

dbt-server

A web API for dbt.

redshift

Redshift package for dbt (getdbt.com)

terraform-provider-dbtcloud

dbt Cloud Terraform Provider

jaffle-shop

🥪🦘 An open source sandbox project exploring dbt workflows via a fictional sandwich shop's data.

dbt-completion.bash

Adds autocompletion to the dbt CLI

dbt-redshift

dbt-redshift contains all of the code enabling dbt to work with Amazon Redshift

dbt-learn-group-training

The go to demo for public and private dbt Learn

mrr-playbook

segment

Data models for Segment built using dbt (getdbt.com).

dbt-semantic-interfaces

The shared semantic layer definitions that dbt-core and MetricFlow use.

dbt-sql-formatter

makes your sql less bad

dbt-init

A dbt-init script for consulting projects

jaffle-shop-template

Template for a DuckDB-based, Codespace-oriented sandbox project that is also dbt Cloud compatible, and includes code-first BI tooling via Evidence.

dbt-starter-project

Cloned by the `dbt init` task

dbt-learn-jinja

metrics-playbook

This repository contains files for the metrics framework playbook.

facebook-ads

dbt data models for facebook ads

dbt-presto

[ARCHIVED] The Presto adapter plugin for dbt Core

spark-utils

Utility functions for dbt projects running on Spark

stripe

semantic-layer-llm-benchmarking

dbt-technical-blog-writing

Conversation around dbt technical tutorials, blogs, guides, etc

attribution-playbook

dbt-databricks-demo

Demo project for dbt on Databricks

python-snowpark-formula1

dbtdocs-to-lookml

[WIP] A script to add descriptions from dbt schema files to your lookml project

tree-sitter-jinja2

jaffle_shop_metrics

This repository contains examples of how to use dbt's metric functionality on the jaffle shop dataset

quickbooks

dbt data models for Quickbooks Online.

hub.getdbt.com

Package hub for dbt.

dbt-jobs-as-code

Tools to handle dbt Jobs as well-defined YAML files

rapid-onboarding-exemplar

dbt Project for Rapid Onboarding instructors to use in instruction and learners to reference throughout the course.

dbt-extractor

airflow-fivetran-dbt

Example orchestration pipeline for Fivetran + dbt managed by Airflow

jaffle-sl-template

dbt-starburst-demo

dbt + Trino demo project, using TPC-H sample data

2023-04-18---zero-to-dbt

Welcome! This dbt project is built to be imported to a freshly-initialized dbt project to work through the hands-on zero to dbt lab detailed in this repo's readme.

adwords

dbt adwords models

atom-dbt

Atom highlighter for dbt projects

dbot

An LLM-powered chatbot with the added context of the dbt knowledge base.

dbt-adapter-tests

a pytest plugin for dbt adapter test suites

dbt-rpc

A server that can compile and run queries in the context of a dbt project. Additionally, it provides methods that can be used to list and terminate running processes.

dbt_faker

postgres

Postgres utility package for dbt (getdbt.com)

dbt-core-bundles

Generates bundles of verified adapters + core

dbt-database-adapter-scaffold

tap-framework

a framework for rapidly prototyping new singer taps

actions

Common GitHub actions and workflows for maintaining dbt

databricks_dbt_demo_project

dbt Cloud project for Databricks SQL Analytics Demos

salesforce

homebrew-dbt

🍻 Homebrew formulae for installing dbt on macOS

dbt-cloud-snowflake-demo-template

stitch-utils

Utility functions for Stitch-loaded data

dbt-common

dbt-styleguide

Styles for dbt on the net

terraform-aws-dbt-cloud-single-tenant

tap-s3-csv

Singer tap for getting CSV and XLS(X) data out of Amazon S3

analytics-engineering-survey

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

dbt-package-workshop

The companion repo to the 2022 Coalesce New Orleans Workshop - dbt Packages You Didn't Know You Needed

jaffle-shop-generator

hubcap

This app adds modules to the hubsite at hub.getdbt.com

dbt-python-hands-on-lab-snowpark

shopify-data-warehouse

ecommerce

python-string-parsing

Demo using dateutil library with pandas dataframes in Python

hologram

A library for automatically generating Draft 7 JSON Schemas from Python dataclasses

shopify

dbt data models for Shopify.

dbt-proserv

This is a public repository that the dbt proserv team uses for collective demos.

dbt-cloud-openapi-spec

new-python-wrench-demo

Demo of Python models to accompany the Snowflake blog post

Jupyter Notebook

dbt-integration-tests

jaffle_shop-dev

The dev version of jaffle shop

snowflake-resource-monitoring

log-tables-example

Example of log table creation using dbt.

tap-amazon-mws

Singer.io tap for Amazon MWS

snowflake_dbt_partner_demo

Coalesce2022-Training-Fundamentals

This is the repository for the Coalesce 2022 Fundamentals Live training

coalesce-2022-dag-workshop

Get more from your DAG! A Coalesce 2022 workshop that outlines how to use macros and DAG introspection to get more from your dbt project.

tap-amazon-advertising

Singer.io tap for Amazon Advertising