Troubleshoot Databricks
Find solutions to common issues when reading and writing Databricks data directly from Agentic Workflows in Kizen.
Audience: Admins, Developers, Solution Architects
Purpose: Describes troubleshooting methods for issues with the Databricks integration
The following table presents solutions to common issues with the Databricks integration. For additional help, see the Databricks documentation.
You received an error message that reads: Expected a single value result, but the query returned multiple rows or columns.
The Return Single Value input flag of the Read Data action is yes, but the query selected more than one row or column.
Adjust your query to select exactly one value.
You received an error message that reads: Error while using Databricks Connection.
You have bad Databricks credentials.
Review the error message for more details. Update your integration secret.
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: Missing required key(s).
Your integration secret is missing one or more of the host, warehouse_id, and token keys.
Update your integration secret.
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 PAT has insufficient privileges.
Review the privileges, and assign the necessary ones.
You received the HTTP 404 Not Found status code.
The integration can't find the specified Databricks Utility Catalog or schema
Confirm the name of the Utility Catalog and schema.
Your API request failed.
The request exceeded your SQL Warehouse's capacity.
Reduce how often the Agentic Workflow runs, narrow results with LIMIT, or combine multiple lookups into a single query.
You received an empty string.
The query ran successfully but matched no rows.
This is expected behavior. An empty result returns "", not null.
You received no results for a large query.
The results set is larger than 25 MB.
Target your query with LIMIT.
What's Next
See Databricks for a high-level discussion about what the Databricks integration is and how it works.
Databricks and Unity Catalog are trademarks of Databricks, Inc. Delta Lake is a trademark of the Delta Lake project and its contributors. Kizen's Databricks integration is not affiliated with, sponsored by, or endorsed by Databricks, Inc. or the Delta Lake project.
Last updated
Was this helpful?