Ask Your Snowflake Account Anything — Build an AI Admin Agent with Cortex + GitHub Copilot

TL;DR — Spin up a Snowflake Cortex Agent that can answer admin questions like "Which warehouses burned the most credits last month?" or "Who are my top 5 spenders?" — all from a natural-language prompt inside GitHub Copilot Chat. The Problem Snowflake ACCOUNT_USAGE contains everything you need to understand spend, performance, and security. The catch? You have to know the right table, the right join, and write it correctly every time. What if you could just ask? What You'll Build GitHub Copilot Chat │ (natural language) ▼ MCP Server (Python, local) │ ask_admin tool ▼ Snowflake Cortex Agent │ routes to the right semantic view ▼ SNOWFLAKE.ACCOUNT_USAGE (+ optional ORGANIZATION_USAGE) By the end you'll be able to type questions like these into Copilot Chat and get back answers with real numbers: What are total compute credits by warehouse in the last 30 days? Which users consumed the most credits this month? How many failed logins occurred in the last 7 days? What are serverless credits b