Snowflake Tasks | Types | Examples | snowflake tasks and streams
Hello Data Pros, and welcome back to another exciting episode of our Snowflake learning series! In our previous video, we’ve covered Snowflake Streams; and demonstrated their role in change data capture. Today, we will explore Snowflake Tasks, which are essential for automating a variety of data processes within Snowflake. ------------------- Follow the link in the description for the SQLs used in this lab ------------------- --------------------------------------------------------------------------- ---------------- Setting Up Foundational Objects for the Lab--------------- --------------------------------------------------------------------------- --Create Database and Schema CREATE OR REPLACE DATABASE order_db ; CREATE OR REPLACE SCHEMA order_db . order_schema ; -- Create Tables USE SCHEMA order_db . order_schema ; CREATE or replace TABLE order_raw ( order_id INT , order_date DATE , cust_fname VARCHAR( 50 ), cust_lna...