Skip to main content
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
⌘I