Gets a list of queries accessible to the user, ordered by creation time.

Note: Calling this API concurrently 10 or more times could result in throttling, service degradation, or a temporary ban.

External Documentation

To learn more, visit the Databricks documentation.

Parameters

ParameterDescription
Page SizeThe number of items to return per page. Valid range is 1-100.
Page TokenA token used for pagination, allowing you to retrieve data in batches.
Return All PagesAutomatically fetch all resources, page by page.

Example Output

{
	"next_page_token": "eDg",
	"results": [
		{
			"description": "Example description",
			"owner_user_name": "user@acme.com",
			"tags": [
				"Tag 1"
			],
			"display_name": "Example query 1",
			"id": "ae25e731-92f2-4838-9fb2-1ca364320a3d",
			"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"
		},
		{
			"description": "Example description",
			"owner_user_name": "user@acme.com",
			"tags": [
				"Tag 1"
			],
			"display_name": "Example query 2",
			"id": "be25e731-92f2-4838-9fb2-1ca364320a3d",
			"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

List Queries with Databricks and Send Results Via Email

Preview this Workflow on desktop