SF#4 Snowflake ❄️ - Create a Simple tree of TASKS - Tamil Cloudguy - தமிழ்
SF#4 Snowflake - Create a Simple tree of TASKS - Tamil Cloudguy - தமிழ்
Chapters for this video:
00:04 - Introduction
01:09 - Create a parent task using Snowflake WebUI
01:51 - Create a child task using Snowflake WebUI
07:58 - What will happen to an Orphan child task after dropping parent task
09:50 - COVID Vaccination awareness request by Tamilnadu CM Stalin
Snowflake is the only data platform built for the cloud for all your data and all your users. Mobilize your data to advance your business.
Introduction to Tasks:
----------------------------------------
Currently, a task can execute a single SQL statement, including a call to a stored procedure.
Tasks can be combined with table streams for continuous ELT workflows to process recently changed table rows. Streams ensure exactly once semantics for new or changed data in a table. Tasks can also be used independently to generate periodic reports by inserting or merging rows into a report table or perform other periodic work.
Statement:
--The ability to execute tasks requires that the task owner role (the role with the OWNERSHIP privilege on the task)
grant OWNERSHIP on TASK mytask_minute to role accountadmin;
grant OWNERSHIP on TASK mytask_hour to role accountadmin;
--Has the account-level EXECUTE TASK privilege.
--Revoking the EXECUTE TASK privilege on a role prevents all subsequent task runs from starting under that role.
grant EXECUTE TASK on account XXXXX to role accountadmin;
Reference data:
https://roboquery.com/app/syntax-alte...
https://docs.snowflake.com/en/sql-ref...
https://community.snowflake.com/s/que...
https://docs.snowflake.com/en/sql-ref...
Reference UR: https://pypi.org/project/qrcode/
Tamil Cloudguy Python GitHub: https://github.com/shenbagasundar/Pyt...
Download Python: https://www.python.org/downloads/
Download Visual Studio code IDE: https://code.visualstudio.com/
Thanks and Regards,
Shenbaga Sundar - Tamil Cloudguy
Whatsapp chat group: https://chat.whatsapp.com/GhC0hAKNHsw...
Copyright © 2021 Tamil Cloudguy. All rights reserved.
Contacts:
Email ID: [email protected]
Whatsapp chat group : https://chat.whatsapp.com/GhC0hAKNHsw...
Tamil Cloudguy Facebook : / tamilcloudguy
Tamil Cloudguy LinkedIn : / shenbagasundar
Tamil Cloudguy GitHub : https://github.com/shenbagasundar/
Tamil Cloudguy Youtube : / tamilcloudguy
Tamil Cloudguy G-drive : https://drive.google.com/open?id=1fuW...
#தமிழ் #Snowflake #Tree_of_TASKs