How can we refer a variable defined in dbt_project.yml to a sql dbt model
vars:
schema_name: "PUB"
The dbt .sql model code in which i want to refer this variable is in quoted between asterick below:
{{
config(
database= 'RND',
schema= *schema_name*
)
}}
If you want to specify it one file at a time, you can do the following.
{{
config(
database= 'RND',
schema= var('schema_name')
)
}}