Create or replace warehouse
POST {{baseUrl}}/api/v2/warehouses?createMode=errorIfExists
Create a virtual warehouse. Equivalent to CREATE WAREHOUSE in SQL.
Request Params
Key | Datatype | Required | Description |
---|---|---|---|
createMode | string | Query parameter allowing support for different modes of resource creation. Possible values include: |
errorIfExists
: Throws an error if you try to create a resource that already exists.orReplace
: Automatically replaces the existing resource with the current one.ifNotExists
: Creates a new resource when an alter is requested for a non-existent resource. |
Request Body
{"name"=>"\"\"\"\"\"\"\"\"\"\"\"jJ\"\"\"", "warehouse_type"=>"<string>", "warehouse_size"=>"<string>", "wait_for_completion"=>"false", "max_cluster_count"=>"<integer>", "min_cluster_count"=>"<integer>", "scaling_policy"=>"<string>", "auto_suspend"=>"<integer>", "auto_resume"=>"false", "initially_suspended"=>"false", "resource_monitor"=>"\"=g`J3\"\"n9]\"", "comment"=>"<string>", "enable_query_acceleration"=>"false", "query_acceleration_max_scale_factor"=>"<integer>", "max_concurrency_level"=>"<integer>", "statement_queued_timeout_in_seconds"=>"<integer>", "statement_timeout_in_seconds"=>"<integer>", "type"=>"<string>", "size"=>"<string>", "state"=>"<string>", "started_clusters"=>"<integer>", "running"=>"<integer>", "queued"=>"<integer>", "is_default"=>"<boolean>", "is_current"=>"<boolean>", "available"=>"<string>", "provisioning"=>"<string>", "quiescing"=>"<string>", "other"=>"<string>", "created_on"=>"<dateTime>", "resumed_on"=>"<dateTime>", "updated_on"=>"<dateTime>", "owner"=>"<string>", "budget"=>"<string>", "kind"=>"<string>", "owner_role_type"=>"<string>"}
HEADERS
Key | Datatype | Required | Description |
---|---|---|---|
Content-Type | string | ||
Accept | string |
RESPONSES
status: OK
{"status":"\u003cstring\u003e"}