Skip to main content

List Queries

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

Workflow LibraryPreview this Workflow on desktop