From the course: Introduction to Modern Data Engineering with Snowflake

Unlock this course with a free trial

Join today to access over 24,400 courses taught by industry experts.

Automation with tasks

Automation with tasks - Snowflake Tutorial

From the course: Introduction to Modern Data Engineering with Snowflake

Start my 1-month free trial Buy for my team

Automation with tasks

“

Tasks are the primary object in Snowflake that you'll use for automation. A task is essentially a scheduled operation. Tasks can be used to execute SQL statements, stored procedures, queries, and more. There are two types of tasks in Snowflake: user-managed tasks and serverless tasks. In this video, I'll cover the former, user-managed tasks. But because it's so easy to go from one type of task to the other, you'll also get some exposure to serverless tasks. The key difference between these two types of tasks is the management of the compute resources needed to run the task. With a user-managed task, a user in Snowflake assigns a compute resource to a task and continuously manages it. With a serverless task, Snowflake does the heavy lifting. Snowflake will rightsize the compute resources for you so that you don't have to worry about managing a virtual warehouse. And all it takes to go from one type of task to the other is a one-line code change. I'll show this shortly. You'll specify…

Contents