snowflake.com

•

One-click Login

About Snowflake

Snowflake is a cloud-native data platform used by data engineers, analysts, and enterprises for storing, querying, and sharing large datasets. It separates compute from storage, allowing independent scaling of each, and runs on AWS, Azure, and Google Cloud. Snowflake's Data Sharing feature lets organizations share live data with external partners without copying it. Pricing is credit-based: compute consumes credits per hour proportional to warehouse size, while storage is billed per TB/month.

AI Agent Use Cases

- Separated compute and storage for independent elastic scaling

- Multi-cloud deployment across AWS, Azure, and GCP

- Secure Data Sharing: share live data without copying or moving it

- Multi-cluster virtual warehouses for concurrent workload isolation

- Time Travel: query historical data up to 90 days (Enterprise edition)

- Snowpark for running Python, Java, and Scala code within Snowflake

Available Actions

These are the specific actions that AI agents can perform with this tool

Cancel Statement Execution

1 input

Cancel the execution of a SQL statement using the Snowflake SQL API.

Inputs

requestId

The unique identifier of the request to be canceled.

Check Statement Status

3 inputs

Check the status of a SQL statement execution.

Inputs

statementHandle

The handle of the statement that you want to check. You can get this handle from the QueryStatus object returned in the response to the request to execute the statement.

requestId

Unique ID (a UUID) of the API request. See Resubmitting a request to execute SQL statements.

partition

The partition number to return. The size of each partition is determined by Snowflake.

Check Statement Status

3 inputs

Check the execution status of a given SQL statement.

Inputs

statementHandle

The handle of the statement that you want to check. You can get this handle from the QueryStatus object returned in the response to the request to execute the statement.

requestId

Unique ID of the API request. Used to resubmit a request to execute SQL statements if needed.

partition

The partition number to return. The size of each partition is determined by Snowflake.

Create Stored Procedure

8 inputs

Create a new stored procedure in Snowflake using RESTful API.

Inputs

procedureName

The name of the stored procedure to be created.

arguments

The arguments that the stored procedure will accept.

returnType

The return type of the stored procedure.

language

The programming language used for the procedure handler.

handler

The name of the class or method containing the code that executes when the procedure is called.

runtimeVersion

The version of the runtime environment for the language specified.

packages

Packages needed to run the procedure, if applicable.

code

The actual code block for the procedure handler to be executed.

Execute SQL Statement

8 inputs

Submit a SQL query to execute and retrieve results from Snowflake using OAuth for authentication

Inputs

statement

SQL statement to execute.

timeout

Timeout in seconds for statement execution.

database

Database in which the statement should be executed.

schema

Schema in which the statement should be executed.

warehouse

Warehouse to use when executing the statement.

role

Role to use when executing the statement.

bindings

Values of bind variables in the SQL statement.

parameters

Session parameters to set for this request.

Execute SQL Statement Asynchronously

11 inputs

Execute a SQL statement asynchronously and return the statement handle

Inputs

requestId

Unique ID of the API request.

async

Set to `true` to execute the statement asynchronously and return the statement handle.

nullable

Set to `false` to return a SQL NULL value as the string "null" instead of the value `null`.

statement

SQL statement to execute.

timeout

Timeout in seconds for statement execution.

database

Database in which the statement should be executed.

schema

Schema in which the statement should be executed.

warehouse

Warehouse to use when executing the statement.

role

Role to use when executing the statement.

bindings

Values of bind variables in the SQL statement.

parameters

Session parameters to set for this request.

Insert Files

4 inputs

Ingest a list of files to be added into a Snowflake table using a specified pipe.

Inputs

account

Account identifier for your Snowflake account.

pipeName

Case-sensitive, fully qualified pipe name.

requestId

String used to track requests through the system, recommended to be a UUID.

files

List of files to be ingested, each file represented by an object containing path and optionally size.

Load History

4 inputs

Retrieve the history of data loaded into tables using the COPY INTO command within the last 14 days.

Inputs

schema_name

Schema of target table. If not specified, retrieves history for the current schema.

table_name

Name of target table. If specified, filters the results to the specified table.

last_load_time

Specify any day of the week. Filters the results to records after this date and time.

limit

Limit the number of records returned. Maximum of 10,000.

Submit SQL Query

2 inputs

Submit a SQL query for execution in a Snowflake database

Inputs

statement

The SQL statement to be submitted and executed in the Snowflake database.

timeout

Optional execution timeout for the SQL query, specified in milliseconds.

Submit SQL Statements

11 inputs

Submit SQL Statements for Execution

Inputs

requestId

Unique ID of the API request, useful for resubmitting a request if needed.

async

Set to true to execute the statement asynchronously.

nullable

Set to false to return SQL NULL as the string "null".

statement

SQL statement to execute.

timeout

Timeout in seconds for statement execution.

database

Database in which the statement should be executed.

schema

Schema in which the statement should be executed.

warehouse

Warehouse to use when executing the statement.

role

Role to use when executing the statement.

bindings

Values of bind variables in the SQL statement.

parameters

Session parameters to set for this request.