Skip to content
Try for free

Connect Snowflake to ChatGPT

  • What were last week's numbers?

Get answers from your Snowflake warehouse in ChatGPT without writing SQL or waiting on the data team. Lemonado connects them in about 3 minutes, no API keys needed.

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

Why connect Snowflake to ChatGPT?

Most marketing questions about Snowflake are small: last week's revenue by channel, how many customers came back. They still end up as tickets. Pick Lemonado with @ in ChatGPT and it queries the warehouse for you, with live ad spend from Google Ads and Meta next to the numbers.

  • 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 ChatGPT

Add to ChatGPT

Before you start

  • A Snowflake account you can sign in to
  • A ChatGPT 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 ChatGPT plugins

    Go to chatgpt.com/plugins. Select + and choose Add custom MCP server.

  4. 4

    Add Lemonado

    Name it Lemonado, add a short description, and paste the server URL under Connection. Set authentication to OAuth.

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

    Create the plugin

    Review the acknowledgement and select Create as a plugin. Check the tools ChatGPT discovers, then install it.

  6. 6

    Ask ChatGPT about Snowflake

    Start a new chat, type @ and pick Lemonado. Sign in to Lemonado when ChatGPT asks. Try "@Lemonado From Snowflake, give me last week's net revenue, orders and new customers, and how each compares with the week before." Or ask: "Can you write the update?" or "How many came back?"

Good to know

  • Your ChatGPT account and workspace settings decide whether you can add custom MCP servers. Workspace admins can turn it off.
  • Older guides point to Settings → Apps → Developer mode. OpenAI has replaced that flow with Plugins.

What can ChatGPT do with Snowflake?

ChatGPT reads your Snowflake numbers when you pick @Lemonado, and writes the update, the summary or the next step for you.

ChatGPT logoChatGPT

@Lemonado From Snowflake, give me last week's net revenue, orders and new customers, and how each compares with the week before.

Net revenue $412k (+7%), 3,980 orders (+5%), 1,140 new customers (-3%). Average order value rose because of the tent bundle.

Source: Snowflake

Connect Snowflake to another AI app.

Other integrations for ChatGPT

All ChatGPT integrations

Reading this as an AI agent?

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

For agents · markdown
# Connect Snowflake to ChatGPT (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 ChatGPT: Plugins → + → Add custom MCP server

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

One-click install: https://chatgpt.com/plugins/plugin_asdk_app_69455664de448191bc42a9f6584d34e5

First question to try: "@Lemonado From Snowflake, give me last week's net revenue, orders and new customers, and how each compares with the week before."

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

Frequently Asked Questions

No. ChatGPT only sees what Lemonado's Snowflake role can read, and Lemonado only sends the query results it needs for each answer. Keep sensitive schemas out of that role and they stay out of every answer.

Yes. Snowflake's managed MCP server is hosted, so ChatGPT 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 ChatGPT can answer questions across them.

Check that Lemonado is installed at chatgpt.com/plugins, then pick it with @ in a new chat. Workspace admins can turn custom plugins off. 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 "Compare the purchases Google Ads reported last week with orders in Snowflake that have a gclid."

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