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

# snowflake

> SQL queries, warehouses, and databases

**Server path:** `/snowflake` | **Type:** Application | **PCID required:** Yes

## Tools

| Tool                                                                    | Description                                                                           |
| ----------------------------------------------------------------------- | ------------------------------------------------------------------------------------- |
| [`snowflake_execute_statement`](#snowflake_execute_statement)           | Execute a SQL statement in Snowflake and return results                               |
| [`snowflake_check_statement_status`](#snowflake_check_statement_status) | Check the status of a previously submitted SQL statement                              |
| [`snowflake_cancel_statement`](#snowflake_cancel_statement)             | Cancel the execution of a running SQL statement                                       |
| [`snowflake_list_databases`](#snowflake_list_databases)                 | List all databases available in the Snowflake account                                 |
| [`snowflake_list_schemas`](#snowflake_list_schemas)                     | List all schemas in a database or current database                                    |
| [`snowflake_list_tables`](#snowflake_list_tables)                       | List all tables in a schema, database, or current context                             |
| [`snowflake_describe_table`](#snowflake_describe_table)                 | Get detailed information about a table including columns, data types, and constraints |
| [`snowflake_get_table_ddl`](#snowflake_get_table_ddl)                   | Get the DDL (Data Definition Language) statement for creating a table                 |
| [`snowflake_get_warehouse_status`](#snowflake_get_warehouse_status)     | Get the status of warehouses (running, suspended, etc.)                               |
| [`snowflake_start_warehouse`](#snowflake_start_warehouse)               | Start a suspended warehouse                                                           |
| [`snowflake_stop_warehouse`](#snowflake_stop_warehouse)                 | Stop/suspend a running warehouse                                                      |
| [`snowflake_get_session_info`](#snowflake_get_session_info)             | Get current session information including user, role, warehouse, database, and schema |
| [`snowflake_get_query_history`](#snowflake_get_query_history)           | Get query execution history with optional filters                                     |
| [`snowflake_get_users`](#snowflake_get_users)                           | Get a list of users in the Snowflake account                                          |

***

## snowflake\_execute\_statement

Execute a SQL statement in Snowflake and return results

**Parameters:**

| Parameter   | Type   | Required | Default          | Description                                              |
| ----------- | ------ | -------- | ---------------- | -------------------------------------------------------- |
| `statement` | string | Yes      | —                | SQL statement to execute                                 |
| `timeout`   | number | No       | —                | Execution timeout in seconds (default: 60)               |
| `bindings`  | object | No       | —                | Parameter bindings for the SQL statement                 |
| `database`  | string | No       | —                | Database context for the statement                       |
| `schema`    | string | No       | —                | Schema context for the statement                         |
| `warehouse` | string | No       | —                | Warehouse context for the statement                      |
| `role`      | string | No       | `"ACCOUNTADMIN"` | Role context for the statement, defaults to ACCOUNTADMIN |
| `requestId` | string | No       | —                | Optional request ID for tracking                         |

<Expandable title="inputSchema">
  ```json theme={null}
  {
    "type": "object",
    "properties": {
      "PCID": {
        "type": "string",
        "description": "Pink Connect ID for authentication"
      },
      "statement": {
        "type": "string",
        "description": "SQL statement to execute"
      },
      "timeout": {
        "type": "number",
        "description": "Execution timeout in seconds (default: 60)"
      },
      "bindings": {
        "type": "object",
        "additionalProperties": true,
        "description": "Parameter bindings for the SQL statement"
      },
      "database": {
        "type": "string",
        "description": "Database context for the statement"
      },
      "schema": {
        "type": "string",
        "description": "Schema context for the statement"
      },
      "warehouse": {
        "type": "string",
        "description": "Warehouse context for the statement"
      },
      "role": {
        "type": "string",
        "default": "ACCOUNTADMIN",
        "description": "Role context for the statement, defaults to ACCOUNTADMIN"
      },
      "requestId": {
        "type": "string",
        "description": "Optional request ID for tracking"
      }
    },
    "required": [
      "PCID",
      "statement"
    ]
  }
  ```
</Expandable>

***

## snowflake\_check\_statement\_status

Check the status of a previously submitted SQL statement

**Parameters:**

| Parameter         | Type   | Required | Default | Description                                       |
| ----------------- | ------ | -------- | ------- | ------------------------------------------------- |
| `statementHandle` | string | Yes      | —       | Statement handle returned from execute\_statement |
| `requestId`       | string | No       | —       | Optional request ID for tracking                  |

<Expandable title="inputSchema">
  ```json theme={null}
  {
    "type": "object",
    "properties": {
      "PCID": {
        "type": "string",
        "description": "Pink Connect ID for authentication"
      },
      "statementHandle": {
        "type": "string",
        "description": "Statement handle returned from execute_statement"
      },
      "requestId": {
        "type": "string",
        "description": "Optional request ID for tracking"
      }
    },
    "required": [
      "PCID",
      "statementHandle"
    ]
  }
  ```
</Expandable>

***

## snowflake\_cancel\_statement

Cancel the execution of a running SQL statement

**Parameters:**

| Parameter         | Type   | Required | Default | Description                                 |
| ----------------- | ------ | -------- | ------- | ------------------------------------------- |
| `statementHandle` | string | Yes      | —       | Statement handle of the statement to cancel |
| `requestId`       | string | No       | —       | Optional request ID for tracking            |

<Expandable title="inputSchema">
  ```json theme={null}
  {
    "type": "object",
    "properties": {
      "PCID": {
        "type": "string",
        "description": "Pink Connect ID for authentication"
      },
      "statementHandle": {
        "type": "string",
        "description": "Statement handle of the statement to cancel"
      },
      "requestId": {
        "type": "string",
        "description": "Optional request ID for tracking"
      }
    },
    "required": [
      "PCID",
      "statementHandle"
    ]
  }
  ```
</Expandable>

***

## snowflake\_list\_databases

List all databases available in the Snowflake account

<Expandable title="inputSchema">
  ```json theme={null}
  {
    "type": "object",
    "properties": {
      "PCID": {
        "type": "string",
        "description": "Pink Connect ID for authentication"
      }
    },
    "required": [
      "PCID"
    ]
  }
  ```
</Expandable>

***

## snowflake\_list\_schemas

List all schemas in a database or current database

**Parameters:**

| Parameter  | Type   | Required | Default | Description                                                       |
| ---------- | ------ | -------- | ------- | ----------------------------------------------------------------- |
| `database` | string | No       | —       | Database name to list schemas from (defaults to current database) |

<Expandable title="inputSchema">
  ```json theme={null}
  {
    "type": "object",
    "properties": {
      "PCID": {
        "type": "string",
        "description": "Pink Connect ID for authentication"
      },
      "database": {
        "type": "string",
        "description": "Database name to list schemas from (defaults to current database)"
      }
    },
    "required": [
      "PCID"
    ]
  }
  ```
</Expandable>

***

## snowflake\_list\_tables

List all tables in a schema, database, or current context

**Parameters:**

| Parameter  | Type   | Required | Default | Description                                  |
| ---------- | ------ | -------- | ------- | -------------------------------------------- |
| `database` | string | No       | —       | Database name (defaults to current database) |
| `schema`   | string | No       | —       | Schema name (defaults to current schema)     |

<Expandable title="inputSchema">
  ```json theme={null}
  {
    "type": "object",
    "properties": {
      "PCID": {
        "type": "string",
        "description": "Pink Connect ID for authentication"
      },
      "database": {
        "type": "string",
        "description": "Database name (defaults to current database)"
      },
      "schema": {
        "type": "string",
        "description": "Schema name (defaults to current schema)"
      }
    },
    "required": [
      "PCID"
    ]
  }
  ```
</Expandable>

***

## snowflake\_describe\_table

Get detailed information about a table including columns, data types, and constraints

**Parameters:**

| Parameter   | Type   | Required | Default | Description                   |
| ----------- | ------ | -------- | ------- | ----------------------------- |
| `tableName` | string | Yes      | —       | Name of the table to describe |
| `database`  | string | Yes      | —       | Database name                 |
| `schema`    | string | Yes      | —       | Schema name                   |

<Expandable title="inputSchema">
  ```json theme={null}
  {
    "type": "object",
    "properties": {
      "PCID": {
        "type": "string",
        "description": "Pink Connect ID for authentication"
      },
      "tableName": {
        "type": "string",
        "description": "Name of the table to describe"
      },
      "database": {
        "type": "string",
        "description": "Database name"
      },
      "schema": {
        "type": "string",
        "description": "Schema name"
      }
    },
    "required": [
      "PCID",
      "tableName",
      "database",
      "schema"
    ]
  }
  ```
</Expandable>

***

## snowflake\_get\_table\_ddl

Get the DDL (Data Definition Language) statement for creating a table

**Parameters:**

| Parameter   | Type   | Required | Default | Description                                  |
| ----------- | ------ | -------- | ------- | -------------------------------------------- |
| `tableName` | string | Yes      | —       | Name of the table to get DDL for             |
| `database`  | string | No       | —       | Database name (defaults to current database) |
| `schema`    | string | No       | —       | Schema name (defaults to current schema)     |

<Expandable title="inputSchema">
  ```json theme={null}
  {
    "type": "object",
    "properties": {
      "PCID": {
        "type": "string",
        "description": "Pink Connect ID for authentication"
      },
      "tableName": {
        "type": "string",
        "description": "Name of the table to get DDL for"
      },
      "database": {
        "type": "string",
        "description": "Database name (defaults to current database)"
      },
      "schema": {
        "type": "string",
        "description": "Schema name (defaults to current schema)"
      }
    },
    "required": [
      "PCID",
      "tableName"
    ]
  }
  ```
</Expandable>

***

## snowflake\_get\_warehouse\_status

Get the status of warehouses (running, suspended, etc.)

**Parameters:**

| Parameter       | Type   | Required | Default | Description                                          |
| --------------- | ------ | -------- | ------- | ---------------------------------------------------- |
| `warehouseName` | string | No       | —       | Specific warehouse name (defaults to all warehouses) |

<Expandable title="inputSchema">
  ```json theme={null}
  {
    "type": "object",
    "properties": {
      "PCID": {
        "type": "string",
        "description": "Pink Connect ID for authentication"
      },
      "warehouseName": {
        "type": "string",
        "description": "Specific warehouse name (defaults to all warehouses)"
      }
    },
    "required": [
      "PCID"
    ]
  }
  ```
</Expandable>

***

## snowflake\_start\_warehouse

Start a suspended warehouse

**Parameters:**

| Parameter       | Type   | Required | Default | Description                    |
| --------------- | ------ | -------- | ------- | ------------------------------ |
| `warehouseName` | string | Yes      | —       | Name of the warehouse to start |

<Expandable title="inputSchema">
  ```json theme={null}
  {
    "type": "object",
    "properties": {
      "PCID": {
        "type": "string",
        "description": "Pink Connect ID for authentication"
      },
      "warehouseName": {
        "type": "string",
        "description": "Name of the warehouse to start"
      }
    },
    "required": [
      "PCID",
      "warehouseName"
    ]
  }
  ```
</Expandable>

***

## snowflake\_stop\_warehouse

Stop/suspend a running warehouse

**Parameters:**

| Parameter       | Type   | Required | Default | Description                   |
| --------------- | ------ | -------- | ------- | ----------------------------- |
| `warehouseName` | string | Yes      | —       | Name of the warehouse to stop |

<Expandable title="inputSchema">
  ```json theme={null}
  {
    "type": "object",
    "properties": {
      "PCID": {
        "type": "string",
        "description": "Pink Connect ID for authentication"
      },
      "warehouseName": {
        "type": "string",
        "description": "Name of the warehouse to stop"
      }
    },
    "required": [
      "PCID",
      "warehouseName"
    ]
  }
  ```
</Expandable>

***

## snowflake\_get\_session\_info

Get current session information including user, role, warehouse, database, and schema

<Expandable title="inputSchema">
  ```json theme={null}
  {
    "type": "object",
    "properties": {
      "PCID": {
        "type": "string",
        "description": "Pink Connect ID for authentication"
      }
    },
    "required": [
      "PCID"
    ]
  }
  ```
</Expandable>

***

## snowflake\_get\_query\_history

Get query execution history with optional filters

**Parameters:**

| Parameter   | Type   | Required | Default | Description                                        |
| ----------- | ------ | -------- | ------- | -------------------------------------------------- |
| `limit`     | number | No       | —       | Maximum number of queries to return (default: 100) |
| `startTime` | string | No       | —       | Start time for query history (ISO format)          |
| `endTime`   | string | No       | —       | End time for query history (ISO format)            |

<Expandable title="inputSchema">
  ```json theme={null}
  {
    "type": "object",
    "properties": {
      "PCID": {
        "type": "string",
        "description": "Pink Connect ID for authentication"
      },
      "limit": {
        "type": "number",
        "description": "Maximum number of queries to return (default: 100)"
      },
      "startTime": {
        "type": "string",
        "description": "Start time for query history (ISO format)"
      },
      "endTime": {
        "type": "string",
        "description": "End time for query history (ISO format)"
      }
    },
    "required": [
      "PCID"
    ]
  }
  ```
</Expandable>

***

## snowflake\_get\_users

Get a list of users in the Snowflake account

<Expandable title="inputSchema">
  ```json theme={null}
  {
    "type": "object",
    "properties": {
      "PCID": {
        "type": "string",
        "description": "Pink Connect ID for authentication"
      }
    },
    "required": [
      "PCID"
    ]
  }
  ```
</Expandable>