Enable Snowflake in Kizen
Overview
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
USAGEprivileges on the target warehouse and database and read or write privileges on the target database tables as neededOrg Admin access in Kizen
Enable Snowflake in Kizen
To enable Snowflake in Kizen:
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.
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:
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
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.
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.
Last updated
Was this helpful?


