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

Unlock this course with a free trial

Join today to access over 24,700 courses taught by industry experts.

Expanding the scope of the semantic model

Expanding the scope of the semantic model - Snowflake Tutorial

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

Start my 1-month free trial Buy for my team

Expanding the scope of the semantic model

“

- Welcome back. Now that Cortex Analyst can answer questions in natural language about revenue and break it down by region, let's expand it to include breakdowns by different product lines. Jump back into your notebook to follow along. (air whooshing) Okay, we now have a model that allows Cortex Analyst to answer our revenue questions by region, but what would be even better is if we could include breakdowns for different product lines. This can open up the model to another business unit that can take advantage of what we've built here. In the next cell, we'll define an extension to our Semantic Model, semantic model product. We will name the table and give it a description that references it as a dimension table. Under dimensions, we'll set product ID and product line with some sample values. Then we'll just depend it onto our semantic model using replace so that it sticks in the right spot. Next, we need to make sure that semantic model includes their relationship between our…

Contents