> ## 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.

# Get Warehouse

Gets the information for a single SQL warehouse.

<Note>
  External Documentation

  To learn more, visit the [Databricks documentation](https://docs.databricks.com/api/workspace/warehouses/get).
</Note>

## Parameters

<div className="integrations-table">
  | Parameter    | Description                                                                                |
  | ------------ | ------------------------------------------------------------------------------------------ |
  | Warehouse ID | The ID of the SQL warehouse to retrieve. Can be obtained via the `List Warehouses` action. |
</div>

## Example Output

```json theme={"dark"}
{
	"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](https://library.blinkops.com/workflows/get-warehouse-with-databricks-and-send-results-via-email)

<div className="iframe-wrapper">
  <div className="iframe-media">
    <img src="https://mintcdn.com/blinkops-2/ojHYuDeYX5FWuN8a/img/Icons/play-box.svg?fit=max&auto=format&n=ojHYuDeYX5FWuN8a&q=85&s=b8af968e71438a9499c3223c9bd29fb2" alt="Workflow Library" width="16" height="16" data-path="img/Icons/play-box.svg" />

    Preview this Workflow on desktop
  </div>

  <iframe className="iframe" src="https://library.blinkops.com/workflows/get-warehouse-with-databricks-and-send-results-via-email/canvas" />
</div>