I'm trying to do a full historical load, including transformations, from one table in Snowflake to another. I expect it it to take over an hour.
I would like to schedule this load and have it run overnight so that I don't have to stay connected to the network or risk a connection issue.

I tried to use a scheduled task to do this.

Problem: There is a 60 minute limit. You can make it shorter (STATEMENT\_TIMEOUT\_IN\_SECONDS = 60), but you can’t make it longer it appears. <https://docs.snowflake.net/manuals/user-guide/tasks-ts.html#task-timed-out-or-exceeded-the-schedule-window>

Anyone else experience this and have a suggestion?