Skip to main content

Snowflake — Claude Connector Guide

This guide covers how to query Snowflake data through Claude using the Snowflake MCP connector.

Prerequisites​

  1. Have a Snowflake account — follow the Access section of the Snowflake Usage Guide to get set up.
  2. Set your default warehouse — the connector requires a default warehouse to execute queries.

Setting the Default Warehouse​

  1. Sign in to app.snowflake.com
  2. Click your username in the bottom-left corner → Settings -> Preferences
  3. Under Default Role, select SYSADMIN
  4. Under Default Warehouse, select ANALYTICS_WH

Connecting Through Claude​

When you ask Claude a Snowflake-related question for the first time in a session, Claude will display a Connect prompt before it can access any data.

  1. When you see the Connect prompt, click it to authenticate
  2. Complete the authentication flow
  3. Claude will confirm the connection and answer your question

Note: You may need to reconnect at the start of each Claude session.

Running a Query​

Once connected, ask Claude directly in plain English. For example:

  • "Show me all organizations in Snowflake"
  • "List the most recent recordings for org X"

Claude will translate your question into a SQL query against the LEGION_ANALYTICS database and return the results.