Skip to main content
Snowflake Basic logo
  • Category: databases
  • Auth: BASIC
  • Composio-managed OAuth available? N/A
  • Tools: 6
  • Triggers: 0
  • Slug: SNOWFLAKE_BASIC
  • Version: 20261101_00

Tools

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

Input Parameters

string
required
The name of the Snowflake database containing the table.
string
required
The name of the table to describe.
string
required
The name of the schema within the database that contains the table.

Output

string
required
Data from the action execution
string
Error if any occurred during the execution of the action
boolean
required
Whether or not the action execution was successful or not
Slug: SNOWFLAKE_BASIC_EXPLORE_COLUMNSRetrieves 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

integer
The maximum number of distinct values to return for each specified column.
string
required
The name of the Snowflake database.
string
required
The name of the table within the specified schema.
string
required
The name of the schema within the specified database.
array
A list of specific column names to explore. If left empty, all columns in the table will be explored.

Output

string
required
Data from the action execution
string
Error if any occurred during the execution of the action
boolean
required
Whether or not the action execution was successful or not
Slug: SNOWFLAKE_BASIC_RUN_QUERYExecutes the given SQL query in Snowflake within the specified database and schema (which must exist and be accessible), automatically setting context first.

Input Parameters

string
required
SQL query to execute; runs within the context of the specified database and schema.
string
required
Name of the Snowflake database.
string
required
Name of the schema within the specified database.

Output

string
required
Data from the action execution
string
Error if any occurred during the execution of the action
boolean
required
Whether or not the action execution was successful or not
Slug: SNOWFLAKE_BASIC_SHOW_DATABASESRetrieves a list of all databases available in the Snowflake account.

Output

string
required
Data from the action execution
string
Error if any occurred during the execution of the action
boolean
required
Whether or not the action execution was successful or not
Slug: SNOWFLAKE_BASIC_SHOW_SCHEMASRetrieves a list of all schemas within a specified Snowflake database.

Input Parameters

string
required
The name of the database for which to list schemas.

Output

string
required
Data from the action execution
string
Error if any occurred during the execution of the action
boolean
required
Whether or not the action execution was successful or not
Slug: SNOWFLAKE_BASIC_SHOW_TABLESRetrieves a list of tables, including their row counts and sizes in bytes, from a specified schema within a Snowflake database.

Input Parameters

string
required
The name of the database containing the schema from which to list tables.
string
required
The name of the schema within the specified database for which to list tables.

Output

string
required
Data from the action execution
string
Error if any occurred during the execution of the action
boolean
required
Whether or not the action execution was successful or not