Recent Articles

  • Streamlining Role Creation and Assignment in Snowflake with SQL

    Streamlining Role Creation and Assignment in Snowflake with SQL

    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. Read more

  • Snowflake Cortex: Vectorizing Text and Customer Record Matching

    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… Read more

  • Snowflake AI LLM Showdown: Easily Compare Models with Streamlit

    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. Read more

  • Foundational Principles in Data Engineering: Staying Grounded Amidst Tech Trends

    Foundational Principles in Data Engineering: Staying Grounded Amidst Tech Trends

    As I scroll through social media – LinkedIn, X, Reddit, and even Facebook, I see many posts and advertisements for various solutions in the data space. Some are for entirely new data solutions such as Snowflake, Databricks, and BigQuery. Others are for ETL/ELT tools offering to solve an age-old problem – collecting data in one place. Still, Read more

  • TL;DR Made Easy: Summarizing Web Content with Snowflake and Streamlit

    TL;DR Made Easy: Summarizing Web Content with Snowflake and Streamlit

    This article discusses leveraging Snowflake’s Cortex to create a Streamlit app that summarizes web content. It outlines prerequisites, importing libraries, inputting the URL, parsing HTML with BeautifulSoup, and using Snowflake to summarize the content. The app is executed and its potential is highlighted. The author offers the complete code on GitHub for exploration. Read more

  • Streamlit Power-Up: Advanced Image Display Options for Snowflake Users

    Streamlit Power-Up: Advanced Image Display Options for Snowflake Users

    Explore advanced image integration in Streamlit for Snowflake. From internal stage setups to external sources like S3, learn to enhance your app’s visuals effortlessly. Read more