Week 139 - Cortex (AI / ML)

AI galore!

Every week there's something new coming from Cortex - and this week, we'll be using the new ENTITY_SENTIMENT() function.

Professor Frosty's training programme has been going from strength to strength thanks to these WONDERFUL reviews!

create or replace stage frosty_stageurl = 's3://frostyfridaychallenges/';create or replace table week_139 asselect$1 as id,$2 as student,$3 as rating,$4 as review_textfrom@frosty_stage/challenge_139 (file_format=>'frosty_csv');

Now, it is your job to figure out the sentiment for the following categories:

Overall

Content

Teaching

And the result ought to look something like: