> This page is for Agent Handler.

> For clean Markdown of any page, append .md to the page URL.
> For a complete documentation index, see https://docs.merge.dev/llms.txt.
> For AI client integration (Claude Code, Cursor, etc.), connect to the MCP server at https://docs.merge.dev/_mcp/server.

# Snowflake

**Authentication:** OAuth, key-pair authentication, or programmatic access token. See [Magic Link](/merge-agent-handler/features/magic-link) for the runtime auth flow, or [Application credentials](/merge-agent-handler/admin-setup/add-oauth-credentials) to bring your own OAuth app.

## Sample use cases

* Run a query to count signups by source over the last 30 days from `ANALYTICS.EVENTS`.
* List the largest tables in the `PROD` schema by row count.
* Show queries from the last 24 hours that scanned more than 1TB.

## Available Tools

#### list\_databases

List all databases in the Snowflake account

#### create\_database

Create a new database in Snowflake

#### alter\_database

Alter an existing database in Snowflake

#### drop\_database

Drop a database from Snowflake

#### get\_database

Get details of a specific database

#### list\_schemas

List all schemas in a database

#### create\_schema

Create a new schema in a database

#### alter\_schema

Alter an existing schema in Snowflake

#### drop\_schema

Drop a schema from a database

#### get\_schema

Get details of a specific schema

#### list\_roles

List all roles in the Snowflake account

#### create\_role

Create a new role in Snowflake

#### drop\_role

Drop a role from Snowflake

#### get\_role

Get details of a specific role

#### grant\_privilege

Grant privileges to a role on a Snowflake object

#### revoke\_privilege

Revoke privileges from a role on a Snowflake object

#### grant\_role

Grant a role to a user or another role

#### revoke\_role

Revoke a role from a user or another role

#### execute\_sql

Execute a SQL statement in Snowflake (query, DDL, or DML)

#### get\_statement\_status

Get the status of an asynchronous SQL statement

#### get\_query\_results

Fetch results from a completed SQL query with pagination

#### cancel\_statement

Cancel a running SQL statement

#### list\_stages

List all stages in a schema

#### create\_stage

Create a new stage for data loading/unloading

#### drop\_stage

Drop a stage from Snowflake

#### get\_stage

Get details of a specific stage

#### list\_stage\_files

List files in a stage

#### describe\_stage

Describe a stage to see its properties and file format settings

#### copy\_into\_table

Load data from a stage into a table. Supports file patterns, error handling modes, and validation.

#### copy\_into\_location

Unload data from a table or query to a stage. Supports file format and partitioning options.

#### list\_tables

List all tables in a schema

#### create\_table

Create a new table in Snowflake

#### alter\_table

Alter an existing table in Snowflake

#### drop\_table

Drop a table from Snowflake

#### describe\_table

Get the structure and column definitions of a table

#### get\_table

Get details of a specific table

#### list\_tasks

List all tasks in a schema

#### create\_task

Create a new scheduled task in Snowflake

#### alter\_task

Alter an existing task in Snowflake

#### drop\_task

Drop a task from Snowflake

#### resume\_task

Resume a suspended task to start scheduled execution

#### suspend\_task

Suspend a running task to stop scheduled execution

#### execute\_task

Execute a task immediately without waiting for schedule

#### get\_task\_history

Get execution history for a task

#### get\_task

Get details of a specific task

#### list\_users

List all users in the Snowflake account

#### create\_user

Create a new user in Snowflake

#### alter\_user

Alter an existing user in Snowflake

#### drop\_user

Drop a user from Snowflake

#### get\_user

Get details of a specific user

#### execute\_sql\_readonly

Execute a read-only SQL statement in Snowflake (SELECT, WITH, SHOW, DESCRIBE, EXPLAIN, VALUES, LIST). Rejects DDL/DML and multi-statement input.

#### list\_warehouses

List all warehouses in the Snowflake account

#### create\_warehouse

Create a new virtual warehouse in Snowflake

#### alter\_warehouse

Alter an existing warehouse in Snowflake

#### drop\_warehouse

Drop a warehouse from Snowflake

#### resume\_warehouse

Resume a suspended warehouse

#### suspend\_warehouse

Suspend a running warehouse to stop billing

#### get\_warehouse

Get details of a specific warehouse