From the course: Building Generative AI Apps to Talk to Your Data

Unlock this course with a free trial

Join today to access over 25,300 courses taught by industry experts.

Using Cortex Analyst

Using Cortex Analyst - Snowflake Tutorial

From the course: Building Generative AI Apps to Talk to Your Data

Start my 1-month free trial Buy for my team

Using Cortex Analyst

“

- Welcome back. In the last video, you created the Semantic Model and passed it to complete, but we need better results. In this video, we will engage Cortex Analyst and see how it elegantly deals with this level of complexity. Let's think about this for a second. So imagine you are a senior manager at an international retail company that is feeling a little frustrated. You ask your Texas Equal workflow for data on sales performance by region, by store, and who the top performing sales reps are for each store and region. What you got back was the dataset that had columns of numerical IDs for the stores, regions and reps. Not very human readable. A quick filter tells you what you want to know, but now you have to spend time looking up which numerical identifier refers to which region, store and rep. The other option is to join in new columns from Dimension tables with the human readable labels for the region, store and reps. This is time consuming and pretty frustrating. What you…

Contents