SleekData

############  seeds\salestargets.csv  ############  StoreID,SalesTarget 1876,260000 1396,290000 1146,305000 1107,345000 1384,350000 1155,300000 1913,300000 1882,345000 1289,300000 1005,375000 ############  models\storeperformance.sql  ###########  SELECT     OS . StoreID ,     SUM ( OFACT . Revenue ) AS ActualSales ,     SUM ( ST . SalesTarget ) AS TargetSales FROM     {{ ref ('orders_stg') }} OS JOIN     {{ ref ('orders_fact') }} OFACT ON OS . OrderID = OFACT . OrderID JOIN     {{ ref (' salestargets ') }} ST ON ST . StoreID = OS . StoreID GROUP BY 1 ############   analyses\StoreRevenue.sql  ############  SELECT     OS . StoreID ,     SUM ( OFACT . Revenue ) AS TotalRevenue FROM     {{ ref ('orders_stg') }} OS JOIN     {{ ref ('orders_fact') }} OFACT ON OS . OrderID = OFACT . OrderID GROUP BY 1 ############   models\ src_oms.yml  ############  sources :   - name : landing     description : The primary soruce system for order mana

------------------------------------------------------------------------------------------------------- --SNOWFLAKE TABLES HANDS-ON LAB  (ALL COMMANDS ARE AVAILABLE IN THE LINK PROVIDED INT HE DESCRIPTION)-- ------------------------------------------------------------------------------------------------------- -- SET THE ROLE & WAREHOUSE USE ROLE ACCOUNTADMIN ; USE WAREHOUSE COMPUTE_WH ; -- CREATE & USE DATABASE AND SCHEMAS CREATE DATABASE IF NOT EXISTS SLEEK_OMS ; CREATE SCHEMA IF NOT EXISTS SLEEK_OMS . L1_LANDING ; USE DATABASE SLEEK_OMS ; USE SCHEMA L1_LANDING ; -- CREATE PERMANENT TABLE CREATE TABLE EMPLOYEE_PER (   ID INT ,   NAME STRING ,   AGE INT ,   SALARY DECIMAL (10, 2) ); -- CREATE TEMPORARY TABLE CREATE TEMPORARY TABLE EMPLOYEE_TMP (   ID INT ,   NAME STRING ,   AGE INT ,   SALARY DECIMAL (10, 2) ); -- CREATE TRANSIENT TABLE CREATE TRANSIENT TABLE EMPLOYEE_TRN (   ID INT ,   NAME STRING ,   AGE INT ,   SALARY DECIMAL (10, 2) );