Hi,
How can I pass multiple values in a project-level variable? I tried using the logic below, but it is throwing an error. Could you please assist me with this?
dbt_project.yml
vars:
country: ‘India’
country_code : (‘Ind’,‘USA’,‘UK’)
model -
{{
config(
materialized=‘table’,
alias= generate_alias_name(custom_alias_name='Test1234 '),
commission=0.10
)
}}
{% set commission=‘0.10’ %}
{% set COUNTRY=‘UK’ %}
select * from TRIPS.STAGING.STG_AGENTS where commission>=‘{{commission}}’
–AND (COUNTRY=‘{{COUNTRY}}’ or Country=‘{{ var(‘country’) }}’)
and country={{ var(‘country_code’) }}
error
SQL compilation error: error line 3 at position 11 Invalid argument types for function ‘=’: (VARCHAR(35), ROW(VARCHAR(3), VARCHAR(3), VARCHAR(2)))