Fetch Live Data in Snowflake with External Access — because modern data platforms no longer operate in isolation. They thrive on real-time external data that helps drive faster, smarter decisions. Whether it’s weather forecasts, market trends, or currency exchange rates, organizations today need the ability to pull live insights directly […]
Read More
Snowflake provides a rich set of features for identity management such as password policies, MFA, SSO integration, and role-based access control. However, one limitation we often face is automating password expiry notifications in Snowflake, since the platform does not natively notify users when their password is about to expire. In […]
Read More
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
