View Code? Open in Web Editor
NEW
This project forked from lindsaymurphy4/course_advanced_dbt
This is the repository for Bingeflix dbt Project (Uplimit Advanced dbt course)
Home Page: https://uplimit.com/course/advanced-dbt
course_advanced_dbt's Introduction
Welcome to the Bingeflix Data Team
- Use UPPER case for all keywords
- Use trailing commas in SELECT statements
- Use Snowflake dialect
- Use consistent style in GROUP BY and ORDER BY (either names or numbers, not both)
- The primary key source column must have not_null and unique generic tests.
- All boolean columns must have an accepted_values schema test. The accepted values are true and false.
- Columns that contain category values must have an accepted_values schema test.
- Columns that should never be null must have a not_null schema test.
- Columns that should be unique must have a unique schema test.
- The primary key column must have not_null and unique schema tests.
- All boolean columns must have an accepted_values schema test. The accepted values are true and false.
- Columns that contain category values must have an accepted_values schema test.
- Columns that should never be null must have a not_null schema test.
- Columns that should be unique must have a unique schema test.
- Where possible, use schema tests from the dbt_utils or dbt_expectations packages to perform extra verification.
course_advanced_dbt's People
Contributors