Using a macro argument in a post_hook

Help
, , , ,
1

Hi there!

I’m trying to run a macro using dynamic argument and then use this argument in a post_hook to that same process, and insert the argument into a different table. Something like this:

–my_macro.sql
{% macro abc(x) %}

some code...

{% end macro %}

– my_process.sql

{{ config
(post_hook= “insert into my_table
(select {{x}} from {{ this }}”)
)
}}

my_macro(5)

What I want is to insert 5 into my_table.
It doesnt work. What am I missing working with arguments? Is there any other way to use a macro argument?
Thanks!