# this keyword in incremental strategy

**URL:** https://discourse.getdbt.com/t/this-keyword-in-incremental-strategy/16649
**Category:** Help
**Tags:** incremental, snowflake, dbt-cloud
**Created:** [October 19, 2024, 8:09am UTC](https://discourse.getdbt.com/t/this-keyword-in-incremental-strategy/16649 "2024-10-19T08:09:46Z")
**Posts on this page:** 2
**Page:** 1

<div class="post-metadata">

### Author: ![harika.lekkala](https://sea2.discourse-cdn.com/flex020/user_avatar/discourse.getdbt.com/harika.lekkala/32/4574_2.png) [@harika.lekkala](https://discourse.getdbt.com/u/harika.lekkala)
#### Post date: [October 19, 2024, 8:09am UTC](https://discourse.getdbt.com/t/this-keyword-in-incremental-strategy/16649/1 "2024-10-19T08:09:46Z")

</div>

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

```auto
Put code inside backticks
  to preserve indentation
    which is especially important 
      for Python and YAML! 

```

---

<div class="post-metadata">

### Author: ![Surya](https://sea2.discourse-cdn.com/flex020/user_avatar/discourse.getdbt.com/surya/32/3763_2.png) [@Surya](https://discourse.getdbt.com/u/Surya)
#### Post date: [November 1, 2024, 7:59am UTC](https://discourse.getdbt.com/t/this-keyword-in-incremental-strategy/16649/2 "2024-11-01T07:59:26Z")

</div>

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.
