Snowflake MCP connector

Snowflake is a cloud data platform for storing, querying, and analyzing large volumes of structured data. The Snowflake MCP connector allows AI agents to execute SQL statements, monitor and cancel query executions, and explore databases, schemas, and tables. It also supports fetching detailed metadata about tables and views, enabling agents to navigate complex data structures across a Snowflake instance.

Authentication type

• OAuth 2.0 Authorization Code - Requires a one-time user login to authorize the agent to access the service on their behalf.

Uses

Use the Snowflake MCP connector to perform the following actions:

• Run SQL queries directly against Snowflake without writing custom scripts
• Track long-running query status until results are ready
• Cancel runaway queries before they consume warehouse credits
• Browse databases, schemas, tables, and views for quick data discovery
• Inspect warehouse configurations to right-size compute resources
• Build and manage Iceberg tables for open data lake analytics
• Clone, refresh, or convert Iceberg tables across catalog sources
• Tag Iceberg tables to support governance and data classification

Example prompts

Use the following example prompts to invoke Snowflake MCP connector tools from your AI assistant or Boomi Connect workflow:

• Show me all customer orders placed in Snowflake last quarter.
• List every database available in our Snowflake account.
• Check if my sales report query has finished running in Snowflake.
• Cancel the query I just submitted to Snowflake.
• What tables exist in the finance schema in Snowflake?
• Give me details on the warehouse we use for reporting in Snowflake.
• Create a new Iceberg table to store our shipment history.
• Show me the structure of the customer view in Snowflake.
• List all the Iceberg tables we have set up in Snowflake.
• Tag our sensitive customer data tables in Snowflake for compliance.

Snowflake MCP connector tools

The Snowflake MCP connector provides the following tools. Each tool maps to a specific action you can invoke from your AI agent or automation.

Tool	Description
SubmitStatement	Submits a SQL statement for execution.
GetStatementStatus	Checks the status of the execution of a statement
CancelStatement	Cancels the execution of a statement.
listDatabases	List databases.
fetchDatabase	Fetches a database.
listSchemas	List schemas.
fetchSchema	Fetches a schema.
listTables	List tables
fetchTable	Fetch a table.
listViews	List views
fetchView	Fetch a view
listWarehouses	List warehouse
fetchWarehouse	Describe warehouse
listIcebergTables	List iceberg tables
createSnowflakeManagedIcebergTable	Create a snowflake managed iceberg table
createSnowflakeManagedIcebergTableAsSelect	Create a snowflake managed iceberg table as select
createUnmanagedIcebergTableFromAWSGlueCatalog	Create an unmanaged iceberg table from AWS Glue catalog
createUnmanagedIcebergTableFromDelta	Create an unmanaged iceberg table from Delta
createUnmanagedIcebergTableFromIcebergFiles	Create an unmanaged iceberg table from Iceberg files
createUnmanagedIcebergTableFromIcebergRest	Create an unmanaged iceberg table from Iceberg REST
fetchIcebergTable	Describe iceberg table
dropIcebergTable	Drop iceberg table
resumeReclusterIcebergTable	Resume recluster of an iceberg table
suspendReclusterIcebergTable	Suspend recluster of an iceberg table
refreshIcebergTable	Refreshes the metadata for an Apache Iceberg table that uses an external Iceberg catalog
convertToManagedIcebergTable	Converts an Apache Iceberg table that uses an external Iceberg catalog into a table that uses Snowflake as the catalog
undropIcebergTable	Undrop iceberg table
cloneSnowflakeManagedIcebergTable	Clone a snowflake managed iceberg table
createSnowflakeManagedIcebergTableLike	Create iceberg table like
setIcebergTableTags	Set tags on an Iceberg table.
unsetIcebergTableTags	Unset tags from an Iceberg table.
getIcebergTableTags	Get the tag assignments for an Iceberg table.