Snowflake

Analytics & dataCredentials form

Run SQL in Snowflake through the SQL API, follow and cancel statements, and browse databases, schemas, tables and warehouses.

8 actions

Action	Effect	Data handled
snowflake_execute_statementRuns one SQL statement and returns the result set's metadata and first partition of rows, or a statement handle to poll with get_statement when it runs past the wait	write	Personal data
snowflake_get_statementGets the status of a statement and, once done, a partition of its result	read	Personal data
snowflake_cancel_statementCancels a running statement	write	General
snowflake_list_databasesLists the databases the role can see, optionally filtered by a name pattern	read	General
snowflake_list_schemasLists the schemas of a database, optionally filtered by a name pattern	read	General
snowflake_list_tablesLists the tables of a schema with their row counts, sizes and owners, optionally filtered by a name pattern	read	General
snowflake_get_tableDescribes a table: its columns with types, nullability and comments, and its clustering and retention settings	read	General
snowflake_list_warehousesLists warehouses with their size, state and auto-suspend settings	read	General

Sign-in

Also included

dexby.createSession({
  userId: customer.id,
  connectors: ['snowflake']
})