Tasks & Transactions: Snowflake SnowPro Core Certification

Seventeenth Chapter: Tasks & Transactions in Snowflake

Gonzalo Fernandez Plaza
6 min readNov 9, 2021
Tasks & Transactions in Snowflake
Tasks & Transactions in Snowflake

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!

  1. Introduction to tasks
  2. Tree of tasks
  3. Task History
  4. Serverless Tasks
  5. Transactions
  6. Typical Exam Questions

Remember that all the chapters from the course can be found in the following link:


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



Gonzalo Fernandez Plaza

Computer Science Engineer & Tech Lead 🖥️. Publishing AWS & Snowflake ❄️ courses & exams. https://www.fullcertified.com