Possible to create multiple session variables (Snowflake)?

Archive
1

We’re looking to migrate from traditional SQL transformation scripts to dbt.

Right now, the beginning of every transformation looks something like this:

ALTER SESSION SET QUERY_TAG = 'description of transformation that follows our convention';

SET TOMORROW = DATEADD(DAY, 1, CURRENT_DATE)::DATE;
SET CURRENT_DATETIME_PACIFIC =  CONVERT_TIMEZONE('America/Los_Angeles', CURRENT_TIMESTAMP);
SET DATETIME_LATEST_RUN = (SELECT ...);

I’ve seen that I can put one item in “sql_header”, and that I can declare project-wide variables.

I’d probably put the TOMORROW variable somewhere central and perhaps others, but, with Snowflake:

  1. is it possible to declare more than one model-specific variable?
  2. is it possible to use a variable in the calculation of another in dbt_project.yml
  3. is it possible to make a variable dynamic in dbt_project.yml (ideally, using SQL)?
2

Never mind on #1. When reading the docs on the subject, I figured I could not include a ; character, since that doesn’t seem to be allowed in most places in dbt.

Just declaring my variables as usual (by separating each statement with ; did the trick just fine.

Would still love thoughts on #2 and #3.