Snowflake

Learn how to use Snowflake with Composio

Overview

Enum

SNOWFLAKE

Description

Connect to Snowflake to run queries.

Authentication Details

username
stringRequired
password
stringRequired
account_url
stringRequired

Actions

Explore columns in a table in snowflake. this action provides distinct values of columns in a table.

Action Parameters

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

Action Response

data
object
successful
boolean
error

Show tables in a snowflake schema.

Action Parameters

database
stringRequired
schema_name
stringRequired

Action Response

data
object
successful
boolean
error

Describe a table in snowflake. this action provides information about the columns in the table like their data types, nullability, primary key, unique key and default values.

Action Parameters

database
stringRequired
schema_name
stringRequired
table_name
stringRequired

Action Response

data
object
successful
boolean
error

Execute a sql query in snowflake.

Action Parameters

database
stringRequired
schema_name
stringRequired
query
stringRequired

Action Response

data
array
successful
boolean
error