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

# List Warehouses

Lists all SQL warehouses that a user has `Manager` permissions on.

<Note>
  External Documentation

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

## Parameters

<div className="integrations-table">
  | 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. |
</div>

## Example Output

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