Actions35
- Genie Actions
- Databricks SQL Actions
- Unity Catalog Actions
- Model Serving Actions
- Files Actions
- Vector Search Actions
Overview
This node integrates with the Databricks platform, specifically providing operations related to the "Genie" resource among others. The "Execute Message SQL Query" operation under the Genie resource allows users to run SQL queries against a message identified by its ID, potentially including attachments. This is useful for scenarios where you want to programmatically query data stored or referenced within messages in Databricks Genie, such as extracting insights from message content or analyzing attached data.
Practical examples include:
- Running a SQL query on a specific message's data to retrieve structured information.
- Accessing and querying data from an attachment linked to a message.
- Automating data extraction workflows that involve message-based datasets in Databricks.
Properties
| Name | Meaning |
|---|---|
| Message ID | The unique identifier of the message on which the SQL query will be executed. |
| Attachment ID | The unique identifier of the attachment associated with the message (used when applicable). |
Output
The node outputs JSON data representing the results of the executed SQL query on the specified message or its attachment. The structure typically includes rows and columns corresponding to the query result set. If binary data is involved (e.g., attachments), it would be handled separately but this operation focuses on JSON output of query results.
Dependencies
- Requires an active connection to the Databricks API with appropriate authentication credentials (an API token).
- The node expects configuration of the Databricks host URL and an API token credential in n8n.
- No other external dependencies are indicated.
Troubleshooting
- Invalid Message ID or Attachment ID: Ensure the IDs provided exist and are accessible with the current credentials.
- Authentication Errors: Verify that the API token is valid and has sufficient permissions to access Genie resources.
- Query Execution Failures: Check the syntax of the SQL query being executed and ensure it is compatible with the Genie message data schema.
- Network Issues: Confirm connectivity to the configured Databricks host.
Common error messages might include authorization failures, resource not found errors, or malformed query exceptions. Resolving these typically involves verifying input parameters, credentials, and network settings.