Troubleshoot Snowflake
Audience: Admins, Developers, Solution Architects
Purpose: Describes troubleshooting methods for issues with the Snowflake integration
The following table presents solutions to common issues with the Snowflake integration. For additional help, see the Snowflake documentation.
Your Snowflake connection failed.
The integration is misconfigured.
Check your configuration. Confirm that you have allowlisted Kizen's egress IP addresses.
You received an error message that reads: Error while using Snowflake Plugin.
You have bad Snowflake credentials or an invalid query.
Review the error message for more details. Update your integration secret or query, and retry.
You received an error message that reads: Error decoding JSON.
Your integration secret isn't valid JSON.
Update your integration secret.
You received an error message that reads: Expected a single value result, but the query returned multiple rows or columns.
The Return Single Value script input of the Read Data action is true, but the query selected more than one row or column.
Adjust your query to select exactly one value.
You received the HTTP 401 Unauthorized status code.
Your PAT is bad or expired.
Generate a new PAT.
You received the HTTP 403 Forbidden status code.
Your user or service account has insufficient privileges.
Review the privileges, and assign the necessary ones.
You received the HTTP 404 Not Found status code.
Your Snowflake account isn't valid.
Confirm your Snowflake account.
You received an empty string.
The query ran successfully but matched no rows.
This is expected behavior. An empty result returns "", not null.
Your result string is truncated.
The result set is larger than 5 MB.
Target your query with LIMIT.
What's Next
For details on reviewing your Snowflake configuration and integration secret, see Enable Snowflake in Kizen. To access your database query, see Add Snowflake Data to an Agentic Workflow.
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?