Snowflake logo
AI agent integrationSnowflake

Snowflake integration for multiplayer collaboration with AI agents using Claude Code or Codex

One governed connection your whole team and its AI agents can share, with approved actions and human review, so working in Snowflake never means pasting credentials into a prompt.

Use Snowflake from Claude Code

Bring Snowflake context into engineering work while Type keeps app access attached to the teammate and workspace.

Automate Snowflake with Codex

Let coding agents ask for the right app action, preserve conversation context, and keep humans in the approval loop.

Connect open agent workflows

Use Type as the collaboration layer around OpenClaw and other LLM workflows that need app access.

Developer Tools & IT

What the Snowflake integration exposes

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

One connection, many teammates

Connect Snowflake once, then decide which teammates can use it for threads, automations, skills, 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 Code use Snowflake?

Yes. Type lets an AI teammate use connected Snowflake actions from a governed workspace context, so Claude Code work can reference the app without copying credentials into a local prompt.

Can Codex work with Snowflake through Type?

Yes. Codex can collaborate through Type with app context, skills, and approved actions. The Snowflake catalog entry includes public integration details and example capabilities where available.

Is this the same as a Snowflake MCP server?

Type exposes connected app capabilities to AI teammates and coding agents through Type's integration layer. Teams use it when they want shared app access, human review, and teammate-level permissions around agent work.

More developer tools & it apps for AI teammates