Databricks icon

Databricks

Interact with Databricks API

Actions33

Genie → Execute Message SQL Query

AI-generated

Overview

This node operation interacts with the Databricks Genie API to execute a SQL query associated with a specific message attachment within a conversation in a Genie space. It is useful for scenarios where users want to programmatically run SQL queries embedded in messages and retrieve the results directly from Databricks Genie, enabling automation of data querying and analysis workflows within conversational contexts.

Use Case Examples

  1. Executing a SQL query attached to a message in a Genie conversation to fetch data insights.
  2. Automating the retrieval of query results from a message attachment in a Genie space for reporting or further processing.

Properties

Name Meaning
Space ID The ID of the Genie space where the conversation and message exist.
Conversation ID The ID of the conversation containing the message to query.
Message ID The ID of the message that contains the SQL query attachment to execute.
Attachment ID The ID of the message attachment that holds the SQL query to be executed.

Output

JSON

  • json - The JSON response from the Genie API containing the results of the executed SQL query.

Dependencies

  • Databricks API with Genie access
  • An API authentication token (Bearer token) for Databricks

Troubleshooting

  • Ensure that the Space ID, Conversation ID, Message ID, and Attachment ID are correctly provided and correspond to existing entities in the Genie space.
  • Check that the API token used for authentication has sufficient permissions to access the Genie space and execute queries.
  • If the API returns errors, verify the correctness of the SQL query in the message attachment and the availability of the Genie service.
  • Network errors or timeouts may occur; ensure stable network connectivity and retry if necessary.

Links

Discussion