With the rise of AI and ML, the significance of fundamental practices like security and access control in Snowflake often gets overshadowed. This blog post demonstrates a script for creating and managing hierarchical roles, ensuring proper role management in Snowflake. By following these steps, you can maintain a secure and organized Snowflake environment.
Author Archives: Eric Heilman
Snowflake Cortex: Vectorizing Text and Customer Record Matching
The post discusses the challenges of managing customer information, with a focus on using Snowflake Cortex to integrate and compare customer data. It highlights the addition of VECTOR data types and LLM functions to assist in text vectorization, as well as methods for scoring customer name similarity. The creation of a Streamlit app for demonstration and the use of various models for vectorizing data are also covered. The author emphasizes the need for careful monitoring and tuning of scoring thresholds to ensure accurate customer identification.
Snowflake AI LLM Showdown: Easily Compare Models with Streamlit
The post discusses the increasing prevalence of AI and the process of building a Streamlit app to compare responses from different LLM models within Snowflake Cortex. It outlines the setup processes for Snowflake and Streamlit and demonstrates the creation of a chatbot interface to compare model outputs for a given prompt.
Eric Heilman 