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