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

client_id
stringRequired
client_secret
stringRequired
oauth_redirect_uri
string
scopes
string
account_url
stringRequired
username
stringRequired
password
stringRequired
account_url
stringRequired

Actions

Cancels the execution of a running sql statement. use this action to stop a long-running query.

Action Parameters

request_id
string
statementHandle
stringRequired

Action Response

data
object
error
string
successful
boolean
Retrieves the status of a previously submitted sql statement. replace '{statementhandle}' with the unique identifier of the statement.

Action Parameters

partition
integer
requestId
integer
statementHandle
stringRequired

Action Response

code
string
data
array
error
string
message
string
statementHandle
string
statementStatusUrl
string
successful
boolean
Tool to execute a sql statement and return the resulting data. use when you need to query data from snowflake.

Action Parameters

bindings
object
database
string
parameters
object
role
string
schema_name
string
statement
stringRequired
timeout
integer
warehouse
string

Action Response

data
array
error
string
successful
boolean
Fetches details of a specific catalog integration.

Action Parameters

name
stringRequired

Action Response

data
object
error
string
successful
boolean
Retrieves a list of any active scheduled maintenances currently in the in progress or verifying state.

Action Parameters

Action Response

data
object
error
string
successful
boolean
Retrieves a list of the 50 most recent scheduled maintenances, including those in the completed state.

Action Parameters

Action Response

data
object
error
string
successful
boolean
Retrieves the status of individual components, each listed with its current status.

Action Parameters

limit
integer

Action Response

data
object
error
string
successful
boolean
Retrieves the status rollup for the entire page, including indicators and human-readable descriptions of the blended component status.

Action Parameters

Action Response

data
object
error
string
successful
boolean
Retrieves a summary of the status page, including status indicators, component statuses, unresolved incidents, and upcoming or in-progress scheduled maintenances.

Action Parameters

Action Response

data
object
error
string
successful
boolean
Retrieves a list of any unresolved incidents currently in the investigating, identified, or monitoring state.

Action Parameters

Action Response

data
object
error
string
successful
boolean
Retrieves a list of any upcoming scheduled maintenances still in the scheduled state.

Action Parameters

test_id
string

Action Response

data
object
error
string
successful
boolean
Lists all databases for which you have access privileges. shows database metadata including name, creation date, owner, retention time, and more. can filter results and include dropped databases within time travel retention period.

Action Parameters

from_name
string
history
boolean
like_pattern
string
limit
integer
role
string
starts_with
string
terse
boolean
timeout
integer
warehouse
string

Action Response

columns
array
data
array
error
string
successful
boolean
Lists all schemas for which you have access privileges. shows schema metadata including name, creation date, owner, database, retention time, and more. can filter results and include dropped schemas within time travel retention period.

Action Parameters

database
string
from_name
string
history
boolean
in_scope
string
like_pattern
string
limit
integer
role
string
starts_with
string
terse
boolean
timeout
integer
warehouse
string

Action Response

columns
array
data
array
error
string
successful
boolean
Lists all tables for which you have access privileges. shows table metadata including name, creation date, owner, database, schema, row count, size in bytes, clustering keys, and more. can filter results and include dropped tables within time travel retention period.

Action Parameters

database
string
from_name
string
history
boolean
in_scope
string
like_pattern
string
limit
integer
role
string
schema
string
starts_with
string
terse
boolean
timeout
integer
warehouse
string

Action Response

columns
array
data
array
error
string
successful
boolean
Submits a sql statement for execution.

Action Parameters

bindings
object
database
string
parameters
object
role
string
schema
string
statement
stringRequired
timeout
integerDefaults to 604800
warehouse
string

Action Response

code
string
createdOn
integer
data
array
error
string
message
string
resultSetMetaData
object
sqlState
string
statementHandle
string
statementHandles
array
statementStatusUrl
string
stats
object
successful
boolean