Skip to content
Try for free

Connect Snowflake to Claude

  • Which customers are worth the most?

Ask Claude about the revenue and customer tables in Snowflake in plain words, and get the answer as an artifact. Lemonado connects them in about 2 minutes, no API keys needed.

Try free with $150 in creditsAdd to Claude
MCPhttps://mcp.lemonado.io/mcp

Why connect Snowflake to Claude?

Your data team already modeled revenue, margin and customers in Snowflake, but most marketers still wait in a queue for each query. Through Lemonado, Claude reads those models directly, writes the SQL itself, shows it to you and lays the result out in an artifact you can share without a dashboard ticket.

  • All your Snowflake data

    Tables and views your role can read, ready to ask about.

  • Always today's numbers

    Column names, types and descriptions, synced from Snowflake automatically, so answers use today's numbers.

  • Connect all your tools

    Questions like "What does a paying customer cost?" use Snowflake and BigQuery, GA4 at once.

How to connect Snowflake to Claude

Add to Claude

Before you start

  • A Snowflake account you can sign in to
  • A Claude account
  • A Lemonado account (the free trial works)
  1. 1

    Connect Snowflake in Lemonado

    In Lemonado, open Connectors, find Snowflake and sign in. Create a read-only role that can use one warehouse and the schemas marketing should see, and connect with that. Keep raw PII schemas out of the grant.

  2. 2

    Turn on external access

    In the company's settings, open External tools, turn the connection on, choose which sources it can reach and copy the server URL.

    text
    https://mcp.lemonado.io/mcp
  3. 3

    Open Claude's connectors

    Go to claude.ai and open Customize → Connectors. Click + Add, then Add custom connector.

  4. 4

    Add Lemonado

    Name it Lemonado and paste the server URL. Continue, review the sign-in settings Claude detects, and choose Sign in now.

    text
    https://mcp.lemonado.io/mcp
  5. 5

    Sign in and turn it on

    Approve access in the Lemonado window. Back in Claude, open a new chat and switch Lemonado on from the connectors menu.

  6. 6

    Ask Claude about Snowflake

    Try "From our Snowflake customer model, split last year's new customers by first product category and show 12-month revenue for each as an artifact." Or ask: "Can you explain this model?" or "Is the dip real?"

Good to know

  • Custom connectors work on Claude Free, Pro, Max, Team and Enterprise. Free accounts can add one.
  • On Team and Enterprise, an owner adds the connector first under Organization settings → Connectors → Add → Custom → Web. Members then connect their own accounts.
  • Remote connectors belong to your Claude account, so the same connection shows up in Claude Desktop and Cowork. Requests come from Anthropic's cloud, not your computer.

What can Claude do with Snowflake?

Claude reads your Snowflake numbers, explains what moved and turns the answer into an artifact you can share.

Claude logoClaude

From our Snowflake customer model, split last year's new customers by first product category and show 12-month revenue for each as an artifact.

Done. Customers whose first order was a tent are worth $268 in year one, against $96 for those who started with socks or accessories. The artifact has the chart and the SQL behind it.

Source: Snowflake

Connect Snowflake to another AI app.

Other integrations for Claude

All Claude integrations

Reading this as an AI agent?

Everything an agent needs to set this up, in plain text. Paste this page's link into Claude and ask it to connect you, or copy the block.

For agents · markdown
# Connect Snowflake to Claude (Lemonado MCP)

- Server URL: https://mcp.lemonado.io/mcp
- Transport: Streamable HTTP
- Auth: OAuth; the user signs in to Lemonado in the browser. No API keys.
- In Lemonado: connect the Snowflake role and warehouse. Create a read-only role that can use one warehouse and the schemas marketing should see, and connect with that. Keep raw PII schemas out of the grant.
- In Claude: Customize → Connectors → Add custom connector

```text
https://mcp.lemonado.io/mcp
```

One-click install: https://claude.ai/directory/lemonado

First question to try: "From our Snowflake customer model, split last year's new customers by first product category and show 12-month revenue for each as an artifact."

More: https://lemonado.io/integrations/snowflake · https://lemonado.io/llms.txt
FAQ

Frequently Asked Questions

Only what the role you connect with allows. Give Lemonado a read-only role on the schemas marketing should use, and Claude can query those and nothing else. Every query it runs is shown in the answer, so your data team can check the SQL.

Yes. Snowflake's managed MCP server is hosted, so Claude can use it too. It covers Snowflake only. Lemonado covers Snowflake plus your ad platforms, GA4 and the rest of your stack in one connection, so Claude can answer questions across them.

In Claude, open Customize → Connectors and check that Lemonado says Connected, then switch it on from the connectors menu in the chat. In Lemonado, check that Snowflake is connected and External tools is on for the company. If a table is missing, the role can't see it. Grant USAGE on its database and schema and SELECT on the table, then ask again.

Yes, if both are connected in Lemonado. One connection reaches every source you allow, so you can ask things like "Join first orders from Snowflake with Meta and Google Ads spend by month this year. What did each new customer cost per channel?"

MCP is included in Lemonado's paid plans and in the free trial, so you can try it before you pay.

See plans and pricing

Still have a question?

Shoot us an email at hello@lemonado.io.

Try for free

Stop fighting with data. Start feeding your AI.

Connect your data to AI and free your team from reporting and busywork.

Try Lemonado free