Snowflake

Learn how to use Snowflake with Composio

Overview

Enum

SNOWFLAKE

Description

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

Authentication Details

username
stringRequired
password
stringRequired
account_url
stringRequired
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
account_url
stringRequired

Actions

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
object
error
string
successful
boolean
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
object
error
string
successful
boolean
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
boolean
Retrieves a list of all databases available in the snowflake account.

Action Parameters

Action Response

data
object
error
string
successful
boolean
Retrieves a list of all schemas within a specified snowflake database.

Action Parameters

database
stringRequired

Action Response

data
object
error
string
successful
boolean
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
object
error
string
successful
boolean