Gets the information for a single SQL warehouse.
External DocumentationTo learn more, visit the Databricks documentation.

Parameters

ParameterDescription
Warehouse IDThe 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
Workflow LibraryPreview this Workflow on desktop