When you sets up a new automation, Snowflake first asks you to select a trigger type, one of which is time trigger.

Use time trigger if you wish to have your automations executed at some points of time in the future. There are two types of time trigger - once-off time trigger and recurring time trigger.

Once-off Time Trigger

Execute the automation at a point of time in the future. With this trigger, the automation will only run once.

Recurring Time Trigger

Define a recurring schedule, for instance, run every month on the 15th at 10AM. You can also specify how many times the automation will be executed (or use forever). As soon as you save the automation, Snowflake will calculate the next execution time based on the defined schedule and your timezone.

Did this answer your question?