rocketkind
Databases

Snowflake

Snowflake is a cloud data platform.

Authentication

  • Key pair
  • Programmatic access token

Actions

Generic API request. Call any Snowflake REST API endpoint on this connection - databases, warehouses, schemas, tables, network policies, tags or future grants - for the case where no shipped action covers it yet. The connection supplies the base URL, the authentication and the egress route, so only the path, query and body are yours to…

  • Cancel statementDestructiveStop a running statement - one that is taking too long, or whose result is no longer needed.
  • Create or alter userDestructiveBring a user to exactly the properties given, creating it if it does not exist.
  • Create userCreate a Snowflake user - the provisioning half of a joiner workflow.
  • Delete userDestructiveDrop a user - the end of a leaver workflow, once the account has been disabled for any retention period.
  • Execute statementDestructiveRun a SQL statement - a query, DML or DDL - in Snowflake and get its first partition of results.
  • Get statementCheck on a statement Execute statement or Run a query started, and read its results: 202 while it is still running, 200 with a partition of rows once it finishes, 422 if it failed.
  • Get userRead one user's properties: names, email, type, whether it is disabled, its defaults, whether it has a password or a key, and when it last signed in.
  • Grant role to userDestructiveGrant a role to a user - how a joiner's birthright access and an approved access request are fulfilled in Snowflake.
  • List rolesList the account's roles, with how many users and roles each is granted to - to pick the roles a joiner should get, or review who holds a sensitive one.
  • List user's rolesList the roles granted directly to a user - for an access review, or to find what a mover should lose.
  • List usersList the account's users with their names, email, type, default role and whether they are disabled - to reconcile Snowflake access against the source of truth.
  • Revoke role from userDestructiveRevoke a role from a user - how a mover loses their old access and an expired grant is taken back.
  • Run a queryRun one read-only statement in Snowflake - SELECT, WITH ...

Product names, logos and brands are the property of their respective owners and are used here for identification only. Their use does not imply endorsement by, or affiliation with, those owners.