Gets a query by its ID.

External Documentation

To learn more, visit the Databricks documentation.

​
Parameters

ParameterDescription
Query IDThe ID of the query object to retrieve. Can be obtained via the List Queries action.

​
Example Output

{
	"description": "Example description",
	"owner_user_name": "user@acme.com",
	"tags": [
		"Tag 1"
	],
	"display_name": "Example query",
	"id": "fe25e731-92f2-4838-9fb2-1ca364320a3d",
	"parent_path": "/Workspace/Users/user@acme.com",
	"lifecycle_state": "ACTIVE",
	"last_modifier_user_name": "user@acme.com",
	"query_text": "SELECT 1",
	"parameters": [
		{
			"name": "foo",
			"text_value": {
				"value": "bar"
			},
			"title": "foo"
		}
	],
	"update_time": "2019-08-24T14:15:22Z",
	"warehouse_id": "a7066a8ef796be84",
	"run_as_mode": "OWNER",
	"create_time": "2019-08-24T14:15:22Z"
}

​
Workflow Library Example

Get Query with Databricks and Send Results Via Email

Preview this Workflow on desktop

Gets a query by its ID.

External Documentation

To learn more, visit the Databricks documentation.

​
Parameters

ParameterDescription
Query IDThe ID of the query object to retrieve. Can be obtained via the List Queries action.

​
Example Output

{
	"description": "Example description",
	"owner_user_name": "user@acme.com",
	"tags": [
		"Tag 1"
	],
	"display_name": "Example query",
	"id": "fe25e731-92f2-4838-9fb2-1ca364320a3d",
	"parent_path": "/Workspace/Users/user@acme.com",
	"lifecycle_state": "ACTIVE",
	"last_modifier_user_name": "user@acme.com",
	"query_text": "SELECT 1",
	"parameters": [
		{
			"name": "foo",
			"text_value": {
				"value": "bar"
			},
			"title": "foo"
		}
	],
	"update_time": "2019-08-24T14:15:22Z",
	"warehouse_id": "a7066a8ef796be84",
	"run_as_mode": "OWNER",
	"create_time": "2019-08-24T14:15:22Z"
}

​
Workflow Library Example

Get Query with Databricks and Send Results Via Email

Preview this Workflow on desktop