# Having different value for 'THIS' variable when passing to macro using Post hook

**URL:** <https://discourse.getdbt.com/t/having-different-value-for-this-variable-when-passing-to-macro-using-post-hook/18534>\
**Category:** Help\
**Tags:** snowflake, macros, dbt-core\
**Created:** [March 7, 2025, 7:05am UTC](https://discourse.getdbt.com/t/having-different-value-for-this-variable-when-passing-to-macro-using-post-hook/18534 "2025-03-07T07:05:19Z")\
**Posts on this page:** 1\
**Page:** 1

<div class="post-metadata">

**Author:** ![Ayush](https://avatars.discourse-cdn.com/v4/letter/a/ebca7d/32.png) [@Ayush](https://discourse.getdbt.com/u/Ayush)\
**Post date:** [March 7, 2025, 7:05am UTC](https://discourse.getdbt.com/t/having-different-value-for-this-variable-when-passing-to-macro-using-post-hook/18534/1 "2025-03-07T07:05:19Z")

</div>

## The problem I’m having

Hi, I am having a question regarding the 'this ’ variable value actually when i passed the this variable to macro using post hook it is given different schema name which is mentioned in profiles.yml file but not to the mentioned in the dbt\_project.yml and if i used the {{this}} in the from clause it is giving the correct schema as per the dbt\_project.yml file.

## The context of why I’m trying to do this

I have created a macro for adding masking policy as post hook which will add the policy after the model is created as the model is materialized as table but when i am passing the this value in post hook macro and when i execute the macro it is taking wrong schema because of which the macro is failing so i want to know how i can point the ‘this’ variable value to schema mentioned in the dbt\_project.yml file not to the profiles.yml so that it won’t cause issue.

## What I’ve already tried

i have tried the below code but if i hard code and pass the schema name as four passing value it will work but with ‘this’ variable passing value won’t work. and i have tried passing this.schema, this.table also but the schema is giving wrong value

## Some example code or error messages

```auto
{{
config(
  materialized='table',
  post_hook=[
      "{{ apply_masking_policy(this, ['name', 'id'], 'masking_policy') }}"
    ]
)
}}

macro:
{% macro apply_masking_policy(model, columns, policy_name) %}
  {% set schema_name = model.schema %}
  {% set table_name = model.name %}
  
  -- Log the model details (schema and table name) for visibility
  {{ log("Model execution details -> Schema: " ~ schema_name ~ ", Table: " ~ table_name, info=True) }}
  
  {% set model_name = schema_name ~ "." ~ table_name %}
{% set statements = [] %}
{% for column in columns %}
  {% set stmt = "ALTER TABLE " ~ model_name ~ " MODIFY COLUMN " ~ column ~ " SET MASKING POLICY " ~ policy_name %}
  {% do statements.append(stmt) %}
{% endfor %}
{% set final_statements = statements|join('; ') %}
{% do log(final_statements, info=True) %}
{{ return(final_statements) }}
{% endmacro %}

output:
Model execution details -> Schema: BASE_SCHEMA, Table: table_test
ALTER TABLE BASE_SCHEMA.table_test MODIFY COLUMN name SET MASKING POLICY test_schema.MASK_TESTING;

correct output schema should be : Schema: DP_TEST which is being in the dbt_project.yml

and if use 'this' variable in the select query it is pointing to correct schema:
select
*
from {{ this }}
limit 100

output:
select
*
from test.dp_test.table_test
limit 100

```

Can anyone please help me on this what could be the reason for wrong schema assigned to ‘THIS’ Variable and is this the issue from dbt end itself?