genie_message_attachments

Creates, updates, deletes, gets or lists a genie_message_attachments resource.

Overview

Name	genie_message_attachments
Type	Resource
Id	databricks_workspace.dashboards.genie_message_attachments

Fields

The following fields are returned by SELECT queries:

get_query_result

Name	Datatype	Description
statement_response	string

Methods

The following methods are available for this resource:

Name	Accessible by	Required Params	Optional Params	Description
get_query_result	select	space_id, conversation_id, message_id, attachment_id, deployment_name		Get the result of SQL query if the message has a query attachment. This is only available if a message
execute_attachment_query	exec	space_id, conversation_id, message_id, attachment_id, deployment_name		Execute the SQL for a message query attachment. Use this API when the query attachment has expired and

Parameters

Parameters can be passed in the WHERE clause of a query. Check the Methods section to see which parameters are required or optional for each operation.

Name	Datatype	Description
attachment_id	string	Attachment ID
conversation_id	string	Conversation ID
deployment_name	string	The Databricks Workspace Deployment Name (default: dbc-abcd0123-a1bc)
message_id	string	Message ID
space_id	string	Genie space ID

SELECT examples

get_query_result

Get the result of SQL query if the message has a query attachment. This is only available if a message

SELECT
statement_response
FROM databricks_workspace.dashboards.genie_message_attachments
WHERE space_id = '{{ space_id }}' -- required
AND conversation_id = '{{ conversation_id }}' -- required
AND message_id = '{{ message_id }}' -- required
AND attachment_id = '{{ attachment_id }}' -- required
AND deployment_name = '{{ deployment_name }}' -- required
;

Lifecycle Methods

execute_attachment_query

Execute the SQL for a message query attachment. Use this API when the query attachment has expired and

EXEC databricks_workspace.dashboards.genie_message_attachments.execute_attachment_query 
@space_id='{{ space_id }}' --required, 
@conversation_id='{{ conversation_id }}' --required, 
@message_id='{{ message_id }}' --required, 
@attachment_id='{{ attachment_id }}' --required, 
@deployment_name='{{ deployment_name }}' --required
;