# dbt-snowflake adapter 1.7.0 & 1.8.4 have different macro behaviour for Dynamic Tables.

**URL:** <https://discourse.getdbt.com/t/dbt-snowflake-adapter-1-7-0-1-8-4-have-different-macro-behaviour-for-dynamic-tables/19027>\
**Category:** Help\
**Tags:** snowflake, macros, dbt-core\
**Created:** [April 15, 2025, 3:31am UTC](https://discourse.getdbt.com/t/dbt-snowflake-adapter-1-7-0-1-8-4-have-different-macro-behaviour-for-dynamic-tables/19027 "2025-04-15T03:31:28Z")\
**Posts on this page:** 1\
**Page:** 1

<div class="post-metadata">

**Author:** ![JJJJJ](https://avatars.discourse-cdn.com/v4/letter/j/71e660/32.png) [@JJJJJ](https://discourse.getdbt.com/u/JJJJJ)\
**Post date:** [April 15, 2025, 3:31am UTC](https://discourse.getdbt.com/t/dbt-snowflake-adapter-1-7-0-1-8-4-have-different-macro-behaviour-for-dynamic-tables/19027/1 "2025-04-15T03:31:28Z")

</div>

## 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

```auto
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"} */

```