I have a dbt project and I'm using ad_reporting model. all the sources are working good, except than google_ads. and that's because I don't have google_ads schema, instead I have google_ads_us schema. I tried to change it in main dbt_project.yml file:

vars:     google_ads_schema: google_ads_us 

but still when I'm running this command:

dbt run --select ad_reporting 

I keep get this error:

Database Error in model stg_google_ads (models\stg_google_ads.sql) SQL compilation error: Object 'DATABASE.HISTORY_GOOGLE_ADS.GOOGLE_ADS__URL_AD_ADAPTER' does not exist or not  authorized. compiled SQL at target\run\ad_reporting\models\stg_google_ads.sql 

the HISTORY_ prefix is from profiles.yml file (SCHEMA).

Anyone know where else I need to change the schema?