Browse Cortex Code Starter Prompts
Need inspiration? Ask Cortex Code: “What can you do?”
Manage Data Pipelines
Build and debug pipelines end-to-end: create dynamic tables with incremental refresh, configure streams and tasks, set up Iceberg tables, and troubleshoot failing refreshes with root cause analysis.
Create a Dynamic Table that incrementally merges new records from my raw_events stream into events_processed, refreshing every 5 minutes.Ship dbt Models
An AI coding assistant with dbt parsing built in. It reads your project in seconds, helps you manage hundreds of models, writes Jinja-powered SQL, runs builds, and authors Apache Airflow® DAGs.
Add a dbt model for monthly_recurring_revenue joining subscriptions to payments, add unique and not_null tests, and run dbt buildBuild AI Agents
Define tools, connect MCP servers, and build semantic views that define what your data means in business terms so agents get the right answer. For complex tasks, spin up agent teams that divide the work and run in parallel.
Build a Cortex Agent that uses my support_tickets semantic view and a Jira MCP server to answer questions about open incidentsLaunch Data Apps
Build and deploy Streamlit dashboards, React apps, Native Apps, and containerized services on SPCS. Wire up data, logic, and UI, then ship it to your account without a separate deploy pipeline.
Build a Streamlit app on MONTHLY_REVENUE with filters by region and product line, then deploy itData Exploration
Profile tables, check freshness, trace lineage, monitor data quality, and ask questions about unfamiliar datasets. Get answers based on actual metadata, not guesses.
Find the top 10 customers by total spend in the last 90 days, including signup date and regionAccount Optimization
Audit role grants, classify PII, apply masking policies, find runaway queries, analyze warehouse spend, and set up budget alerts. Governance and cost management from one place.
Show me the top 5 most expensive queries this week, which warehouses they ran on, and whether any are candidates for query accelerationAgentic Machine Learning
Automate the path from data to predictive insights. Cortex Code selects the right technique for each step across training, deployment, tuning, and monitoring so you focus on domain expertise.
Train an XGBoost classifier on my churn_features table, log it to the Model Registry, and run inference on this month's active users.Build Custom Skills
Package repeatable workflows as custom skills that anyone on your team can run. Encode your best practices once, then share them so every teammate works the same way.
Create a skill that onboards new analysts: profile their assigned tables, generate starter queries, and document the schemaWhat customers are saying about Cortex Code
“Cortex Code helps us reduce friction in everyday data and AI development while maintaining the controls and oversight we need in a regulated environment. Our teams can build faster with the context they need to be successful.”
Vibhor Gupta
“Cortex Code gives our teams a simple, in-platform way to move quickly from exploring ideas to delivering AI-driven workflows directly on Snowflake.”
Srinivas Madabushi
“Cortex Code helps our engineers improve the performance of our business intelligence tools, meaningfully reducing the time it takes to improve quality and speed of Natural Language Query responses.”
Tony Leopold
Frequently Asked Questions
If you're already a Snowflake customer, there's nothing new to sign up for — no separate contract, no subscription. Cortex Code CLI is billed on token consumption through your existing Snowflake account, the same way Cortex Agents and Snowflake Intelligence are billed. Rates are in the Service Consumption Table.
Any compute or storage the agent triggers (warehouses, tables, etc.) is billed separately at your normal Snowflake rates.
New to Snowflake? Sign up at signup.snowflake.com/cortex-code for a free trial with bundled usage. After 30 days it converts to a monthly paid subscription. You may cancel at any time (and manage other aspects of your subscription) through your Account Dashboard. Any compute or storage the agent triggers (warehouses, tables, etc.) is billed separately at your normal Snowflake rates.
Run cortex in your terminal and it walks you through picking (or creating) a connection and logging in — browser-based auth, SSO, whatever you already use. It reads the same connection files as the Snowflake CLI, so there's nothing extra to configure.
Cortex Code runs inside Snowflake's existing RBAC and governance — it can only touch what your roles allow. The CLI also sandboxes OS access, prompts before risky operations, and supports org-managed policies that lock down tools, accounts, and overrides. Inputs and outputs fall under Snowflake's AI and Pass-Through Terms. More detail in the Security best practices doc.
macOS, Linux (including WSL), and Windows. Run it in any terminal — standalone or inside VS Code, Cursor, etc. It works with your local repos, git, dbt, and other CLI tools while staying Snowflake-aware.