List warehouse
GET {{baseUrl}}/api/v2/warehouses?like=<string>
Show a list of warehouse filtered by pattern. Equivalent to SHOW WAREHOUSE in SQL.
Request Params
| Key | Datatype | Required | Description |
|---|---|---|---|
like | string | Query parameter to filter the command output by resource name. Uses case-insensitive pattern matching, with support for SQL wildcard characters. |
HEADERS
| Key | Datatype | Required | Description |
|---|---|---|---|
Accept | string |
RESPONSES
status: OK
[{"name":"Bwv21D0ta7","warehouse_type":"\u003cstring\u003e","warehouse_size":"\u003cstring\u003e","wait_for_completion":"false","max_cluster_count":"\u003cinteger\u003e","min_cluster_count":"\u003cinteger\u003e","scaling_policy":"\u003cstring\u003e","auto_suspend":"\u003cinteger\u003e","auto_resume":"false","initially_suspended":"true","resource_monitor":"\"?\"\"\"\"D\"\"\"\"\"","comment":"\u003cstring\u003e","enable_query_acceleration":"false","query_acceleration_max_scale_factor":"\u003cinteger\u003e","max_concurrency_level":"\u003cinteger\u003e","statement_queued_timeout_in_seconds":"\u003cinteger\u003e","statement_timeout_in_seconds":"\u003cinteger\u003e","type":"\u003cstring\u003e","size":"\u003cstring\u003e","state":"\u003cstring\u003e","started_clusters":"\u003cinteger\u003e","running":"\u003cinteger\u003e","queued":"\u003cinteger\u003e","is_default":"\u003cboolean\u003e","is_current":"\u003cboolean\u003e","available":"\u003cstring\u003e","provisioning":"\u003cstring\u003e","quiescing":"\u003cstring\u003e","other":"\u003cstring\u003e","created_on":"\u003cdateTime\u003e","resumed_on":"\u003cdateTime\u003e","updated_on":"\u003cdateTime\u003e","owner":"\u003cstring\u003e","budget":"\u003cstring\u003e","kind":"\u003cstring\u003e","owner_role_type":"\u003cstring\u003e"},{"name":"\".\u0026b\"\"N\"\"!O5\"","warehouse_type":"\u003cstring\u003e","warehouse_size":"\u003cstring\u003e","wait_for_completion":"false","max_cluster_count":"\u003cinteger\u003e","min_cluster_count":"\u003cinteger\u003e","scaling_policy":"\u003cstring\u003e","auto_suspend":"\u003cinteger\u003e","auto_resume":"false","initially_suspended":"true","resource_monitor":"yKy_1bteSS","comment":"\u003cstring\u003e","enable_query_acceleration":"true","query_acceleration_max_scale_factor":"\u003cinteger\u003e","max_concurrency_level":"\u003cinteger\u003e","statement_queued_timeout_in_seconds":"\u003cinteger\u003e","statement_timeout_in_seconds":"\u003cinteger\u003e","type":"\u003cstring\u003e","size":"\u003cstring\u003e","state":"\u003cstring\u003e","started_clusters":"\u003cinteger\u003e","running":"\u003cinteger\u003e","queued":"\u003cinteger\u003e","is_default":"\u003cboolean\u003e","is_current":"\u003cboolean\u003e","available":"\u003cstring\u003e","provisioning":"\u003cstring\u003e","quiescing":"\u003cstring\u003e","other":"\u003cstring\u003e","created_on":"\u003cdateTime\u003e","resumed_on":"\u003cdateTime\u003e","updated_on":"\u003cdateTime\u003e","owner":"\u003cstring\u003e","budget":"\u003cstring\u003e","kind":"\u003cstring\u003e","owner_role_type":"\u003cstring\u003e"}]