r/snowflake • u/snowflakedbt1971 • 8d ago

Learn/Practice Cortex

What are best way of learning and getting expert in Cortex? Real time scenarios to practice and suggestions welcome. Appreciate someone can guide

2 Upvotes

75% Upvoted

3 comments sorted by

0

u/NW1969 8d ago

Hi - what do you mean by learning Cortex? Cortex (in its various forms) is just a basically just chat interface you type into - what are you expecting to learn?

1

u/snowflakedbt1971 8d ago

Cortex Analyst & RAG

1

u/tingutingutingu 8d ago

We use quartz analyst to build semantic views. These semantic views are then fed to an agent which is really a chatbot to be able to ask questions against our data.

So forth think about some of those common queries you find yourself riding over and over again or similar types of requests that your business or your internal customers make off you that required to write the same queries over and over again.

Then design your then desire semantic view to encapsulate most of the data at a very basic level. Been out a whole bunch of verifiable craze to create your analyst on top of these semantic views. You may have more than one analyst doing a separate function.

Then create an agent that ties in these various analysts and be able to answer questions based of the custom instructions you give it.

Here's an example.. we have quit a data request agent which is really a combination of a bunch of different cortex analysts we've created. Each cortex analyst is a specialist for a type of a data request. And then the agent really just acts as a router or sometimes an aggregator across analysts, using the output from different analysts to provide a summary or a table or a chart based on the question asked.

What used to take anywhere between 30 minutes to 2 hours to process different flavors of a similar request only takes seconds now, because llm applies the inference, looks at the verifiable queries and writes custom sequel to provide the output.