How do I set a variable (usedate) in project.yml using SQL? I need that variable to be the last day of the month based on the system date.
When dbt run is executed, the default will be what is in project.yml. If the var needs to be another date, then it would need to be set at dbt run command.
model code snippet:
dbt run error: ( not using --vars)