The problem I’m having In my current project requirement, we need to migrate stored procedure from sql server to snowflake. In sql server, we have used target table as base table in joining condition to perform update/delete/insert operations on target table.
The context of why I’m trying to do this To replicate same functionality in snowflake with dbt, I have to create target model which needs to create a table in snowflake by using incremental strategy
What I’ve already tried I have used ‘this’ key word to implement the same. Can someone please suggest me that ‘is there any other way to implement same functionality without using ‘this’ keyword in dbt?’
Some example code or error messages
Put code inside backticks
to preserve indentation
which is especially important
for Python and YAML!
It’s generally good practice to use the this keyword. While you can also use the {{ source() }} function, it’s not recommended if you need to refer to the same model within the model file.