Welcome to my dbt test projects on a local PostgreSQL DB, Snowflake and BigQuery

• default master branch is for local tests on PostgreSQL with dbt tutorial tables (Customers, Orders and Payments). CSV source files for these tables are in data directory.
• snowflake branch is for simple tests from dbt Cloud on Snowflake databases.
• bigquery branch is for the tutorial project from dbt Cloud on BigQuery with the jaffle_shop customers model.

Using these starter projects

For the local project (master branch):

• Create your local db profile on your local PostgreSQL (example in postgres_profile.yml) and copy it in your local ~/.dbt/ directory.
• Upload samples data with dbt seed command.

Then try running the following commands:

• dbt debug
• dbt list
• dbt test
• dbt run
• dbt compile
• dbt snapshot
• dbt docs generate

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