The era of AI in the data warehouse is here — and Snowflake’s Cortex makes it easier than ever to bring Large Language Model (LLM) capabilities directly to your data without moving it outside the Snowflake ecosystem. In this blog, I want to share how I built a Streamlit-powered AI […]
Read More
dbt Tests in Snowflake: Override Failure Tables + Email Alerts: Imagine you’re running a retail analytics pipeline on Snowflake. Every night, customer orders are loaded from multiple source systems into your Orders table. On one day, business users report that the dashboard is showing negative order amounts and orders dated […]
Read More
With Snowflake’s Iceberg Tables feature, you can manage Iceberg data stored in your cloud storage—retaining all the advantages of Iceberg’s open format while benefiting from Snowflake’s powerful query engine, governance, and security. In this blog, we’ll explore two approaches for creating and loading Iceberg tables in Snowflake using dbt: a […]
Read More
Cortex + dbt = No More Manual Minutes: Ever wondered how to automatically transform your company’s messy meeting notes into crisp, actionable minutes—and deliver them right to your inbox, without a single spreadsheet or copy-paste? In this blog, we showcase a proof-of-concept (POC) that transforms unstructured meeting notes into insightful […]
Read More
In this blog, “SQL & Python Unite: dbt Feature Pipeline,” I’ll walk you through a real-world use case where I combined the power of SQL, Python (Snowpark), and dbt to build a production-ready feature pipeline. The goal? To track user session activity over the last 7 days, count the number […]
Read More
Tag, Mask, Protect: PII Handling in Snowflake is no longer optional—it’s essential. As organizations grow, data governance at scale becomes critical — especially when handling personally identifiable information (PII). Manual tagging and masking do not scale across thousands of tables and columns. Imagine a global logistics company ingesting real-time shipment […]
Read More
