Snowflake logo
ConnectorSnowflake

Snowflake integration for Claude and Codex

Create a Snowflake connection, then control which Spaces can use its approved tools and data without pasting credentials into prompts or threads.

Use Snowflake from Claude

Add the Snowflake connection to a Space that runs Claude, then use it from every channel in that Space.

Use Snowflake from Codex

Add the Snowflake connection to a Space that runs Codex, then use it from every channel in that Space.

Use Snowflake from Sidekick

Connect your own OpenClaw to Sidekick while Type provides the conversations, permissions, connections, skills, and automations.

Developer Tools & IT

What the Snowflake connector can do

Snowflake is a cloud-based data warehouse offering elastic scaling, secure data sharing, and SQL analytics across multiple cloud environments

One connection, many Spaces

Connect Snowflake once, then decide which Spaces can use it in threads, skills, automations, and coding work.

Representative actions

  • Cancel Statement Execution

    Cancels the execution of a running SQL statement. Use this action to stop a long-running query.

  • Check Statement Status

    Retrieves the status and results of a previously submitted SQL statement using its statement handle. Use this to poll async queries submitted via SNOWFLAKE_SUBMIT_SQL_STATEMENT; call repeatedly until status is no longer pending. Use SNOWFLAKE_CANCEL_STATEMENT to abort a hanging query.

  • Execute SQL

    Execute SQL statements in Snowflake and retrieve results. Supports SELECT queries for data retrieval, DDL statements (CREATE, ALTER, DROP) for schema management, and DML statements (INSERT, UPDATE, DELETE) for data modification. Returns comprehensive result metadata including column types, row counts, and execution status. Unquoted SQL identifiers are auto-uppercased by Snowflake — use matching case in `database`, `schema_name`, `warehouse`, and `role` parameters to avoid 'object not found' errors. Always apply explicit time-range filters and a LIMIT clause to unbounded SELECT queries to prevent large, slow result sets.

  • Fetch Catalog Integration

    Retrieves detailed configuration and metadata for a specific catalog integration. Catalog integrations allow Snowflake to connect to external Apache Iceberg catalogs (AWS Glue, Snowflake Open Catalog/Polaris, or Apache Iceberg REST catalogs) to query Iceberg tables managed by those external systems.

  • Get Active Scheduled Maintenances

    Retrieves a list of any active scheduled maintenances currently in the In Progress or Verifying state.

Connection

API and auth details

Snowflake's SQL and REST APIs use account-specific snowflakecomputing.com hosts with bearer tokens from OAuth, key-pair JWT, or programmatic access tokens.

FAQ

Questions people ask before connecting Snowflake

Can Claude use Snowflake?

Yes. Add a Snowflake connection to a Space that runs Claude, then use its approved tools and data from any channel in that Space.

Can Codex work with Snowflake through Type?

Yes. Add a Snowflake connection to a Space that runs Codex, then use its approved tools and data from any channel in that Space.

Is this the same as a Snowflake MCP server?

Not exactly. Type uses connectors and connections to give selected Spaces access to approved app tools and data. Some connectors use hosted MCP, while others use OAuth, API keys, service accounts, or custom APIs.

More developer tools & it connectors