Hi Team,
Is there any way we can use variable which value through set function can be used in config pre_hook or post_hook section ?
eg:
{%- set empDelId = get_emp_id_to_delete() %}
{{
config(materialized = ‘incremental’,
pre_hook = [ " DELETE FROM {{ source(‘myWIsource’, ‘Employees’) }} where employee_di = empDelId"
]
}}