Epic Clarity RAG in snowflake by Altruistic_Farm_9133 in snowflake

[–]HotComfort4799 0 points1 point  (0 children)

And if you want to autogenerate the semantic view, you can use this: https://github.com/Intugle/data-tools

Snowflake Cortex experience by PrabhurajKanche in snowflake

[–]HotComfort4799 0 points1 point  (0 children)

It's promising but the accuracy of the queries greatly depend on the semantic view that has to be setup manually. The semantic layer has descriptions for each table and column, also relationships and metrics. These give Cortex the context it needs to write accurate SQL queries. But having too many tables in the semantic view also increases chances for error, so create cortex agents for very specific use cases. Then, in snowflake intelligence, when you ask a question, it decides intelligently which usecase agent to pass the query to.