Snowflake
Comprehensive Snowflake connector for managing databases, schemas, tables, warehouses, users, roles, stages, tasks, and executing SQL queries.
Categories: Data Warehouse, Analytics, Database
What you can ask
- Run a query to count signups by source over the last 30 days from
ANALYTICS.EVENTS. - List the largest tables in the
PRODschema by row count. - Show queries from the last 24 hours that scanned more than 1TB.
Set up
Snowflake needs an OAuth application from your organization before anyone can connect. An organization admin completes these steps once.
- Go to Organization > Connectors and find Snowflake. Click Enable, and choose which tools to allow.
- Create an OAuth application in the Snowflake developer portal.
- Add the Redirect URI shown in the connector settings to the application.
- Copy the application's Client ID and Client Secret into the connector, then save it.
- Each member connects their own account the first time they use it.
⚠️ Warning: Do not enter your Devs.ai or Snowflake login email or password in the OAuth application fields.
To use one account for the whole organization, turn on Share one connection with everyone. Every member's agents then act as that account, with exactly the access it has.
Tools
Snowflake offers 60 tools. Admins choose which ones agents can use. See Tool permission groups.
Read (25)
View and search information without changing it.
| Tool | What it does |
|---|---|
describe_stage | Describe a stage to see its properties and file format settings. |
describe_table | Get the structure and column definitions of a table. |
execute_sql_readonly | Execute a read-only SQL statement in Snowflake (SELECT, WITH, SHOW, DESCRIBE, EXPLAIN, VALUES, LIST). |
get_database | Get details of a specific database. |
get_query_results | Fetch results from a completed SQL query with pagination. |
get_role | Get details of a specific role. |
get_schema | Get details of a specific schema. |
get_stage | Get details of a specific stage. |
get_statement_status | Get the status of an asynchronous SQL statement, including one that failed or was cancelled. |
get_table | Get details of a specific table. |
get_task | Get details of a specific task, including state, schedule and definition. |
get_task_history | Get execution history for a task: recent runs with status, timing and errors. |
get_user | Get details of a specific user. |
get_warehouse | Get details of a specific warehouse. |
list_databases | List databases in the account. |
list_grants | List grants: what a role holds (role), what roles a user has (user), what is granted on an object (object_name with object_type), or future grants on a container (future=true, object_name with object_type DATABASE or SCHEMA). |
list_roles | List roles in the account. |
list_schemas | List schemas in a database. |
list_stage_files | List files in a stage. |
list_stages | List stages in a schema. |
list_tables | List tables in a schema. |
list_tasks | List tasks in a schema. |
list_users | List users in the account. |
list_warehouses | List warehouses in the account. |
validate_credential | Validate Snowflake credentials by executing a lightweight query. |
Write (10)
Create or send data.
| Tool | What it does |
|---|---|
create_database | Create a new database in Snowflake. |
create_role | Create a new role in Snowflake. |
create_schema | Create a new schema in a database. |
create_stage | Create a new stage for data loading/unloading. |
create_table | Create a new table in Snowflake. |
create_task | Create a new scheduled task in Snowflake. |
create_user | Create a new user in Snowflake. |
create_warehouse | Create a new virtual warehouse in Snowflake. |
grant_privilege | Grant privileges to a role on a Snowflake object. |
grant_role | Grant a role to a user or another role. |
Delete or overwrite (25)
Remove or replace existing data.
| Tool | What it does |
|---|---|
alter_database | Alter an existing database in Snowflake. |
alter_schema | Alter an existing schema in Snowflake. |
alter_table | Alter an existing table in Snowflake. |
alter_task | Alter an existing task in Snowflake. |
alter_user | Alter an existing user in Snowflake. |
alter_warehouse | Alter an existing warehouse in Snowflake. |
cancel_statement | Cancel a running SQL statement. |
copy_into_location | Unload data from a table or query to a stage. |
copy_into_table | Load data from a stage into a table. table_name is database.schema.name, stage_name is @database.schema.stage. |
drop_database | Drop a database from Snowflake. |
drop_role | Drop a role from Snowflake. |
drop_schema | Drop a schema from a database. |
drop_stage | Drop a stage from Snowflake. |
drop_table | Drop a table from Snowflake. |
drop_task | Drop a task from Snowflake. |
drop_user | Drop a user from Snowflake. |
drop_warehouse | Drop a warehouse from Snowflake. |
execute_sql | Execute a SQL statement in Snowflake (query, DDL, or DML). |
execute_task | Execute a task immediately without waiting for schedule. |
resume_task | Resume a suspended task to start scheduled execution. |
resume_warehouse | Resume a suspended warehouse. |
revoke_privilege | Revoke privileges from a role on a Snowflake object. |
revoke_role | Revoke a role from a user or another role. |
suspend_task | Suspend a running task to stop scheduled execution. |
suspend_warehouse | Suspend a running warehouse to stop billing. |