> ## Documentation Index
> Fetch the complete documentation index at: https://docs.rippit.com/llms.txt
> Use this file to discover all available pages before exploring further.

# manage_snowflake_connection

> **Manage Snowflake connection**

Create, update, disconnect or delete a connection to the customer's own Snowflake account. Rippit logs in with its own key pair, so no password or private key is ever passed.

How to use:
- Run `setup_sql` from list_snowflake_connections in Snowflake first; create then logs in to verify. A login or permission failure comes back as `setup_error` on an inactive connection: fix it in Snowflake, then `update`.
- `update` re-verifies; pass only the fields that change. Account, user and region can't change on a verified connection — create a new one. `update` also reconnects a disconnected connection.
- Workspace admins only; anyone else gets a 403 on every Snowflake call, so don't retry.



## OpenAPI

````yaml /api-reference/tools-openapi.json post /v1/manage_snowflake_connection
openapi: 3.1.0
info:
  title: Rippit API
  version: 1.0.0
  description: Every operation is also an MCP tool with the same name and parameters.
servers:
  - url: https://api.rippit.com
security:
  - bearer: []
paths:
  /v1/manage_snowflake_connection:
    post:
      summary: manage_snowflake_connection
      description: >-
        **Manage Snowflake connection**


        Create, update, disconnect or delete a connection to the customer's own
        Snowflake account. Rippit logs in with its own key pair, so no password
        or private key is ever passed.


        How to use:

        - Run `setup_sql` from list_snowflake_connections in Snowflake first;
        create then logs in to verify. A login or permission failure comes back
        as `setup_error` on an inactive connection: fix it in Snowflake, then
        `update`.

        - `update` re-verifies; pass only the fields that change. Account, user
        and region can't change on a verified connection — create a new one.
        `update` also reconnects a disconnected connection.

        - Workspace admins only; anyone else gets a 403 on every Snowflake call,
        so don't retry.
      operationId: manage_snowflake_connection
      requestBody:
        required: true
        content:
          application/json:
            schema:
              type: object
              properties:
                action:
                  type: string
                  enum:
                    - create
                    - update
                    - disconnect
                    - delete
                  description: >-
                    create a connection, update one (re-verifies login),
                    disconnect it (pauses its imports), or delete one whose
                    setup never finished.
                connection_id:
                  description: Required for update, disconnect and delete.
                  type: string
                  minLength: 1
                account:
                  description: >-
                    Snowflake account identifier, e.g. "abc12345" or
                    "myorg-myaccount". Required for create.
                  type: string
                  minLength: 1
                  maxLength: 256
                user:
                  description: >-
                    Snowflake service user from the setup script. Required for
                    create.
                  type: string
                  minLength: 1
                  maxLength: 256
                warehouse:
                  description: Warehouse the user may run queries on. Required for create.
                  type: string
                  minLength: 1
                  maxLength: 256
                region:
                  description: Snowflake region, if the account id needs one.
                  type: string
                  minLength: 1
                  maxLength: 256
                user_role:
                  description: Role from the setup script.
                  type: string
                  minLength: 1
                  maxLength: 256
                idempotency_key:
                  description: >-
                    create only: retries with the same key return the same
                    connection.
                  type: string
                  minLength: 1
                  maxLength: 128
              required:
                - action
              additionalProperties: false
      responses:
        '200':
          description: Tool result.
components:
  securitySchemes:
    bearer:
      type: http
      scheme: bearer

````

This documentation is built and hosted on [Mintlify](https://mintlify.com), a developer documentation platform.