Connect Hermes to Snowflake
Give your Hermes agent access to Snowflake in Melso — 16 tools it can call while it works through a task.
Set it up in Melso
- 1In Melso, open Settings → Agent Apps and hit Connect on Snowflake.
- 2Finish the OAUTH2 sign-in in the window that opens. Melso stores the connection, not your credentials.
- 3Open your Hermes agent, go to its Agent Apps tab, and allow Snowflake.
- 4Give the agent a task. It calls Snowflake itself when the work needs it.
What Snowflake gives your agent
The tools, permissions, and events Snowflake exposes — the same ones your agent can use once the app is authorized.
What you sign in with
Snowflake connects with OAUTH2.
- Client id
- Client secret
Permissions
Tools Snowflake exposes
Cancel Statement Execution
Cancels the execution of a running SQL statement. Use this action to stop a long-running query.
Check Statement Status
Retrieves 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 query.
Drop Warehouse
Drops (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.
Execute SQL
Execute 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 column types, row counts, and execution status. Unquoted SQL identifiers are auto-uppercased by Snowflake — use matching case in `database`, `schema_name`, `warehouse`, and `role` parameters to avoid 'object not found' errors. Always apply explicit time-range filters and a LIMIT clause to unbounded SELECT queries to prevent large, slow result sets.
Fetch Catalog Integration
Retrieves 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 those external systems.
Get Active Scheduled Maintenances
Retrieves a list of any active scheduled maintenances currently in the In Progress or Verifying state.
Get All Scheduled Maintenances
Retrieves a list of the 50 most recent scheduled maintenances, including those in the Completed state.
Get Component Status
Retrieves the status of individual components, each listed with its current status.