The problem I’m having
dbt-snowflake adapter 1.7.0 & 1.8.4 have different behaviour for Dynamic Tables.
In 1.7.0, when running dbt run -s <dynamic-table>, it is trying to Applying REPLACE → DROP → CREATE;
While in 1.8.4, it uses the REPLACE macro correctly.
Can I ask why 1.7.0 is having this behaviour and in which part of the code the behaviour is determined by dbt?
Many thanks!
Some example code or error messages
02:26:32 SQL status: SUCCESS 1 in 0.0 seconds
02:26:32 Applying REPLACE to: "dynamic_testing_model"
02:26:32 Applying DROP to: "dynamic_testing_model"
02:26:32 Applying CREATE to: dynamic_testing_model
02:26:32 Writing runtime sql for node "model.dynamic_testing_model"
02:26:32 Using snowflake connection "model.dynamic_testing_model"
02:26:32 On model.edr.in_recharge_test: /* {"app": "dbt", "dbt_version": "1.7.19", "profile_name": "edr", "target_name": "dev", "node_id": "model.dynamic_testing_model"} */