week2.md

Task 1: Add SQLFluff to pre-commit hook

• set up pre commit initially and fixed all the issues. Commit.
• Testing pre commit hook with sqlfluff.

Task 2: Add dbt-checkpoint pre-commit hook

• Changes associated with the dbt-checkpoint pre commit hook are in this commit.
  • The dbt-checkpoint pre commit hook made us aware that the descriptions of 2 columns in the dim_users model was missing and we needed to add them before pushing the changes.
• Testing Tags on models present in the core folder. Commit.

Task 3: Generalize a custom macro

• Updated the rolling_aggregation_n_periods macro. https://github.com/MSDarshan91/course_advanced_dbt/blob/main/macros/rolling_aggregation_n_periods.sql
• Used the macro in fct_subscription_plans_monthly_report model https://github.com/MSDarshan91/course_advanced_dbt/blob/main/models/marts/product/fct_subscription_plans_monthly_report.sql

Task 4: Write a custom macro to improve another part of the codebase

• Added a new truncate_to_month macro https://github.com/MSDarshan91/course_advanced_dbt/blob/main/macros/truncate_to_month.sql
• Used the macro in fct_mrr model https://github.com/MSDarshan91/course_advanced_dbt/blob/main/models/marts/finance/fct_mrr.sql