dbt transformation project for Snowflake data warehouse. Performs basic transformations for staged snowflake data tables containing covid19 data.
Overview info: Modern Data Integration Stack with Airbyte, Snowflake, and Data Build Tools
dbt Test info: A Beginner Guide to dbt Tests
SQL linter sqlfluff is used to check readability of the SQL scripts.
pip install sqlfluff
sqlfluff lint models.sql
More info: https://docs.sqlfluff.com/en/stable/configuration.html?highlight=dbt#dbt-project-configuration