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),
              ) as date
from table (generator(rowcount => (10000)));

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

CLICK HERE to find out more related problems solutions.

Leave a Comment

Your email address will not be published.

Scroll to Top