> ## Documentation Index
> Fetch the complete documentation index at: https://composio-preview.mintlify.site/llms.txt
> Use this file to discover all available pages before exploring further.

# Snowflake Basic

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

![Snowflake Basic logo](https://mintcdn.com/composio-preview/B09iGux45A5cYDuO/images/toolkits/snowflake_basic.svg?fit=max\&auto=format\&n=B09iGux45A5cYDuO\&q=85\&s=9965531c58781bcd131067cff5fdd0ed)

* **Category:** databases
* **Auth:** BASIC
* **Composio-managed OAuth available?** N/A
* **Tools:** 6
* **Triggers:** 0
* **Slug:** `SNOWFLAKE_BASIC`
* **Version:** 20261101\_00

## Tools

> [accordion] 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
>
> **database** `string` *required*
>
> The name of the Snowflake database containing the table.
>
> **table\_name** `string` *required*
>
> The name of the table to describe.
>
> **schema\_name** `string` *required*
>
> The name of the schema within the database that contains the table.
>
> #### Output
>
> **data** `string` *required*
>
> Data from the action execution
>
> **error** `string`
>
> Error if any occurred during the execution of the action
>
> **successful** `boolean` *required*
>
> Whether or not the action execution was successful or not

> [accordion] Explore Columns
>
> **Slug:** `SNOWFLAKE_BASIC_EXPLORE_COLUMNS`
>
> Retrieves a sample of distinct values for specified columns in a Snowflake table. Set a per-column limit to control the number of values returned; non-null values are represented as strings.
>
> #### Input Parameters
>
> **limit** `integer`
>
> The maximum number of distinct values to return for each specified column.
>
> **database** `string` *required*
>
> The name of the Snowflake database.
>
> **table\_name** `string` *required*
>
> The name of the table within the specified schema.
>
> **schema\_name** `string` *required*
>
> The name of the schema within the specified database.
>
> **column\_names** `array`
>
> A list of specific column names to explore. If left empty, all columns in the table will be explored.
>
> #### Output
>
> **data** `string` *required*
>
> Data from the action execution
>
> **error** `string`
>
> Error if any occurred during the execution of the action
>
> **successful** `boolean` *required*
>
> Whether or not the action execution was successful or not

> [accordion] 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
>
> **query** `string` *required*
>
> SQL query to execute; runs within the context of the specified database and schema.
>
> **database** `string` *required*
>
> Name of the Snowflake database.
>
> **schema\_name** `string` *required*
>
> Name of the schema within the specified database.
>
> #### Output
>
> **data** `string` *required*
>
> Data from the action execution
>
> **error** `string`
>
> Error if any occurred during the execution of the action
>
> **successful** `boolean` *required*
>
> Whether or not the action execution was successful or not

> [accordion] Show databases
>
> **Slug:** `SNOWFLAKE_BASIC_SHOW_DATABASES`
>
> Retrieves a list of all databases available in the Snowflake account.
>
> #### Output
>
> **data** `string` *required*
>
> Data from the action execution
>
> **error** `string`
>
> Error if any occurred during the execution of the action
>
> **successful** `boolean` *required*
>
> Whether or not the action execution was successful or not

> [accordion] Show schemas
>
> **Slug:** `SNOWFLAKE_BASIC_SHOW_SCHEMAS`
>
> Retrieves a list of all schemas within a specified Snowflake database.
>
> #### Input Parameters
>
> **database** `string` *required*
>
> The name of the database for which to list schemas.
>
> #### Output
>
> **data** `string` *required*
>
> Data from the action execution
>
> **error** `string`
>
> Error if any occurred during the execution of the action
>
> **successful** `boolean` *required*
>
> Whether or not the action execution was successful or not

> [accordion] 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
>
> **database** `string` *required*
>
> The name of the database containing the schema from which to list tables.
>
> **schema\_name** `string` *required*
>
> The name of the schema within the specified database for which to list tables.
>
> #### Output
>
> **data** `string` *required*
>
> Data from the action execution
>
> **error** `string`
>
> Error if any occurred during the execution of the action
>
> **successful** `boolean` *required*
>
> Whether or not the action execution was successful or not
