Generate dates within a range in Snowflake

Question

I have a table in postgres one of the columns is year which is calculated as :

date_part('year',current_date) + generate_series(-2,4)

so if I take today's date , the output will be :

How to achieve the above in snowflake environment.

Thanks in advance

user_5070879 · Answer

Using GENERATOR and DATEADD:

SELECT DATEADD(year, (ROW_NUMBER() OVER(ORDER BY seq8())-3, current_date) AS y,
FROM TABLE(GENERATOR(ROWCOUNT => 7));

And year only:

SELECT YEAR(CURRENT_DATE) + (ROW_NUMBER() OVER(ORDER BY seq8())-3 AS y,
FROM TABLE(GENERATOR(ROWCOUNT => 7));

user_14442664 · Answer

Below snowflake community article will give more in depth info about using functions like SEQ1(),SEQ2(),SEQ4(),SEQ8() and generator functions.