Get Warehouse

Gets the information for a single SQL warehouse.

External Documentation

To learn more, visit the Databricks documentation.

Parameters

Parameter	Description
Warehouse ID	The ID of the SQL warehouse to retrieve. Can be obtained via the List Warehouses action.

Example Output

{
    "id": "string",
    "name": "string",
    "cluster_size": "string",
    "min_num_clusters": "1",
    "max_num_clusters": 0,
    "auto_stop_mins": "120",
    "creator_name": "string",
    "instance_profile_arn": "string",
    "tags": {
        "custom_tags": [
            {
                "key": "string",
                "value": "string"
            }
        ]
    },
    "spot_instance_policy": "POLICY_UNSPECIFIED",
    "enable_photon": true,
    "channel": {
        "name": "CHANNEL_NAME_UNSPECIFIED",
        "dbsql_version": "string"
    },
    "enable_serverless_compute": true,
    "warehouse_type": "TYPE_UNSPECIFIED",
    "num_clusters": 0,
    "num_active_sessions": 0,
    "state": "STARTING",
    "jdbc_url": "string",
    "odbc_params": {
        "hostname": "string",
        "path": "string",
        "protocol": "string",
        "port": 0
    },
    "health": {
        "status": "STATUS_UNSPECIFIED",
        "message": "string",
        "failure_reason": {
            "code": "UNKNOWN",
            "type": "SUCCESS",
            "parameters": {
                "property1": "string",
                "property2": "string"
            }
        },
        "summary": "string",
        "details": "string"
    }
}

Workflow Library Example

Get Warehouse with Databricks and Send Results Via Email

Preview this Workflow on desktop