good first issue
Métricas do repositório
- Stars
- (0 stars)
- Métricas de merge de PR
- (Métricas PR pendentes)
Description
Scope
Merge PR #4, which introduces:
- go_stores.csv
A complete stores pipeline:
- models/01_raw/t_raw_stores.sql
- models/02_stg/t_stg_stores.sql
- models/03_det/t_dim_stores.sql (SCD2)
Run the pipeline:
dbt run -s +t_dim_stores
Working blueprint for building SCD2 dimensions in dbt (DuckDB): hash-based change detection, versioning, current row flag, and prior_dim_store_sk.
Use this to build t_dim_products as a scd2 table.
Test SCD2 functionality
Manually update dimension attributes in dbeaver example:
update dev.stg.t_stg_stores
set manager_name = 'Erik ten Hag'
where store_code = 'GO002'
In dbt re-run only dimension:
dbt run -s t_dim_stores