SleekData

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_lname VARCHAR( 50 ),     product_id INT

  Hello Data Pros, and welcome back to another exciting episode of our Snowflake learning series! In our last video, we explained what time travel is! and demonstrated how it works with appropriate examples! Today, we'll be exploring cloning; most widely known as zero-copy cloning within the Snowflake ecosystem! Let’s jump right in! ----------------------------------------------------------------------------------------------------------- --                                         SNOWFLAKE CLONING LAB                                         -- --               All commands/statements can be found via the link in the Video Description              -- ----------------------------------------------------------------------------------------------------------- -- Create a database & Schema CREATE DATABASE demo_db ; CREATE SCHEMA demo_db . demo_schema ; CREATE SCHEMA demo_db . another_demo_schema ; -- Switch to the newly created database and schema USE DATABASE demo_db ; USE

  Hello Data Pros, and welcome back to another exciting episode of our Snowflake learning series! In our last video, we explored various types of Snowflake views and their practical applications, demonstrated with easy-to-follow examples! Today, we're diving deeper into Snowflake's data protection features, specifically Time Travel and Fail-safe! ----------------------------------------------------------------------------------------------------------- --                                        SNOWFLAKE TIME TRAVEL LAB                                      -- --               All commands/statements can be found via the link in the Video Description              -- ----------------------------------------------------------------------------------------------------------- -- Create a database CREATE database demo_db ; -- Create a schema within the database CREATE SCHEMA demo_db . demo_schema ; -- Switch to the newly created database and schema USE DATABASE demo_db ; USE SC