shield_lock
金大哥
← 返回 Skill 列表
extension
分类: 数据与分析无需 API Key

Snowflake

执行SQL查询、检查Snowflake数据库、模式、表、视图、仓库及数据管道资源。当用户需要查询数据时使用此技能。

person作者: hith3shhubclawhub
open_in_new仓库download下载资源包

Snowflake

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 | |:---:|:---:|:---:| | Install | Pair | 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

| Tool | Description | Mode | |------|-------------|------| | snowflake_list_databases | List all databases accessible to the account | Read | | snowflake_get_database | Get metadata for a specific database | Read | | snowflake_list_schemas | List all schemas in a database | Read | | snowflake_get_schema | Get metadata for a specific schema | Read |

Tables & Views

| Tool | Description | Mode | |------|-------------|------| | snowflake_list_tables | List all tables in a database and schema | Read | | snowflake_get_table | Get metadata for a specific table | Read | | snowflake_list_views | List all views in a database and schema | Read | | snowflake_get_view | Get the SQL definition of a view | Read | | snowflake_list_columns | List all columns in a table or view | Read | | snowflake_describe_table | Describe the structure of a table | Read |

Query Execution

| Tool | Description | Mode | |------|-------------|------| | snowflake_execute_query | Execute a raw SQL query and return results | Write | | snowflake_execute_statement | Execute a DDL or DML statement | Write |

Warehouses

| Tool | Description | Mode | |------|-------------|------| | snowflake_list_warehouses | List all warehouses | Read | | snowflake_get_warehouse | Get warehouse properties and status | Read | | snowflake_create_warehouse | Create a new warehouse | Write | | snowflake_suspend_warehouse | Suspend a warehouse | Write | | snowflake_resume_warehouse | Resume a suspended warehouse | Write |

Users & Roles

| Tool | Description | Mode | |------|-------------|------| | snowflake_list_users | List all users in the account | Read | | snowflake_get_user | Get user properties and grants | Read | | snowflake_list_roles | List all roles | Read | | snowflake_get_role_grants | List grants for a role | Read |

Stages & Files

| Tool | Description | Mode | |------|-------------|------| | snowflake_list_stages | List stages in a schema | Read | | snowflake_list_files_in_stage | List files in a named stage | Read | | snowflake_put_file | Upload a file to an internal stage | Write |

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

| Status / Error | Meaning | |----------------|---------| | Tool not found | The tool name does not exist in the current catalog. Verify with clawlink_list_tools --integration snowflake. | | Missing connection | Snowflake is not connected. Direct the user to https://claw-link.dev/dashboard?add=snowflake. | | Database not found | The specified database does not exist or is not accessible. | | Schema not found | The specified schema does not exist in the database. | | Table not found | The specified table does not exist. | | Warehouse not found | The warehouse name is incorrect or not accessible. | | Insufficient privileges | The connected account lacks the required role/privilege for this operation. | | Warehouse is suspended | Cannot execute queries on a suspended warehouse. Resume it first. | | SQL compilation error | Syntax error in the SQL query. Review and fix the SQL. | | Write rejected | User 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: 
    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

Powered by ClawLink — an integration hub for OpenClaw

ClawLink Logo