Passing project variable as argument for macro

Help
,
1

The problem I’m having

Hi,
I am trying to run a macro by passing the parameter as run time.
Can I refer project variables as parameter

What I’ve already tried

dbt run-operation stream_creation_vault_test --args ‘{ “tbl_nm”: {{var(“LOAD_OFFER”)}} , “initial_rows”: false}’

Some example code or error messages

Error: Invalid value for ‘–args’: String ‘{ “tbl_nm”: {{var(“LOAD_OFFER”)}} , “initial_rows”: false}’ is not valid YAML

2

Hi @akanksha,

You can use your variable directly into the macro, and avoid passing it as an option in the CLI. Does this make sense in your case?