Skip to main content
HTTP API connector An HTTP API described by an OpenAPI spec, not an MCP server. Calls go to your Snowflake address (https://{account}.snowflakecomputing.com, filled in when connecting) and carry an API key as a bearer token in the Authorization header.

​
What the skill can do

API connector: 32 actions, as they appear in the skill panel. 21 of them create, change or delete something in Snowflake; mark those under These actions need approval when you add the skill to an agent.
  • Data discovery (6): List Tables, Describe Table, List Warehouses, List Databases, List Views, List Schemas
  • Object management (6): Undrop Database, Undrop Schema, Undrop Table, Clone Table, Create Database, Create Schema
  • Data loading (5): Refresh Pipe, Get Stage File Presigned Url, List Stages, List Stage Files, List Pipes
  • Destructive operations (4): Drop Table, Drop Schema, Drop Database, Drop Warehouse
  • Task operations (4): List Tasks, Execute Task, Resume Task, Suspend Task
  • Warehouse operations (4): Create Warehouse, Resume Warehouse, Suspend Warehouse, Abort All Queries
  • Sql statements (3): Execution Submit Statements For Execution, Statement Cancelation Cancel By Statement Handle, Statement Monitoring Get Status By Statement Handle

​
Authentication Options

​
Generate a Snowflake Programmatic Access Token

  1. Log in to your Snowflake account.
  2. Select Governance & security, then click Users & roles. Img 1
  3. Select a user to open the user’s page, scroll down to the Programmatic access tokens section, and click Generate token to open the New programmatic access token dialog. Img 2
  4. Enter a name for the new programmatic access token, set the expiry period and role, then click Generate to create the token.
  5. A new dialog will appear with the created token. Click Copy to clipboard and close to copy the generated token and store it somewhere safe. Img 3
If your Snowflake user does not have a network policy, you’ll need to create one to proceed. Follow Snowflake’s official instructions to create a new network policy.Alternatively, you can grant temporary access for your programmatic access token. To do that:
  1. Click the ellipsis icon next to the programmatic access token
  2. Select Bypass requirement for network policy in the dropdown that appears to open the Bypass Network Policy Requirement dialog. Img 4
  3. Specify a Bypass window and click Grant access to grant your programmatic access token temporary access. Img 5

​
Connect Snowflake in xpander

  1. In Xpander Chat, open the agent’s settings and click Add skill.
  2. Search for Snowflake and select it.
  3. Click + Create new connection.
  4. Enter a connection name, e.g., “xpander-snowflake”.
  5. Paste your Snowflake programmatic access token into the provided API Key field.
  6. Copy the base URL from your Snowflake web console, e.g., https://<account_identifier>.snowflakecomputing.com, and paste it into the Interface specific settings field.
  7. Save the configuration. Img 6

​
Give an agent the Snowflake skill

Once Snowflake is connected, any agent you can edit may be given the skill: open the agent’s settings, click Add skill, and choose Snowflake. The skill panel lists the Snowflake actions by group. Enable only the groups the agent needs, and mark the actions that should wait for a named person’s sign-off under These actions need approval. Which skills exist for your organization, and who may add them, is decided by your admins; see Skills.