> ## 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.

# list_snowflake_connections

> **List Snowflake connections**

List the workspace's connections to the customer's own Snowflake account, plus a ready-to-run setup script for a new one.

How to use:
- Any Snowsight link fills `setup` (a database or table page also names the database); ask the user only for what `setup` still has null.
- `setup_sql` runs as ACCOUNTADMIN and creates a user, role and warehouse, so confirm with the user before running it through a Snowflake SQL tool of your own. Otherwise give it to them as one block, with `setup.worksheets_url` as the blank SQL file to paste it into. `connect_url` is the same setup as a web page.
- Once it has run, pass `setup`'s account, user, user_role and warehouse to manage_snowflake_connection create.
- A connection with `active: false` and a `setup_error` needs that error fixed in Snowflake, then manage_snowflake_connection with action `update`.
- 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/list_snowflake_connections
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/list_snowflake_connections:
    post:
      summary: list_snowflake_connections
      description: >-
        **List Snowflake connections**


        List the workspace's connections to the customer's own Snowflake
        account, plus a ready-to-run setup script for a new one.


        How to use:

        - Any Snowsight link fills `setup` (a database or table page also names
        the database); ask the user only for what `setup` still has null.

        - `setup_sql` runs as ACCOUNTADMIN and creates a user, role and
        warehouse, so confirm with the user before running it through a
        Snowflake SQL tool of your own. Otherwise give it to them as one block,
        with `setup.worksheets_url` as the blank SQL file to paste it into.
        `connect_url` is the same setup as a web page.

        - Once it has run, pass `setup`'s account, user, user_role and warehouse
        to manage_snowflake_connection create.

        - A connection with `active: false` and a `setup_error` needs that error
        fixed in Snowflake, then manage_snowflake_connection with action
        `update`.

        - Workspace admins only; anyone else gets a 403 on every Snowflake call,
        so don't retry.
      operationId: list_snowflake_connections
      requestBody:
        required: true
        content:
          application/json:
            schema:
              type: object
              properties:
                snowflake_url:
                  description: >-
                    Any app.snowflake.com link the user pasted (account,
                    database, table page, ...). Fills account, database, schema
                    and table into `setup`.
                  type: string
                  maxLength: 2048
                warehouse:
                  description: >-
                    Existing warehouse to use. Omit to have the script create
                    RIPPIT_WH (XSMALL, auto-suspends after 60s).
                  type: string
                  minLength: 1
                  maxLength: 256
                database:
                  description: Database to grant read on, when the link has none.
                  type: string
                  minLength: 1
                  maxLength: 256
              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.