Snowflake DB unable to recognize “OPTION (MAXRECURSION 1000)” used in a CTE Recursion Query

The Snowflake documentation is pretty clear that this is set at the account level, so you cannot adjust it in a query.

You can generate dates using other methods. For instance:

select dateadd(day, row_number() over (order by null),
               '2030-05-26')
              ) as date
from table (generator(rowcount => (10000)));

I don’t know what the right value of “10000” is for your purposes.