Warehouse
Create or replace warehouse¶
POST/api/v2/warehouses
Create a virtual warehouse. Equivalent to CREATE WAREHOUSE in SQL.
Query Parameters¶
Parameter | Description |
---|---|
createMode string | Query parameter allowing support for different modes of resource creation. Possible values include:
|
Response¶
Code | Description |
---|---|
200 | Successful request. |
202 |
List warehouse¶
GET/api/v2/warehouses
Show a list of warehouse filtered by pattern. Equivalent to SHOW WAREHOUSE in SQL.
Query Parameters¶
Parameter | Description |
---|---|
like string | Query parameter to filter the command output by resource name. Uses case-insensitive pattern matching, with support for SQL wildcard characters. |
Response¶
Code | Description |
---|---|
200 | successful |
202 | Successfully accepted the request, but it is not completed yet. |
Describe warehouse¶
Drop warehouse¶
DELETE/api/v2/warehouses/{name}
Removes the specified virtual warehouse from the system. Equivalent to DROP WAREHOUSE in SQL.
Query Parameters¶
Parameter | Description |
---|---|
ifExists boolean | Query parameter that specifies how to handle the request for a resource that does not exist:
|
Response¶
Code | Description |
---|---|
200 | |
202 |
Create a (or alter an existing) warehouse¶
PUT/api/v2/warehouses/{name}
Create a (or alter an existing) warehouse. Even if the operation is just an alter, the full property set must be provided.
Response¶
Code | Description |
---|---|
200 | |
202 |
Resume warehouse¶
POST/api/v2/warehouses/{name}:resume
Bring current warehouse to a usable ‘Running’ state by provisioning compute resources if current warehouse is suspended.
Response¶
Code | Description |
---|---|
200 | |
202 |
Suspend warehouse¶
POST/api/v2/warehouses/{name}:suspend
Remove all compute nodes from a warehouse and put the warehouse into a ‘Suspended’ state if current warehouse is not suspended.
Response¶
Code | Description |
---|---|
200 | |
202 |
Update and rename warehouse¶
POST/api/v2/warehouses/{name}:rename
Specifies a new identifier for the warehouse; must be unique for current account.
Response¶
Code | Description |
---|---|
200 | |
202 |
Abort all queries¶
POST/api/v2/warehouses/{name}:abort
Aborts all the queries currently running or queued on the warehouse.
Response¶
Code | Description |
---|---|
200 | |
202 |
Use current warehouse for session (Deprecated)¶
POST/api/v2/warehouses/{name}:use
[Deprecated] Specifies the active/current warehouse for the session.
Response¶
Code | Description |
---|---|
200 | |
202 |
enable adaptive warehouse¶
POST/api/v2/warehouses/{name}:enable
Enable an adaptive warehouse and put the warehouse into a ‘enabled’ state, if the warehouse is not enabled.
Response¶
Code | Description |
---|---|
200 | |
202 |
disable adaptive warehouse¶
POST/api/v2/warehouses/{name}:disable
Disable an adaptive warehouse and put the warehouse into a ‘disabled’ state, if the warehouse is not disabled.
Response¶
Code | Description |
---|---|
200 | |
202 |