Can you describe the data transformations you performed in your last project, specifically using dbt?

In my last project I used dbt to orchestrate all SQL‑based transformations in Snowflake. I defined models for raw, intermediate, and final tables, using dbt's incremental materialization for large fact tables. I wrote tests to enforce non‑null constraints and uniqueness on primary keys, and used dbt docs to auto‑generate lineage diagrams. For example, I built an incremental model for sales that only processed new rows based on a transaction timestamp. I also leveraged dbt's hooks to run custom SQL before and after each run, ensuring data quality. The result was a reproducible, version‑controlled pipeline that reduced deployment time from days to minutes.