How to pass Date Variable as string while running the DBT Jobs

[sargunan]

Hey Everyone.

I have dbt Jobs which is having an Variable (String) which has the Date. Everytime we run the job either we modify the date or update in project YML File. Since we have completed the history load now we would need to automate this by passing the Curernt date -1 and covert into string. Example we expect “2023-08-01”.

Example
dbt build --vars ‘{key: value, thru_date: 2023-08-04}’ --select ++

This thru_date Variables we have been using in Modes to filter the data set in source. Now how we convert the Hardcode values to Dymically with sysdate-1 ?

[lennart]

is it possible for you to use a macro instead of a variable? e.g. using this:

Accessing a dynamically-set variable in multiple models

I know I can execute a query in a model and assign the result to a variable in this way: {% if execute %} {% set last_audit_id = run_query("SELECT LAST_AUDIT_ID FROM CFG.PAR_SCDM_AUDIT WHERE FLOW = ‘ORDER_MOVEMENT’ ").columns[0][0] %} {% endif %} but this variable is local to this model. Is there a way to do the same thing in dbt_project.yml and thus feed a project-wide variable? Thanks Daniele