Thank you @jerco for the concise explanation. It looks like I will be switching some models to insert_overwrite.
Related topics
| Topic | Replies | Views | Activity | |
|---|---|---|---|---|
| DBT BigQuery Scanning Entire table in merge | 1 | 1880 | May 10, 2023 | |
| dbt incremental model on BQ Partitioned table | 1 | 3507 | July 27, 2023 | |
| Handling BigQuery Incremental __dbt_tmp tables | 2 | 5742 | March 29, 2023 | |
| DBT BigQuery table creation code generation issue | 7 | 2381 | April 1, 2023 | |
| Test only new data in incremental models | 5 | 2823 | September 11, 2023 |