Claude Meets Snowflake DMF: AI Takes Action: In my previous article, Stop Writing Data Quality Scripts. Start Writing Metadata., I demonstrated a metadata-driven framework using Snowflake Data Metric Functions (DMF). The framework provided a centralized way to configure data quality rules, dynamically attach DMFs, execute validations on demand, and capture […]
Read More
Data Quality using Metadata: Consider a Snowflake environment containing 100 tables, each requiring five data quality checks.That represents 500 quality rule associations. While Snowflake simplifies defining and attaching individual DMFs, maintaining those associations, tracking execution, and consolidating results can require additional operational logic. A traditional implementation might involve repeatedly writing […]
Read More
Horizon REST Catalog with PyIceberg : Apache Iceberg is often positioned around one important idea: The table should not be tied to a single compute engine.Snowflake might be the primary data platform, but if the table is really Apache Iceberg, another Iceberg-compatible engine should also be able to understand it. […]
Read More
Snowflake DMF, Lineage & Cortex AI: In many reporting environments, dashboards and reports depend on Snowflake tables and views that continue to evolve over time.A new column may be added, an existing column may be renamed, or the structure of a table may change as part of normal development For […]
Read More
In this post we build an expense claim adjudication agent and run it in Snowflake Cowork. It reads a claim, applies company policy, tells you what is payable, and records the outcome. The policy it follows is not in the SQL and not in the agent definition , it is […]
Read More
Building a Snowflake MCP Server with Agent, SQL, and Generic Tools: When I first started exploring Snowflake-managed MCP servers, one question kept coming back: If I already have Cortex Analyst or a Cortex Agent, why would I also need SYSTEM_EXECUTE_SQL or a GENERIC tool? Looking at the documentation tells us […]
Read More
