SNOWFLAKE STAGES HANDS-ON -- DATA LOADING AND UNLOADING LAB
---------------------------------------------------------------------------------- -- SNOWFLAKE STAGES HANDS-ON -- DATA LOADING AND UNLOADING LAB -- ---------------------------------------------------------------------------- --- ---> set the Role use role ACCOUNTADMIN ; ---> set the Warehouse use warehouse COMPUTE_WH ; ---> create Database and Schemas create database SLEEK_OMS ; create schema L1_LANDING ; ---> Use Database and Schemas use database SLEEK_OMS ; use schema L1_LANDING ; ---> Create Tables create table if not exists DATES_DIM ( date date , day varchar ( 3 ), month varchar ( 10 ), year varchar ( 4 ), quarter int null , dayofweek varchar ( 10 ), weekofyear int ); create table if not exists CUSTOMERS_DIM ( customerid varchar ( 10 ), firstname varchar ( 50 ), lastname varchar ( 50 ), email varchar ( 100 ), phone varchar ( 100 ), address varchar ( 100 ), city varchar ( 50 ), state varchar ( 2 ), zipco