Snowflake Task - Ownership Vs Execute Privilege - Hands on | Rajiv Gupta Learn Everyday
Rajiv Gupta - Everyday Learning
0:00 / 0:00
Snowflake Task - Ownership Vs Execute Privilege - Hands on | Rajiv Gupta Learn Everyday
2 047 просмотров · 5 л. назад
Rajiv Gupta - Everyday Learning
3,38 тыс. подписчиков
2 047 просмотров · 5 л. назад
Snowflake task in simple term is scheduler which can help you to schedule a single SQL or a stored procedure.
Task can be very useful when combined with streams to make an end to end data pipeline. The Snowflake task engine has a CRON and NON CRON variant scheduling mechanisms. The CRON variant should look familiar syntactically if you are a Linux guy.
Snowflake ensures only one instance of a task with a schedule (i.e. a standalone task or the root task in a tree of tasks) is executed at a given time. If a task is still running when the next scheduled execution time occurs, then that scheduled time is skipped.
To get timely notification and to enjoy all cool demo & technical details. Please follow me on → / rajivgupta780184 & subscribe to my YouTube Channel → / rajivguptaeverydaylearning
Blog: / getting-started-with-snowflake-tasks