List Warehouses

Lists all SQL warehouses that a user has Manager permissions on.

External Documentation

To learn more, visit the Databricks documentation.

Parameters

Parameter	Description
Service Principal ID	The Service Principal ID used to fetch the list of warehouses. If not specified, the user from the connection is used.

Example Output

{
    "warehouses": [
        {
            "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

List Warehouses with Databricks and Send Results Via Email

Preview this Workflow on desktop