Documentation Index
Fetch the complete documentation index at: https://docs.blinkops.com/llms.txt
Use this file to discover all available pages before exploring further.
Lists all SQL warehouses that a user has Manager permissions on.
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
