# Possible to create multiple session variables (Snowflake)?

**URL:** <https://discourse.getdbt.com/t/possible-to-create-multiple-session-variables-snowflake/4503>\
**Category:** Archive\
**Created:** [June 17, 2022, 9:21pm UTC](https://discourse.getdbt.com/t/possible-to-create-multiple-session-variables-snowflake/4503 "2022-06-17T21:21:41Z")\
**Posts on this page:** 2\
**Page:** 1

<div class="post-metadata">

**Author:** ![ptrn](https://avatars.discourse-cdn.com/v4/letter/p/f17d59/32.png) [@ptrn](https://discourse.getdbt.com/u/ptrn)\
**Post date:** [June 17, 2022, 9:21pm UTC](https://discourse.getdbt.com/t/possible-to-create-multiple-session-variables-snowflake/4503/1 "2022-06-17T21:21:41Z")

</div>

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

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

```auto
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)?

---

<div class="post-metadata">

**Author:** ![ptrn](https://avatars.discourse-cdn.com/v4/letter/p/f17d59/32.png) [@ptrn](https://discourse.getdbt.com/u/ptrn)\
**Post date:** [June 17, 2022, 9:53pm UTC](https://discourse.getdbt.com/t/possible-to-create-multiple-session-variables-snowflake/4503/2 "2022-06-17T21:53:08Z")

</div>

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.