Welcome to the dbt Labs demo dbt project! We use the TPCH dataset to create a sample project to emulate what a production project might look like!

                    _              __                   
   ____ ___  ____ _(_)___     ____/ /__  ____ ___  ____ 
  / __ `__ \/ __ `/ / __ \   / __  / _ \/ __ `__ \/ __ \
 / / / / / / /_/ / / / / /  / /_/ /  __/ / / / / / /_/ /
/_/ /_/ /_/\__,_/_/_/ /_/   \__,_/\___/_/ /_/ /_/\____/ 

Special demos

Cost Reporting in Snowflake:

Enable detailed reporting on credit utilization by user, logical environment, model. See macros/config/set_query_tag.sql for configuration to enable detailed tagging in your project.

Run dbt Cloud Jobs from Airflow

Trigger dbt Cloud jobs to run remotely via Apache Airflow. See instructions here for how to get started.

dbt-external-tables

Manage database objects that read data external to the warehouse within dbt. See models/demo_examples/external_sources.yml.

Snapshots

Create versioned datasets to track Type II changes. See snapshots/source_data__snapshot.sql and models/demo_examples/snapshots/source_data.sql for working code.