# Snowflake Basic

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

- **Category:** databases
- **Auth:** BASIC
- **Composio Managed App Available?** N/A
- **Tools:** 6
- **Triggers:** 0
- **Slug:** `SNOWFLAKE_BASIC`
- **Version:** 20260307_00

## Tools

### Describe table

**Slug:** `SNOWFLAKE_BASIC_DESCRIBE_TABLE`

Retrieves detailed information for each column (including name, data type, kind, nullability, default value, and key status) in a specified Snowflake table.

#### Input Parameters

| Parameter | Type | Required | Description |
|-----------|------|----------|-------------|
| `database` | string | Yes | The name of the Snowflake database containing the table. |
| `table_name` | string | Yes | The name of the table to describe. |
| `schema_name` | string | Yes | The name of the schema within the database that contains the table. |

#### Output

| Parameter | Type | Required | Description |
|-----------|------|----------|-------------|
| `data` | string | Yes | Data from the action execution |
| `error` | string | No | Error if any occurred during the execution of the action |
| `successful` | boolean | Yes | Whether or not the action execution was successful or not |

### Explore Columns

**Slug:** `SNOWFLAKE_BASIC_EXPLORE_COLUMNS`

Retrieves a sample of distinct values for specified columns from a Snowflake table.

#### Input Parameters

| Parameter | Type | Required | Description |
|-----------|------|----------|-------------|
| `limit` | integer | No | The maximum number of distinct values to return for each specified column. |
| `database` | string | Yes | The name of the Snowflake database. |
| `table_name` | string | Yes | The name of the table within the specified schema. |
| `schema_name` | string | Yes | The name of the schema within the specified database. |
| `column_names` | array | No | A list of specific column names to explore. If left empty, all columns in the table will be explored. |

#### Output

| Parameter | Type | Required | Description |
|-----------|------|----------|-------------|
| `data` | string | Yes | Data from the action execution |
| `error` | string | No | Error if any occurred during the execution of the action |
| `successful` | boolean | Yes | Whether or not the action execution was successful or not |

### Run Query

**Slug:** `SNOWFLAKE_BASIC_RUN_QUERY`

Executes the given SQL query in Snowflake within the specified database and schema (which must exist and be accessible), automatically setting context first.

#### Input Parameters

| Parameter | Type | Required | Description |
|-----------|------|----------|-------------|
| `query` | string | Yes | SQL query to execute; runs within the context of the specified database and schema. |
| `database` | string | Yes | Name of the Snowflake database. |
| `schema_name` | string | Yes | Name of the schema within the specified database. |

#### Output

| Parameter | Type | Required | Description |
|-----------|------|----------|-------------|
| `data` | string | Yes | Data from the action execution |
| `error` | string | No | Error if any occurred during the execution of the action |
| `successful` | boolean | Yes | Whether or not the action execution was successful or not |

### Show databases

**Slug:** `SNOWFLAKE_BASIC_SHOW_DATABASES`

Retrieves a list of all databases available in the Snowflake account.

#### Output

| Parameter | Type | Required | Description |
|-----------|------|----------|-------------|
| `data` | string | Yes | Data from the action execution |
| `error` | string | No | Error if any occurred during the execution of the action |
| `successful` | boolean | Yes | Whether or not the action execution was successful or not |

### Show schemas

**Slug:** `SNOWFLAKE_BASIC_SHOW_SCHEMAS`

Retrieves a list of all schemas within a specified Snowflake database.

#### Input Parameters

| Parameter | Type | Required | Description |
|-----------|------|----------|-------------|
| `database` | string | Yes | The name of the database for which to list schemas. |

#### Output

| Parameter | Type | Required | Description |
|-----------|------|----------|-------------|
| `data` | string | Yes | Data from the action execution |
| `error` | string | No | Error if any occurred during the execution of the action |
| `successful` | boolean | Yes | Whether or not the action execution was successful or not |

### Show Tables

**Slug:** `SNOWFLAKE_BASIC_SHOW_TABLES`

Retrieves a list of tables, including their row counts and sizes in bytes, from a specified schema within a Snowflake database.

#### Input Parameters

| Parameter | Type | Required | Description |
|-----------|------|----------|-------------|
| `database` | string | Yes | The name of the database containing the schema from which to list tables. |
| `schema_name` | string | Yes | The name of the schema within the specified database for which to list tables. |

#### Output

| Parameter | Type | Required | Description |
|-----------|------|----------|-------------|
| `data` | string | Yes | Data from the action execution |
| `error` | string | No | Error if any occurred during the execution of the action |
| `successful` | boolean | Yes | Whether or not the action execution was successful or not |