SleekData

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

  Provider: ----------------------------------------------------------------------------------------------------------- --                                    SOWFLAKE SECURE DATA SHARING LAB                                   -- --               All commands/statements can be found via the link in the Video Description              -- ----------------------------------------------------------------------------------------------------------- -- Create a database & Schema CREATE DATABASE product_db ; CREATE SCHEMA product_db . core_schema ; -- Create a database & Schema CREATE OR REPLACE DATABASE product_db ; CREATE OR REPLACE SCHEMA product_db . core_schema ; -- Switch to the newly created database and schema USE DATABASE ...

PRIMARY ----------------------------------------------------------------------------------------------------------- --               All commands/statements can be found via the link in the Video Description              -- ----------------------------------------------------------------------------------------------------------- -- Create Database & Schema USE ROLE accountadmin ; CREATE DATABASE employee_db ; use employee_db ; CREATE SCHEMA employee_schema ; -- Create Tables CREATE TABLE employee_schema . employee (     employee_id INT PRIMARY KEY ,     first_name VARCHAR ( 50 ),     last_name VARCHAR ( 50 ),     email VARCHAR ( 100 ) ); CREATE TABLE employee_schema . employee_salary (     employee_id INT PRIMARY KEY ,     basic DECIMAL ( 10 , 2 ),     allowances DECIMAL ( 10 , 2 ),     deductions DECIMAL ( 10...