Use Snowflake Cortex Code MCP in Claude Code to Get the Best of Both Worlds

A guide to connecting Claude Code with Snowflake's Cortex Code via the Model Context Protocol (MCP). The integration gives Claude live access to Snowflake's execution layer — schema exploration, query execution, semantic model queries, and Cortex Agent discovery — as structured tool calls. Setup involves installing the Cortex Code CLI, configuring a Snowflake connection, and adding an MCP server entry to Claude Code's config. A detailed example demonstrates building a full medallion-architecture data pipeline (bronze/silver/gold layers, stored procedures, streams, CDC, a semantic model, Cortex Agent, and a Streamlit app) from a single prompt with no follow-up needed.