Hi @Daniel_dlh,

I had recently responded to a similar query on this topic. You may want to check this. 

At a high level, you’re combining two separate mechanisms. 

Bundle variables (variables: + ${var.name}) are resolved only in the bundle config (YAML/Python) at deploy/validate time.

SQL task parameters (sql_task.parameters used as {{param}} in SQL) are what actually get substituted inside the .sql file at run time.

So {{ catalog }} in the SQL file will only be replaced if catalog is defined under sql_task.parameters.

Does this help?

If this answer resolves your question, could you mark it as “Accept as Solution”? That helps other users quickly find the correct fix.