> This page is for Workforce.

> 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