List Warehouses - BlinkOps Documentation

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

External DocumentationTo learn more, visit the Databricks documentation.

Parameters

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.

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

Preview this Workflow on desktop

List Queries Upload File

⌘I

​Parameters

​Example Output

​Workflow Library Example

Parameters

Example Output

Workflow Library Example