Snowflake#

Execute SQL queries and explore Snowflake data resources — databases, schemas, tables, views, warehouses, and pipelines — directly from chat.

This skill uses ClawLink for hosted connection flows and credentials so you do not need to configure Snowflake API access yourself.

Setup in 3 Steps#

Step 1: InstallStep 2: Pair AccountStep 3: Connect Snowflake_App-specific connection GIF coming soon_Run the install command in OpenClawSign in and approve the deviceOpen the dashboard and connect Snowflake

How It Works#

text

┌─────────────────┐     ┌──────────────┐     ┌──────────────────┐
│   OpenClaw      │────▶│   ClawLink   │────▶│   Snowflake      │
│   (User Chat)   │     │   (OAuth)    │     │   REST API       │
└─────────────────┘     └──────────────┘     └──────────────────┘
         │                       │                       │
         │  1. Install Plugin    │                       │
         │  2. Pair Device       │                       │
         │  3. Connect Snowflake │                       │
         │                       │  4. Secure Token      │
         │                       │  5. Proxy Requests    │
         │                       │                       │
         ▼                       ▼                       ▼
   ┌──────────┐           ┌──────────┐           ┌──────────┐
   │  SKILL   │           │ Dashboard│           │ Snowflake│
   │  File    │           │ Auth     │           │ Account  │
   └──────────┘           └──────────┘           └──────────┘

Install#

Install the verified ClawLink plugin from ClawHub. After the user confirms, complete the full setup so ClawLink tools are visible in the next OpenClaw chat.

bash

openclaw plugins install clawhub:clawlink-plugin
openclaw config set tools.alsoAllow '["clawlink-plugin"]' --strict-json
openclaw gateway restart

Then tell the user: "OpenClaw has been restarted. Send /new as a standalone message to start a fresh chat, then ask for Snowflake again."

Quick Start#

bash

# List databases
clawlink_call_tool --tool "snowflake_list_databases" --params '{}'

# Execute a SELECT query
clawlink_call_tool --tool "snowflake_execute_query" --params '{"sql": "SELECT * FROM MY_DB.MY_SCHEMA.MY_TABLE LIMIT 10"}'

# List tables in a schema
clawlink_call_tool --tool "snowflake_list_tables" --params '{"database": "MY_DB", "schema": "MY_SCHEMA"}'

Authentication#

All Snowflake tool calls are authenticated automatically by ClawLink using the user's connected Snowflake account credentials.

No credentials are required in chat. ClawLink stores the connection credentials securely and injects them into every Snowflake API request on the user's behalf.

Getting Connected#

1. Install the ClawLink plugin (see Install above).
2. Pair the plugin with clawlink_begin_pairing if it is not configured yet.
3. Open https://claw-link.dev/dashboard?add=snowflake and connect Snowflake.
4. Call clawlink_list_integrations to verify the connection is active.

Connection Management#

List Connections#

bash

clawlink_list_integrations

Response: Returns all connected integrations. Look for snowflake in the list.

Verify Connection#

bash

clawlink_list_tools --integration snowflake

Response: Returns the live tool catalog for Snowflake.

Reconnect#

If Snowflake tools are missing or the connection shows an error:

1. Direct the user to https://claw-link.dev/dashboard?add=snowflake
2. After they confirm, call clawlink_list_integrations to verify
3. Then call clawlink_list_tools --integration snowflake

Security & Permissions#

• Access is scoped to the Snowflake account and databases authorized during connection setup.
• All write operations and DDL/DML queries require explicit user confirmation. Never execute ALTER, DROP, DELETE, or TRUNCATE without explicit approval.
• SELECT queries should use explicit LIMIT clauses to avoid returning extremely large result sets.
• Confirm the target database, schema, and table before any write or delete operation.
• Raw SQL execution via snowflake_execute_query carries full risk — always confirm the SQL before running.

Tool Reference#

Databases & Schemas#

ToolDescriptionModesnowflake_list_databasesList all databases accessible to the accountReadsnowflake_get_databaseGet metadata for a specific databaseReadsnowflake_list_schemasList all schemas in a databaseReadsnowflake_get_schemaGet metadata for a specific schemaRead

Tables & Views#

ToolDescriptionModesnowflake_list_tablesList all tables in a database and schemaReadsnowflake_get_tableGet metadata for a specific tableReadsnowflake_list_viewsList all views in a database and schemaReadsnowflake_get_viewGet the SQL definition of a viewReadsnowflake_list_columnsList all columns in a table or viewReadsnowflake_describe_tableDescribe the structure of a tableRead

Query Execution#

ToolDescriptionModesnowflake_execute_queryExecute a raw SQL query and return resultsWritesnowflake_execute_statementExecute a DDL or DML statementWrite

Warehouses#

ToolDescriptionModesnowflake_list_warehousesList all warehousesReadsnowflake_get_warehouseGet warehouse properties and statusReadsnowflake_create_warehouseCreate a new warehouseWritesnowflake_suspend_warehouseSuspend a warehouseWritesnowflake_resume_warehouseResume a suspended warehouseWrite

Users & Roles#

ToolDescriptionModesnowflake_list_usersList all users in the accountReadsnowflake_get_userGet user properties and grantsReadsnowflake_list_rolesList all rolesReadsnowflake_get_role_grantsList grants for a roleRead

Stages & Files#

ToolDescriptionModesnowflake_list_stagesList stages in a schemaReadsnowflake_list_files_in_stageList files in a named stageReadsnowflake_put_fileUpload a file to an internal stageWrite

Code Examples#

List all tables in a schema#

bash

clawlink_call_tool --tool "snowflake_list_tables" \
  --params '{
    "database": "ANALYTICS_DB",
    "schema": "PUBLIC"
  }'

Execute a SELECT query with a LIMIT#

bash

clawlink_call_tool --tool "snowflake_execute_query" \
  --params '{
    "sql": "SELECT customer_id, SUM(amount) as total FROM TRANSACTIONS GROUP BY customer_id ORDER BY total DESC LIMIT 20"
  }'

Get table column details#

bash

clawlink_call_tool --tool "snowflake_list_columns" \
  --params '{
    "database": "SALES_DB",
    "schema": "ORDERS",
    "table": "CUSTOMERS"
  }'

Check warehouse status#

bash

clawlink_call_tool --tool "snowflake_get_warehouse" \
  --params '{
    "warehouse_name": "COMPUTE_WH"
  }'

Suspend a warehouse#

bash

clawlink_call_tool --tool "snowflake_suspend_warehouse" \
  --params '{
    "warehouse_name": "COMPUTE_WH"
  }'

Discovery Workflow#

1. Call clawlink_list_integrations to confirm Snowflake is connected.
2. Call clawlink_list_tools --integration snowflake to see the live catalog.
3. Treat the returned list as the source of truth. Do not guess or assume what tools exist.
4. If the user describes a capability but the exact tool is unclear, call clawlink_search_tools with a short query and integration snowflake.
5. If no Snowflake tools appear, direct the user to https://claw-link.dev/dashboard?add=snowflake.

Execution Workflow#

text

┌─────────────────────────────────────────────────────────────┐
│  READ OPERATIONS (Safe)                                     │
│  list → get → describe → execute SELECT                    │
│                                                             │
│  Example: List schemas → List tables → Describe table     │
└─────────────────────────────────────────────────────────────┘
                              │
                              ▼
┌─────────────────────────────────────────────────────────────┐
│  WRITE OPERATIONS (Require Confirmation)                    │
│  describe → preview → confirm → execute DDL/DML             │
│                                                             │
│  Example: Preview DDL → User approves → Run CREATE TABLE   │
└─────────────────────────────────────────────────────────────┘

1. For unfamiliar tools, ambiguous requests, or any write action, call clawlink_describe_tool first.
2. Use the returned guidance, schema, whenToUse, askBefore, safeDefaults, examples, and followups to shape the call.
3. Prefer read, list, describe, and SELECT operations before any write or DDL.
4. For writes or DDL/DML queries, call clawlink_preview_tool first and confirm the exact SQL.
5. Execute with clawlink_call_tool. Pass confirmation only after the preview matches the user's intent.
6. If the tool call fails, report the real error. Do not invent results or restate the failure as a missing capability unless the live catalog supports that conclusion.

Notes#

• Always use explicit LIMIT clauses on SELECT queries to avoid returning extremely large datasets.
• DDL and DML operations (CREATE, DROP, DELETE, UPDATE, TRUNCATE) require explicit user confirmation.
• Table and column names may be case-sensitive depending on how they were created — use double quotes if needed.
• Warehouses must be running before queries can execute — they may auto-suspend after periods of inactivity.
• The account parameter for some operations is the Snowflake account identifier (not the account name).

Error Handling#

Status / ErrorMeaningTool not foundThe tool name does not exist in the current catalog. Verify with clawlink_list_tools --integration snowflake.Missing connectionSnowflake is not connected. Direct the user to https://claw-link.dev/dashboard?add=snowflake.Database not foundThe specified database does not exist or is not accessible.Schema not foundThe specified schema does not exist in the database.Table not foundThe specified table does not exist.Warehouse not foundThe warehouse name is incorrect or not accessible.Insufficient privilegesThe connected account lacks the required role/privilege for this operation.Warehouse is suspendedCannot execute queries on a suspended warehouse. Resume it first.SQL compilation errorSyntax error in the SQL query. Review and fix the SQL.Write rejectedUser did not confirm a write action or DDL/DML. Always confirm before executing.

Troubleshooting: Tools Not Visible#

1. Check that the ClawLink plugin is installed: bash

   openclaw plugins list
   
   

2. If the plugin is installed but tools are missing, tell the user to send /new as a standalone message to reload the catalog.

3. If a fresh chat does not help, run: bash

   openclaw config set tools.alsoAllow '["clawlink-plugin"]' --strict-json
   openclaw gateway restart
   
   

4. After restart, tell the user to send /new again and retry.

Troubleshooting: Query Returns Empty#

1. Verify the database, schema, and table names are spelled correctly — use snowflake_list_tables to confirm the table exists.
2. Check that the warehouse is running — suspended warehouses return no data.
3. Confirm the connected account has SELECT privilege on the target table.

Troubleshooting: DDL/DML Fails#

1. Verify the connected account has the required role/grants for the operation.
2. Some operations require the ACCOUNTADMIN role or specific object privileges.
3. Dropping tables or schemas may be blocked by referential integrity constraints.

Resources#

• Snowflake Documentation
• Snowflake SQL Reference
• Snowflake REST API
• ClawLink: https://claw-link.dev/?utm_source=clawhub&utm_medium=referral&utm_content=snowflake-data
• ClawLink Docs: https://docs.claw-link.dev/openclaw
• ClawLink Verification: https://claw-link.dev/verify

---

Powered by ClawLink — an integration hub for OpenClaw