Skip to main content

​
About Snowflake

Snowflake is a cloud-based data platform designed for modern analytics, AI applications, and large-scale data engineering. It enables developers, data teams, and intelligent agents to store, process, and analyze massive datasets using a unified, fully cloud-native data warehouse architecture. Snowflake offers advanced capabilities such as data sharing, secure collaboration, and workload isolation through virtual warehouses, along with native support for modern data engineering and machine learning pipelines. These features allow teams to run concurrent analytical queries, ingest streaming or batch data, and securely share datasets across organizations, all while maintaining high performance and scalability.

​
Authentication Options

Below are possible authentication options you can choose:

​
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

​
Integrate Snowflake into xpander.ai

  1. Go to the Agentic Connectors section in the sidebar of your xpander.ai dashboard.
  2. Select Snowflake from the available integrations.
  3. Click + Create new connection.
  4. Enter a connector name as desired, 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

​
Integration of Snowflake into an AI Agent

Once you’ve configured your Snowflake connector with the authentication option(s) described above, you can integrate it into your AI agent with xpander.ai:
  1. In your xpander.ai dashboard, navigate to the Agents page, select an agent and click Edit on the agent page to open the Agent Configuration tab.
  2. Select Tools, then click Add Tools.
  3. Select Connectors.
  4. Choose Snowflake with the same connector name you configured in the previous section (e.g., xpander-snowflake).
  5. Select the available Snowflake operations that suit your use case. To grant your agent database management capabilities, enable the following operations.
    • Submit SQL Statements For Execution
    • Get Statement Status by Handle
    • Cancel Statement by Handle
Img 7

​
AI Agent Snowflake Prompt Library

Below are possible prompts or use cases you can try after integrating Snowflake into your xpander.ai AI agent: 
List my databases.

Add a <schema_name> to my <database_name> database.

Add a <table_name> with the following columns <table_columns> to the <schema_name> schema belonging to the <database_name> database.

Return all rows in the <table_name> table in the <schema_name> schema belonging to the <database_name> database.
Gif 1