# 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:** 20260407_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.

### Explore Columns

**Slug:** `SNOWFLAKE_BASIC_EXPLORE_COLUMNS`

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

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

### Show databases

**Slug:** `SNOWFLAKE_BASIC_SHOW_DATABASES`

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

### Show schemas

**Slug:** `SNOWFLAKE_BASIC_SHOW_SCHEMAS`

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

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