Did you know you can save values in variables in a Snowflake SQL worksheet and use them later in queries?
SQL
--Variabele
SET RelevanteMaand = 202301
;
--Variabele vervolgens gebruiken
SELECT
202301 AS YEAR
WHERE YEAR = $RelevanteMaand
;