Tasks & Transactions: Snowflake SnowPro Core Certification

Seventeenth Chapter: 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:

Road to SnowFlake SnowPro Core Certification: Complete Course

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…