Databricks icon

Databricks

Interact with Databricks API

Genie → Get Query Results

AI-generated

Overview

The node interacts with the Databricks Genie API to retrieve query results from a specific message attachment within a conversation in a Genie space. This operation is useful for workflows that need to programmatically access the results of queries executed in Genie, enabling automation of data retrieval and further processing based on those results.

Use Case Examples

  1. Retrieve query results from a message attachment in a Genie conversation to analyze data automatically.
  2. Use the query results in subsequent workflow steps for reporting or triggering alerts based on data insights.

Properties

Name Meaning
Space ID The ID of the Genie space where the conversation is located.
Conversation ID The ID of the conversation within the Genie space.
Message ID The ID of the message containing the attachment with the query results.
Attachment ID The ID of the message attachment that holds the query results.

Output

JSON

  • json - The JSON response containing the query results retrieved from the specified message attachment in the Genie conversation.

Dependencies

  • Databricks API with Genie access, requiring an API token for authentication.

Troubleshooting

  • Ensure that the Space ID, Conversation ID, Message ID, and Attachment ID are correctly specified and correspond to existing entities in the Genie space.
  • API errors may occur if the authentication token is invalid or expired; verify credentials.
  • Network errors can happen if the Databricks API endpoint is unreachable; check network connectivity.
  • If the query results are not found, confirm that the message attachment ID is correct and that the query has been executed successfully in Genie.

Links

Discussion