Unfortunately snowflake doesn't have a generate_series function equivalent. The closest thing it has is a generator function which only accepts constants: https://docs.snowflake.com/en/sql-reference/functions/genera...

I could probably have written my own javascript udf equivalent of generate_series though.