Data professionals often face challenges when transferring data from Excel to database systems. However, leveraging Python libraries pre-loaded into Snowflake enables efficient loading of Excel files with a few simple steps, bypassing traditional ETL complexity. This process involves confirming file location, capturing sheet names, reading Excel data, and writing it to Snowflake.
Tag Archives: Python
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 