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: Install	Step 2: Pair Account	Step 3: Connect Snowflake
		App-specific connection GIF coming soon
Run the install command in OpenClaw	Sign in and approve the device	Open the dashboard and connect Snowflake

How It Works

┌─────────────────┐     ┌──────────────┐     ┌──────────────────┐
│   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.

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

# 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

clawlink_list_integrations

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

Verify Connection

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

Tables & Views

Query Execution

Warehouses

Users & Roles

Stages & Files

Code Examples

List all tables in a schema

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

Execute a SELECT query with a LIMIT

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

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

Check warehouse status

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

Suspend a warehouse

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

┌─────────────────────────────────────────────────────────────┐
│  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

Troubleshooting: Tools Not Visible

1. Check that the ClawLink plugin is installed:

   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:

   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
• ClawLink Docs: https://docs.claw-link.dev/openclaw
• ClawLink Verification: https://claw-link.dev/verify

Powered by ClawLink — an integration hub for OpenClaw