Analytics & Data

Snowflake

Learn how to use Snowflake with Composio

Overview

SLUG

SNOWFLAKE

Description

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

Authentication Details

client_id
stringRequired
client_secret
stringRequired
oauth_redirect_uri
stringDefaults to https://backend.composio.dev/api/v1/auth-apps/add
scopes
stringDefaults to session:role:PUBLIC
subdomain
stringRequired
username
stringRequired
password
stringRequired
subdomain
stringRequired

Tools

SLUG: SNOWFLAKE_DESCRIBE_TABLE

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

Action Parameters

database
stringRequired
schema_name
stringRequired
table_name
stringRequired

Action Response

data
objectRequired
error
string
successful
booleanRequired

SLUG: SNOWFLAKE_EXPLORE_COLUMNS

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

Action Parameters

column_names
array
database
stringRequired
limit
integerDefaults to 10
schema_name
stringRequired
table_name
stringRequired

Action Response

data
objectRequired
error
string
successful
booleanRequired

SLUG: SNOWFLAKE_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.

Action Parameters

database
stringRequired
query
stringRequired
schema_name
stringRequired

Action Response

data
array
error
string
successful
booleanRequired

SLUG: SNOWFLAKE_SHOW_DATABASES

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

Action Parameters

Action Response

data
objectRequired
error
string
successful
booleanRequired

SLUG: SNOWFLAKE_SHOW_SCHEMAS

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

Action Parameters

database
stringRequired

Action Response

data
objectRequired
error
string
successful
booleanRequired

SLUG: SNOWFLAKE_SHOW_TABLES

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

Action Parameters

database
stringRequired
schema_name
stringRequired

Action Response

data
objectRequired
error
string
successful
booleanRequired