Snowflake Tools
Snowflake 是一个基于云的数据仓库，可在多个云环境中提供弹性扩展、安全的数据共享和 SQL 分析。
让 AI 智能体使用 Snowflake Tools
Aident Loadout 让 Claude Code、Codex、Cursor 和其他受支持的智能体调用 Snowflake Tools。可选择 16 个受支持的操作。 可在 Audit 中审核每次执行。
通过 Aident Vault 连接一次 Snowflake Tools。智能体无需获取底层凭证即可使用受支持的操作。
分类
Analytics Data价格与支付
- 价格
- 在 Loadout 中免费。使用个人连接的账号时，服务提供商可能收费。
- 统一支付
- 暂不支持。需要时请连接服务提供商账号。
包含的操作
- Snowflake Cancel Statement ExecutionCancels the execution of a running SQL statement. Use this action to stop a long-running query.
- Snowflake Check Statement StatusRetrieves the status and results of a previously submitted SQL statement using its statement handle. Use this to poll async queries submitted via SNOWFLAKE_SUBMIT_SQL_STATEMENT; call repeatedly until status is no longer pending. Use SNOWFLAKE_CANCEL_STATEMENT to abort a hanging…
- Snowflake Drop WarehouseDrops (permanently deletes) a warehouse in Snowflake. This operation is irreversible — once a warehouse is dropped, it cannot be recovered. Use this action when you need to permanently remove a warehouse that is no longer needed. Requires OWNERSHIP privilege on the warehouse.
- Snowflake Execute SqlExecute SQL statements in Snowflake and retrieve results. Supports SELECT queries for data retrieval, DDL statements (CREATE, ALTER, DROP) for schema management, and DML statements (INSERT, UPDATE, DELETE) for data modification. Returns comprehensive result metadata including co…
- Snowflake Fetch Catalog IntegrationRetrieves detailed configuration and metadata for a specific catalog integration. Catalog integrations allow Snowflake to connect to external Apache Iceberg catalogs (AWS Glue, Snowflake Open Catalog/Polaris, or Apache Iceberg REST catalogs) to query Iceberg tables managed by th…
- Snowflake Get Active Scheduled MaintenancesRetrieves a list of any active scheduled maintenances currently in the In Progress or Verifying state.
- Snowflake Get All Scheduled MaintenancesRetrieves a list of the 50 most recent scheduled maintenances, including those in the Completed state.
- Snowflake Get Component StatusRetrieves the status of individual components, each listed with its current status.
- Snowflake Get Status RollupRetrieves the status rollup for the entire page, including indicators and human-readable descriptions of the blended component status.
- Snowflake Get Status SummaryRetrieves the current status summary from Snowflake's public status page (status.snowflake.com). Returns overall system status, operational status of all regional components (AWS, Azure, GCP regions), any unresolved incidents, and upcoming or in-progress scheduled maintenances.…
- Snowflake Get Unresolved IncidentsRetrieves a list of any unresolved incidents from the Snowflake status page. This endpoint returns incidents currently in the Investigating, Identified, or Monitoring state. Returns an empty list if there are no active incidents. This is a public status page API that does not re…
- Snowflake Get Upcoming Scheduled MaintenancesRetrieves upcoming scheduled maintenances from Snowflake's public status page. This action queries the Snowflake status API to get a list of any scheduled maintenance events that are still in the 'Scheduled' state (not yet started or completed). The response includes maintenance…
- Snowflake Show DatabasesLists all databases for which you have access privileges. Shows database metadata including name, creation date, owner, retention time, and more. Can filter results and include dropped databases within Time Travel retention period.
- Snowflake Show SchemasLists all schemas for which you have access privileges. Shows schema metadata including name, creation date, owner, database, retention time, and more. Can filter results and include dropped schemas within Time Travel retention period.
- Snowflake Show TablesLists all tables for which you have access privileges. Shows table metadata including name, creation date, owner, database, schema, row count, size in bytes, clustering keys, and more. Can filter results and include dropped tables within Time Travel retention period.
- Snowflake Validate CredentialValidates Snowflake credentials by executing a lightweight test query. Returns session information if credentials are valid, or error details if authentication fails. Use this action when you need to verify that API credentials are properly configured and have access to the Snow…