Avoiding Create or Replace table SQL action using Full-refresh

In-Depth Discussions
1

Hello Folks,
I have question on dbt --full-refresh command. When dbt execute Full-Refresh it runs ‘CREATE OR REPLACE command’.
How to restrict the execution of the ‘CTAS’ SQL command. Instead dbt --full-refresh should execute only truncates and reload.

Please be noted there won’t be a change in structure
Thanks,
Madhavan

2

Hey @madhavan71,

Did you manage to resolve it? I am also seeing the same behaviour. If you’ve had any luck then please let me know.

Thanks,
Athar

3

make your model incremental and truncate with a pre hook.