Tasks are an excellent scheduling tool in Snowflake.
You can use tasks for a lot of different purposes. Below are some examples:
- Call a stored procedure. You could use this stored procedure perform full load of a table (truncate a table and insert new data from a stage, for example).
- Single SQL statements. These can be anything. An example would be using a merge statement to update your (SCDII) dimension.
- Etc.
The scheduling can be done using CRON (for example, run a task every hour, minimum schedule is one minute) or using a trigger. You could trigger a task to run after another task is done, thus creating a chain of tasks.