Generate Series Of Dates In Snowflake

Generate Series Of Dates In Snowflake | Data Sources | Sisense Community

As Snowflake doesn't have a native generate_series function, here is our solution to generating a table of incrementing dates, starting from the current date, in Snowflake. It is currently set to generate 1095 rows (3 years) of dates.

<span>select
</span><span>  dateadd(day, '-' || seq4(), current_date()) as dte
</span><span>from
</span><span>  table
</span><span>    (generator(rowcount => 1095))</span>

Was this article helpful?

Community_Admin

Posted 4 years ago

0 comments