Week 90 - Cortex (AI / ML)

Can you predict the future? No? Well, Snowflake kinda can! How? Well it's those Cortex functions that everyone keeps going on about.

This week we'll be using one of their ML functions.

Your job is to get the training data:

CREATE STAGE IF NOT EXISTS frosty_aws_stageURL = 's3://frostyfridaychallenges/';CREATE OR REPLACE TABLE WEEK_90 ASSELECT$1::TIMESTAMP_NTZ AS SALE_DATE,$2::INT AS PRODUCT_ID,$3::INT AS QUANTITY_SOLD,$4::INT AS UNIT_PRICE,$5/100::FLOAT AS TAX_PCT,$6/100::FLOAT AS DCT_PCTFROM @FROSTY_AWS_STAGE/challenge_90WHERE $1 != 'Date';

And see what Snowflake has to say forecasting-wise about the below:

CREATE OR REPLACE TABLE WEEK_90_F LIKE WEEK_90;ALTER TABLE WEEK_90_F DROP COLUMN QUANTITY_SOLD;INSERT INTO WEEK_90_F VALUES(TO_TIMESTAMP_NTZ('2023-10-29'), 1000, 450, 0.1, 0.02),(TO_TIMESTAMP_NTZ('2023-10-29'), 1001, 150, 0.15, 0.02),(TO_TIMESTAMP_NTZ('2023-10-29'), 1002, 100, 0.13, 0.18),(TO_TIMESTAMP_NTZ('2023-10-29'), 1003, 170, 0.11, 0.03),(TO_TIMESTAMP_NTZ('2023-10-29'), 1004, 300, 0.04, 0.03);

Your output should look like the below:

Happy forecasting!