Skip to main content

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 PROD schema 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.

  1. Go to Organization > Connectors and find Snowflake. Click Enable, and choose which tools to allow.
  2. Create an OAuth application in the Snowflake developer portal.
  3. Add the Redirect URI shown in the connector settings to the application.
  4. Copy the application's Client ID and Client Secret into the connector, then save it.
  5. 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.

ToolWhat it does
describe_stageDescribe a stage to see its properties and file format settings.
describe_tableGet the structure and column definitions of a table.
execute_sql_readonlyExecute a read-only SQL statement in Snowflake (SELECT, WITH, SHOW, DESCRIBE, EXPLAIN, VALUES, LIST).
get_databaseGet details of a specific database.
get_query_resultsFetch results from a completed SQL query with pagination.
get_roleGet details of a specific role.
get_schemaGet details of a specific schema.
get_stageGet details of a specific stage.
get_statement_statusGet the status of an asynchronous SQL statement, including one that failed or was cancelled.
get_tableGet details of a specific table.
get_taskGet details of a specific task, including state, schedule and definition.
get_task_historyGet execution history for a task: recent runs with status, timing and errors.
get_userGet details of a specific user.
get_warehouseGet details of a specific warehouse.
list_databasesList databases in the account.
list_grantsList 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_rolesList roles in the account.
list_schemasList schemas in a database.
list_stage_filesList files in a stage.
list_stagesList stages in a schema.
list_tablesList tables in a schema.
list_tasksList tasks in a schema.
list_usersList users in the account.
list_warehousesList warehouses in the account.
validate_credentialValidate Snowflake credentials by executing a lightweight query.

Write (10)​

Create or send data.

ToolWhat it does
create_databaseCreate a new database in Snowflake.
create_roleCreate a new role in Snowflake.
create_schemaCreate a new schema in a database.
create_stageCreate a new stage for data loading/unloading.
create_tableCreate a new table in Snowflake.
create_taskCreate a new scheduled task in Snowflake.
create_userCreate a new user in Snowflake.
create_warehouseCreate a new virtual warehouse in Snowflake.
grant_privilegeGrant privileges to a role on a Snowflake object.
grant_roleGrant a role to a user or another role.

Delete or overwrite (25)​

Remove or replace existing data.

ToolWhat it does
alter_databaseAlter an existing database in Snowflake.
alter_schemaAlter an existing schema in Snowflake.
alter_tableAlter an existing table in Snowflake.
alter_taskAlter an existing task in Snowflake.
alter_userAlter an existing user in Snowflake.
alter_warehouseAlter an existing warehouse in Snowflake.
cancel_statementCancel a running SQL statement.
copy_into_locationUnload data from a table or query to a stage.
copy_into_tableLoad data from a stage into a table. table_name is database.schema.name, stage_name is @database.schema.stage.
drop_databaseDrop a database from Snowflake.
drop_roleDrop a role from Snowflake.
drop_schemaDrop a schema from a database.
drop_stageDrop a stage from Snowflake.
drop_tableDrop a table from Snowflake.
drop_taskDrop a task from Snowflake.
drop_userDrop a user from Snowflake.
drop_warehouseDrop a warehouse from Snowflake.
execute_sqlExecute a SQL statement in Snowflake (query, DDL, or DML).
execute_taskExecute a task immediately without waiting for schedule.
resume_taskResume a suspended task to start scheduled execution.
resume_warehouseResume a suspended warehouse.
revoke_privilegeRevoke privileges from a role on a Snowflake object.
revoke_roleRevoke a role from a user or another role.
suspend_taskSuspend a running task to stop scheduled execution.
suspend_warehouseSuspend a running warehouse to stop billing.
⌘J