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.