Skip to main content
Lists all SQL warehouses that a user has Manager permissions on.
External DocumentationTo 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
Workflow LibraryPreview this Workflow on desktop
⌘I