To learn more, visit the Databricks documentation.

​
Parameters​

ParameterDescription
Service Principal IDThe 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

Was this page helpful?

List QueriesUpload File