Create Query

Creates a query.

External Documentation

To learn more, visit the Databricks documentation.

Basic Parameters

Parameter	Description
Description	General description that conveys additional information about this query such as usage notes.
Display Name	Display name of the query that appears in list views, widget headings, and on the query page.
Parent Path	Workspace path of the workspace folder containing the object. For example: /Users/user@acme.com.
Query	The query to be run. For example: SELECT 1.
Run Mode	Sets the "Run as" role for the object.
Warehouse ID	The ID of the SQL warehouse attached to the query. Can be obtained via the List Warehouses action.

Advanced Parameters

Parameter	Description
Apply Auto Limit	Whether to apply a 1000 row limit to the query result.
Catalog	Name of the catalog where this query will be executed.
Query Parameters	List of query parameter definitions. For further information, please refer to Databricks Documentation. For example: <br/>[<br/> {<br/> "name": "foo",<br/> "text_value": {<br/> "value": "bar"<br/> },<br/> "title": "foo"<br/> }<br/>]<br/>
Schema	Name of the schema where this query will be executed.
Tags	A comma separated list of tags.

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"
        }
    ],
    "warehouse_id": "a7066a8ef796be84",
    "run_as_mode": "OWNER",
    "create_time": "2019-08-24T14:15:22Z"
}

Workflow Library Example

Create Query with Databricks and Send Results Via Email

Preview this Workflow on desktop