List Virtual Warehouses.




List Virtual Warehouses.


--cluster-id <value>
[--filter <value>]
[--cli-input-json <value>]


--cluster-id (string)

ID of cluster to list.

--filter (object)

Filter object for Virtual Warehouses.

vwType -> (string)

Type of Virtual Warehouse: ‘hive’ or ‘impala’.

Shorthand Syntax:


JSON Syntax:

  "vwType": "hive"|"impala"

--cli-input-json (string)

Performs service operation based on the JSON string provided. The JSON string follows the format provided by --generate-cli-skeleton. If other arguments are provided on the command line, the CLI values will override the JSON-provided values.

--generate-cli-skeleton (boolean)

Prints a sample input JSON to standard output. Note the specified operation is not run if this argument is specified. The sample input can be used as an argument for --cli-input-json.


vws -> (array)

The list of Virtual Warehouses.

item -> (object)

A Virtual Warehouse.

crn -> (string)

The CRN of the Virtual Warehouse.

id -> (string)

The ID of the Virtual Warehouse.

name -> (string)

The name of the Virtual Warehouse.

vwType -> (string)

Type of Virtual Warehouse: ‘hive’ or ‘impala’.

dbcId -> (string)

ID of Database Catalog that the Virtual Warehouse is attached to.

status -> (string)

Status of the Virtual Warehouse.

creator -> (object)

A CDP actor (user or machine user).

crn -> (string)

Actor CRN.

email -> (string)

Email address for users.

workloadUsername -> (string)

Username for users.

machineUsername -> (string)

Username for machine users.

creationDate -> (datetime)

Creation date of Virtual Warehouse.

tags -> (array)

Tags associated with the resources.

item -> (object)

A key/value pair attached to some resources.

key -> (string)

The tag’s name.

value -> (string)

The associated value of the tag.

Form Factors

public, private