SleekData

  Hello Data Pros, and welcome back to another exciting episode of our Snowflake learning series! In our previous video, we discussed various options for ingesting data into Snowflake, including Tasks, Snowpipe, Snowpipe Streaming, and the Snowflake Connector for Kafka. Today, we’re diving into the world of data transformations, with a special focus on Dynamic Tables. Let’s jump right in!   -----Follow the link in the description for the SQLs used in this lab ------ --------------------------------------------------------------------------- ---------------- Setting Up Foundational Objects for the Lab--------------- --------------------------------------------------------------------------- -- Create the database CREATE DATABASE IF NOT EXISTS my_database ; -- Use the created database USE DATABASE my_database ; -- Create the schema CREATE SCHEMA IF NOT EXISTS my_schema ; -- Use the created schema USE SCHEMA my_schema ; -- Create the 'customers' table CREATE TABLE ...

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...

  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              -- ----------------------------------------------------------...