Tasks & Transactions: Snowflake SnowPro Core Certification
Seventeenth Chapter: Tasks & Transactions in Snowflake
6 min readNov 9, 2021
We are coming to the end of the Snowflake SnowPro Core course, but we can’t forget about Tasks and Transactions in Snowflake, which will allow us to extend the functionality of our favorite Cloud Data Warehouse. Let’s get to it!
Remember that all the chapters from the course can be found in the following link:
INTRODUCTION TO TASKS
Snowflake tasks are schedulable scripts that are run inside your Snowflake environment. No event source can trigger a task; instead, a task runs on a schedule, which can be defined when creating a task, and they run with the privileges of the task owner. A task can execute a single SQL statement, including a call to a Stored…
