Data Profilers for Tabular Data A data profiler became a must-have for any ad-hoc EDA (Exploratory Data Analysis). And Snowflake shows instant aggregate values and histograms for the data distribution of most numerical and categorical variables from a tabular result grid. …

With Kala Govindarajan In the rapidly evolving world of pharmaceutical manufacturers, effective demand forecasting plays a pivotal role in ensuring the seamless distribution of drugs to meet patient’s needs and mitigate their discomfort arising from drug shortages. …

Welcome to the second post in a series where we will explore macroeconomic data available from Cybersyn on the Snowflake Marketplace and get familiar with the Snowpark Python API. If macroeconomic data science in the cloud gets you amped up, this is the blog series for you! By way of…

Introduction Sometimes, you encounter legacy data lakes feeding data into Snowflake, as in this case I encountered. …

Our coworker has a big wedding anniversary coming up. He asked us if we can leverage Snowpark Container Services to help with this high-stakes task. This prompted us to build a demo to spark some ideas on how to leverage LLM as a powerful shopping assistant. In this post, we’ll…

A while ago I wrote about an Entity-Relationship Diagram (ERD) generator for Snowflake, implemented as a separate proof-of-concept Python project using the Snowflake Connector. While Streamlit in Snowflake is now in Public Preview, let’s see how simple it is to build this project directly within your Snowflake account, as a…

In Part 1 of this series, we parsed an XML file using XSL transformation into a single JSON string. While it may not be the most efficient method for processing data in Snowflake, it serves as a straightforward introduction to the technique. …

Asset and Identity Prioritization — Written by Tammy Truong and Kyle Derevyanik. Back in September of last year, we shared our approach to Shifting from Detection 1.0 to 2.0 at Snowflake by adopting a security data lake architecture, creating a detection development lifecycle, and implementing Asset and Identity Prioritization + Risk and Entity Based Alerting…

Snowflake’s Data Cloud provided as Software-as-a-Service (SaaS), enables data storage, processing, analytic solutions, Machine Learning, and running apps & services in a performant, easy-to-use, and flexible manner using “virtual warehosues” which is the primary compute primitive in Snowflake. …