Connection guide
How to connect GitHub Copilot (VS Code) to your Snowflake costs
Connect GitHub Copilot to your Snowflake costs through Costory's FinOps MCP. GitHub Copilot gets Snowflake spend allocated to teams and features, next to the deploys and metrics that explain it.
What you can ask GitHub Copilot about Snowflake
“Which Snowflake warehouses drove credits up this month?”
“Show Snowflake spend next to AWS for the data team.”
“Alert me when a warehouse exceeds its weekly baseline.”
“Which team owns most of this month's increase?”
“Set up a weekly Slack report of this spend for #finops.”
What GitHub Copilot sees
Costory ingests Snowflake cost through Snowflake account usage via key-pair authentication, normalizes it into one cost model alongside your other providers, and allocates it with warehouses, databases, roles, Virtual Dimensions. Through the MCP server, GitHub Copilot can query that allocated cost, compare periods, look up deploys and other events in the same window, and create alerts, reports and dashboards in Costory. It has no write access to your cloud accounts.
Good to know for this setup
Copilot in VS Code reads Costory from .vscode/mcp.json, under "servers", with type "http" and the Costory URL. Committing that file shares the setup with the repository.
Credits and dollars diverge with contract pricing; report both.
Set up in about 30 minutes
1. Connect Snowflake to Costory. Follow the Snowflake setup guide in the docs.
2. Map spend to owners. Use Virtual Dimensions to group accounts, projects, labels and tags into teams, products and environments, even where tagging is incomplete.
3. Add Costory to VS Code with GitHub Copilot.
Add Costory to .vscode/mcp.json and use Copilot in agent mode:
No local proxy or Node.js is needed: point the client directly at https://app-api.costory.io/mcp.
Full client instructions: MCP setup guide.
Good to know
Credits and dollars diverge with contract pricing; report both.
FAQ
Does GitHub Copilot get write access to my Snowflake account?
No. Costory reads billing data you export to it. MCP actions create Costory objects (alerts, reports, dashboards, events) and never change your cloud resources.
What Snowflake permissions does Costory need?
Read access to billing data only. The exact permissions are listed in the Snowflake setup guide.
Where is the data stored?
Costory stores and processes data in the EU.
How much does it cost?
Plans start at €250/month (up to €10M annual cloud spend), billed annually, with a 30-day free trial. See pricing.
Playbooks
Playbooks for Snowflake
What the Costory agent can watch, investigate and report on for you, with this in the loop.
All playbooks
Costory notices
Every week, across every connected provider.
One showback across AWS, Google Cloud, Azure, AI and data platforms
Teams see all their costs in one place, whatever the provider: cloud, Kubernetes, data platforms and LLM APIs.
See the playbook
Costory notices
A warehouse's idle share or top query cost rises.
Snowflake warehouse review: sizing, idle time and expensive queries
Use warehouse and query history from Snowflake account usage to find oversized warehouses, idle credits and the queries that cost the most.
See the playbook
Costory notices
Daily, as Snowflake usage refreshes.
Snowflake cost by warehouse, team and workload
Allocate Snowflake credits to teams and workloads using warehouses and query history, next to your cloud bill.
See the playbook
Connect in under 30 minutes. Get your first optimization recommendation the next day.
30-day free trial. Copilot, €250/month, or Copilot Pro, €1,000/month, billed annually.
First optimization recommendation
The next day
ROI
Pays for itself with the first recommendation you act on
Setup
About 30 minutes
Data residency
EU
Access
Read-only on your cloud