Hello! I’m confused about the usage of dbt in this scenario. I need to extract data from a transactional data source and model it in a star schema for inclusion in a data warehouse. My question is, is the only way to update this table by using incremental loading with dbt? I see many people using a full refresh strategy, but if I do a full refresh, I lose my historical data or dbt saves it in a temp table and load it again?
Related Topics
| Topic | Replies | Views | Activity | |
|---|---|---|---|---|
| Need help with the Incremental | 1 | 527 | December 18, 2023 | |
| Auto refreshing models for incremental models with Schema changes | 3 | 5884 | September 23, 2022 | |
| Handling BigQuery Incremental __dbt_tmp tables | 2 | 3494 | March 29, 2023 | |
| incremental tables with slowly changing data | 3 | 1370 | June 19, 2023 | |
| snapshots and incremental models implementation in dbt with Bigquery | 2 | 942 | February 13, 2023 |