Enable Snowflake in Kizen

Audience: Admins, Developers, Solution Architects

Purpose: Explains how to configure the Snowflake integration to use live Snowflake data in Agentic Workflows

Overview

Caution: This setup reflects Kizen's default configuration. Your administrator may have customized your layout, so columns or navigation may appear differently. Trial accounts may have limited features.

To use Snowflake data in Agentic Workflows, you must first enable the Snowflake integration in Kizen.

---

Before You Begin

Before you enable the Snowflake integration, ensure you have:

• A Snowflake user or service account with a warehouse that has the Snowflake SQL API and the auto-resume feature turned on
• A Snowflake role with USAGE privileges on the target warehouse and database and read or write privileges on the target database tables as needed
• Org Admin access in Kizen

---

Enable Snowflake in Kizen

To enable Snowflake in Kizen:

1

Generate a Programmatic Access Token

In Snowflake, run the following ALTER USER statement against your user or service account to generate a Programmatic Access Token (PAT) for this account:

USE ROLE ACCOUNTADMIN; -- or SECURITYADMIN
ALTER USER user_name ADD PROGRAMMATIC ACCESS TOKEN my_api_token
    DAYS_TO_EXPIRY = 90
    COMMENT = 'For the Kizen Snowflake integration';

Save the PAT securely, and keep it on hand for Step 5 of this procedure.

Note: Your PAT expires in 90 days. Plan to generate a new one before this one lapses.

2

Allowlist Kizen's egress IP addresses

Add Kizen's egress IPs to the allowlist of your Snowflake network policy, if you use one.

For the current list of egress IPs, contact your Kizen representative.

Note: If you haven't set up a network policy in Snowflake, we strongly encourage you to do so now for improved security and inbound access control. For instructions, see the Snowflake documentation.

3

Go to the App Marketplace

In Kizen, go to the global navigation, and select Platform > App Marketplace.

4

Turn on the Snowflake Connection

Find the Snowflake Connection card, and turn on the slider.

The Update Integration Secret modal appears.

Note: If the Update Integration Secret modal doesn't automatically open when you turn on the slider, select Manage Secrets in the Snowflake Connection card. Then, in the list of integration secrets that appears, edit the secret for the Snowflake connection.

5

Enter your Snowflake connection credentials

In the Integration Secret field of the modal, enter your Snowflake connection credentials as a JSON object. The JSON object must contain account, warehouse, schema, and pat keys, like this:

{
  "account": "account_id",
  "warehouse": "DATA_WH",
  "schema": "PUBLIC",
  "pat": "pat_token"
}

Store multiple environments as nested JSON objects:

{
  "production_db": {
    "account": "account_id",
    "warehouse": "DATA_WH",
    "schema": "PUBLIC",
    "pat": "pat_token"
  },
  "staging_db": {
    "account": "account_id",
    "warehouse": "DATA_WH",
    "schema": "PUBLIC",
    "pat": "pat_token"
  }
}

For descriptions of the keys, see the following table:

Key	Type	Description
account	String	The ID of your Snowflake account
warehouse	String	The target warehouse
schema	String	The default schema, or the schema to use when a query references a table without specifying a schema
pat	String	Your Programmatic Access Token string

Note: ​Kizen hides your secret once you submit it, so you can't append a new environment to an existing secret. You must re-enter the credentials for all your environments along with the new one. Consider keeping a secure record of each environment's connection details outside of Kizen so you can refer to the full set whenever you add a new environment.

6

Save the integration secret

Select Save.

---

What's Next

Now that you've set up the Snowflake integration, you're ready to use the Read Data and Write Data actions in Agentic Workflows. Continue to Add Snowflake Data to an Agentic Workflow to learn how.

Related Topics

• Snowflake
• Add Snowflake Data to an Agentic Workflow
• Troubleshoot Snowflake

---

Snowflake and all other Snowflake product, feature, and service names mentioned herein are registered trademarks or trademarks of Snowflake Inc. in the United States and other countries. Kizen's Snowflake integration is not affiliated with, sponsored by, or endorsed by Snowflake Inc.