Welcome to Pulumi Registry, your window into the cloud. Read the announcement.

Snowflake

v0.2.1 published on Monday, Sep 27, 2021 by Pulumi

Warehouse

Import

 $ pulumi import snowflake:index/warehouse:Warehouse example warehouseName

Example Usage

using Pulumi;
using Snowflake = Pulumi.Snowflake;

class MyStack : Stack
{
    public MyStack()
    {
        var warehouse = new Snowflake.Warehouse("warehouse", new Snowflake.WarehouseArgs
        {
            Comment = "foo",
            WarehouseSize = "small",
        });
    }

}
package main

import (
	"github.com/pulumi/pulumi-snowflake/sdk/go/snowflake"
	"github.com/pulumi/pulumi/sdk/v3/go/pulumi"
)

func main() {
	pulumi.Run(func(ctx *pulumi.Context) error {
		_, err := snowflake.NewWarehouse(ctx, "warehouse", &snowflake.WarehouseArgs{
			Comment:       pulumi.String("foo"),
			WarehouseSize: pulumi.String("small"),
		})
		if err != nil {
			return err
		}
		return nil
	})
}
import pulumi
import pulumi_snowflake as snowflake

warehouse = snowflake.Warehouse("warehouse",
    comment="foo",
    warehouse_size="small")
import * as pulumi from "@pulumi/pulumi";
import * as snowflake from "@pulumi/snowflake";

const warehouse = new snowflake.Warehouse("w", {
    comment: "foo",
    warehouseSize: "small",
});

Create a Warehouse Resource

new Warehouse(name: string, args?: WarehouseArgs, opts?: CustomResourceOptions);
@overload
def Warehouse(resource_name: str,
              opts: Optional[ResourceOptions] = None,
              auto_resume: Optional[bool] = None,
              auto_suspend: Optional[int] = None,
              comment: Optional[str] = None,
              initially_suspended: Optional[bool] = None,
              max_cluster_count: Optional[int] = None,
              max_concurrency_level: Optional[int] = None,
              min_cluster_count: Optional[int] = None,
              name: Optional[str] = None,
              resource_monitor: Optional[str] = None,
              scaling_policy: Optional[str] = None,
              statement_queued_timeout_in_seconds: Optional[int] = None,
              statement_timeout_in_seconds: Optional[int] = None,
              wait_for_provisioning: Optional[bool] = None,
              warehouse_size: Optional[str] = None)
@overload
def Warehouse(resource_name: str,
              args: Optional[WarehouseArgs] = None,
              opts: Optional[ResourceOptions] = None)
func NewWarehouse(ctx *Context, name string, args *WarehouseArgs, opts ...ResourceOption) (*Warehouse, error)
public Warehouse(string name, WarehouseArgs? args = null, CustomResourceOptions? opts = null)
name string
The unique name of the resource.
args WarehouseArgs
The arguments to resource properties.
opts CustomResourceOptions
Bag of options to control resource's behavior.
resource_name str
The unique name of the resource.
args WarehouseArgs
The arguments to resource properties.
opts ResourceOptions
Bag of options to control resource's behavior.
ctx Context
Context object for the current deployment.
name string
The unique name of the resource.
args WarehouseArgs
The arguments to resource properties.
opts ResourceOption
Bag of options to control resource's behavior.
name string
The unique name of the resource.
args WarehouseArgs
The arguments to resource properties.
opts CustomResourceOptions
Bag of options to control resource's behavior.

Warehouse Resource Properties

To learn more about resource properties and how to use them, see Inputs and Outputs in the Architecture and Concepts docs.

Inputs

The Warehouse resource accepts the following input properties:

AutoResume bool
Specifies whether to automatically resume a warehouse when a SQL statement (e.g. query) is submitted to it.
AutoSuspend int
Specifies the number of seconds of inactivity after which a warehouse is automatically suspended.
Comment string
InitiallySuspended bool
Specifies whether the warehouse is created initially in the ‘Suspended’ state.
MaxClusterCount int
Specifies the maximum number of server clusters for the warehouse.
MaxConcurrencyLevel int
Object parameter that specifies the concurrency level for SQL statements (i.e. queries and DML) executed by a warehouse.
MinClusterCount int
Specifies the minimum number of server clusters for the warehouse (only applies to multi-cluster warehouses).
Name string
Identifier for the virtual warehouse; must be unique for your account.
ResourceMonitor string
Specifies the name of a resource monitor that is explicitly assigned to the warehouse.
ScalingPolicy string
Specifies the policy for automatically starting and shutting down clusters in a multi-cluster warehouse running in Auto-scale mode.
StatementQueuedTimeoutInSeconds int
Object parameter that specifies the time, in seconds, a SQL statement (query, DDL, DML, etc.) can be queued on a warehouse before it is canceled by the system.
StatementTimeoutInSeconds int
Specifies the time, in seconds, after which a running SQL statement (query, DDL, DML, etc.) is canceled by the system
WaitForProvisioning bool
Specifies whether the warehouse, after being resized, waits for all the servers to provision before executing any queued or new queries.
WarehouseSize string
Specifies the size of the virtual warehouse. Larger warehouse sizes 5X-Large and 6X-Large are currently in preview and only available on Amazon Web Services (AWS).
AutoResume bool
Specifies whether to automatically resume a warehouse when a SQL statement (e.g. query) is submitted to it.
AutoSuspend int
Specifies the number of seconds of inactivity after which a warehouse is automatically suspended.
Comment string
InitiallySuspended bool
Specifies whether the warehouse is created initially in the ‘Suspended’ state.
MaxClusterCount int
Specifies the maximum number of server clusters for the warehouse.
MaxConcurrencyLevel int
Object parameter that specifies the concurrency level for SQL statements (i.e. queries and DML) executed by a warehouse.
MinClusterCount int
Specifies the minimum number of server clusters for the warehouse (only applies to multi-cluster warehouses).
Name string
Identifier for the virtual warehouse; must be unique for your account.
ResourceMonitor string
Specifies the name of a resource monitor that is explicitly assigned to the warehouse.
ScalingPolicy string
Specifies the policy for automatically starting and shutting down clusters in a multi-cluster warehouse running in Auto-scale mode.
StatementQueuedTimeoutInSeconds int
Object parameter that specifies the time, in seconds, a SQL statement (query, DDL, DML, etc.) can be queued on a warehouse before it is canceled by the system.
StatementTimeoutInSeconds int
Specifies the time, in seconds, after which a running SQL statement (query, DDL, DML, etc.) is canceled by the system
WaitForProvisioning bool
Specifies whether the warehouse, after being resized, waits for all the servers to provision before executing any queued or new queries.
WarehouseSize string
Specifies the size of the virtual warehouse. Larger warehouse sizes 5X-Large and 6X-Large are currently in preview and only available on Amazon Web Services (AWS).
autoResume boolean
Specifies whether to automatically resume a warehouse when a SQL statement (e.g. query) is submitted to it.
autoSuspend number
Specifies the number of seconds of inactivity after which a warehouse is automatically suspended.
comment string
initiallySuspended boolean
Specifies whether the warehouse is created initially in the ‘Suspended’ state.
maxClusterCount number
Specifies the maximum number of server clusters for the warehouse.
maxConcurrencyLevel number
Object parameter that specifies the concurrency level for SQL statements (i.e. queries and DML) executed by a warehouse.
minClusterCount number
Specifies the minimum number of server clusters for the warehouse (only applies to multi-cluster warehouses).
name string
Identifier for the virtual warehouse; must be unique for your account.
resourceMonitor string
Specifies the name of a resource monitor that is explicitly assigned to the warehouse.
scalingPolicy string
Specifies the policy for automatically starting and shutting down clusters in a multi-cluster warehouse running in Auto-scale mode.
statementQueuedTimeoutInSeconds number
Object parameter that specifies the time, in seconds, a SQL statement (query, DDL, DML, etc.) can be queued on a warehouse before it is canceled by the system.
statementTimeoutInSeconds number
Specifies the time, in seconds, after which a running SQL statement (query, DDL, DML, etc.) is canceled by the system
waitForProvisioning boolean
Specifies whether the warehouse, after being resized, waits for all the servers to provision before executing any queued or new queries.
warehouseSize string
Specifies the size of the virtual warehouse. Larger warehouse sizes 5X-Large and 6X-Large are currently in preview and only available on Amazon Web Services (AWS).
auto_resume bool
Specifies whether to automatically resume a warehouse when a SQL statement (e.g. query) is submitted to it.
auto_suspend int
Specifies the number of seconds of inactivity after which a warehouse is automatically suspended.
comment str
initially_suspended bool
Specifies whether the warehouse is created initially in the ‘Suspended’ state.
max_cluster_count int
Specifies the maximum number of server clusters for the warehouse.
max_concurrency_level int
Object parameter that specifies the concurrency level for SQL statements (i.e. queries and DML) executed by a warehouse.
min_cluster_count int
Specifies the minimum number of server clusters for the warehouse (only applies to multi-cluster warehouses).
name str
Identifier for the virtual warehouse; must be unique for your account.
resource_monitor str
Specifies the name of a resource monitor that is explicitly assigned to the warehouse.
scaling_policy str
Specifies the policy for automatically starting and shutting down clusters in a multi-cluster warehouse running in Auto-scale mode.
statement_queued_timeout_in_seconds int
Object parameter that specifies the time, in seconds, a SQL statement (query, DDL, DML, etc.) can be queued on a warehouse before it is canceled by the system.
statement_timeout_in_seconds int
Specifies the time, in seconds, after which a running SQL statement (query, DDL, DML, etc.) is canceled by the system
wait_for_provisioning bool
Specifies whether the warehouse, after being resized, waits for all the servers to provision before executing any queued or new queries.
warehouse_size str
Specifies the size of the virtual warehouse. Larger warehouse sizes 5X-Large and 6X-Large are currently in preview and only available on Amazon Web Services (AWS).

Outputs

All input properties are implicitly available as output properties. Additionally, the Warehouse resource produces the following output properties:

Id string
The provider-assigned unique ID for this managed resource.
Id string
The provider-assigned unique ID for this managed resource.
id string
The provider-assigned unique ID for this managed resource.
id str
The provider-assigned unique ID for this managed resource.

Look up an Existing Warehouse Resource

Get an existing Warehouse resource’s state with the given name, ID, and optional extra properties used to qualify the lookup.

public static get(name: string, id: Input<ID>, state?: WarehouseState, opts?: CustomResourceOptions): Warehouse
@staticmethod
def get(resource_name: str,
        id: str,
        opts: Optional[ResourceOptions] = None,
        auto_resume: Optional[bool] = None,
        auto_suspend: Optional[int] = None,
        comment: Optional[str] = None,
        initially_suspended: Optional[bool] = None,
        max_cluster_count: Optional[int] = None,
        max_concurrency_level: Optional[int] = None,
        min_cluster_count: Optional[int] = None,
        name: Optional[str] = None,
        resource_monitor: Optional[str] = None,
        scaling_policy: Optional[str] = None,
        statement_queued_timeout_in_seconds: Optional[int] = None,
        statement_timeout_in_seconds: Optional[int] = None,
        wait_for_provisioning: Optional[bool] = None,
        warehouse_size: Optional[str] = None) -> Warehouse
func GetWarehouse(ctx *Context, name string, id IDInput, state *WarehouseState, opts ...ResourceOption) (*Warehouse, error)
public static Warehouse Get(string name, Input<string> id, WarehouseState? state, CustomResourceOptions? opts = null)
name
The unique name of the resulting resource.
id
The unique provider ID of the resource to lookup.
state
Any extra arguments used during the lookup.
opts
A bag of options that control this resource's behavior.
resource_name
The unique name of the resulting resource.
id
The unique provider ID of the resource to lookup.
name
The unique name of the resulting resource.
id
The unique provider ID of the resource to lookup.
state
Any extra arguments used during the lookup.
opts
A bag of options that control this resource's behavior.
name
The unique name of the resulting resource.
id
The unique provider ID of the resource to lookup.
state
Any extra arguments used during the lookup.
opts
A bag of options that control this resource's behavior.

The following state arguments are supported:

AutoResume bool
Specifies whether to automatically resume a warehouse when a SQL statement (e.g. query) is submitted to it.
AutoSuspend int
Specifies the number of seconds of inactivity after which a warehouse is automatically suspended.
Comment string
InitiallySuspended bool
Specifies whether the warehouse is created initially in the ‘Suspended’ state.
MaxClusterCount int
Specifies the maximum number of server clusters for the warehouse.
MaxConcurrencyLevel int
Object parameter that specifies the concurrency level for SQL statements (i.e. queries and DML) executed by a warehouse.
MinClusterCount int
Specifies the minimum number of server clusters for the warehouse (only applies to multi-cluster warehouses).
Name string
Identifier for the virtual warehouse; must be unique for your account.
ResourceMonitor string
Specifies the name of a resource monitor that is explicitly assigned to the warehouse.
ScalingPolicy string
Specifies the policy for automatically starting and shutting down clusters in a multi-cluster warehouse running in Auto-scale mode.
StatementQueuedTimeoutInSeconds int
Object parameter that specifies the time, in seconds, a SQL statement (query, DDL, DML, etc.) can be queued on a warehouse before it is canceled by the system.
StatementTimeoutInSeconds int
Specifies the time, in seconds, after which a running SQL statement (query, DDL, DML, etc.) is canceled by the system
WaitForProvisioning bool
Specifies whether the warehouse, after being resized, waits for all the servers to provision before executing any queued or new queries.
WarehouseSize string
Specifies the size of the virtual warehouse. Larger warehouse sizes 5X-Large and 6X-Large are currently in preview and only available on Amazon Web Services (AWS).
AutoResume bool
Specifies whether to automatically resume a warehouse when a SQL statement (e.g. query) is submitted to it.
AutoSuspend int
Specifies the number of seconds of inactivity after which a warehouse is automatically suspended.
Comment string
InitiallySuspended bool
Specifies whether the warehouse is created initially in the ‘Suspended’ state.
MaxClusterCount int
Specifies the maximum number of server clusters for the warehouse.
MaxConcurrencyLevel int
Object parameter that specifies the concurrency level for SQL statements (i.e. queries and DML) executed by a warehouse.
MinClusterCount int
Specifies the minimum number of server clusters for the warehouse (only applies to multi-cluster warehouses).
Name string
Identifier for the virtual warehouse; must be unique for your account.
ResourceMonitor string
Specifies the name of a resource monitor that is explicitly assigned to the warehouse.
ScalingPolicy string
Specifies the policy for automatically starting and shutting down clusters in a multi-cluster warehouse running in Auto-scale mode.
StatementQueuedTimeoutInSeconds int
Object parameter that specifies the time, in seconds, a SQL statement (query, DDL, DML, etc.) can be queued on a warehouse before it is canceled by the system.
StatementTimeoutInSeconds int
Specifies the time, in seconds, after which a running SQL statement (query, DDL, DML, etc.) is canceled by the system
WaitForProvisioning bool
Specifies whether the warehouse, after being resized, waits for all the servers to provision before executing any queued or new queries.
WarehouseSize string
Specifies the size of the virtual warehouse. Larger warehouse sizes 5X-Large and 6X-Large are currently in preview and only available on Amazon Web Services (AWS).
autoResume boolean
Specifies whether to automatically resume a warehouse when a SQL statement (e.g. query) is submitted to it.
autoSuspend number
Specifies the number of seconds of inactivity after which a warehouse is automatically suspended.
comment string
initiallySuspended boolean
Specifies whether the warehouse is created initially in the ‘Suspended’ state.
maxClusterCount number
Specifies the maximum number of server clusters for the warehouse.
maxConcurrencyLevel number
Object parameter that specifies the concurrency level for SQL statements (i.e. queries and DML) executed by a warehouse.
minClusterCount number
Specifies the minimum number of server clusters for the warehouse (only applies to multi-cluster warehouses).
name string
Identifier for the virtual warehouse; must be unique for your account.
resourceMonitor string
Specifies the name of a resource monitor that is explicitly assigned to the warehouse.
scalingPolicy string
Specifies the policy for automatically starting and shutting down clusters in a multi-cluster warehouse running in Auto-scale mode.
statementQueuedTimeoutInSeconds number
Object parameter that specifies the time, in seconds, a SQL statement (query, DDL, DML, etc.) can be queued on a warehouse before it is canceled by the system.
statementTimeoutInSeconds number
Specifies the time, in seconds, after which a running SQL statement (query, DDL, DML, etc.) is canceled by the system
waitForProvisioning boolean
Specifies whether the warehouse, after being resized, waits for all the servers to provision before executing any queued or new queries.
warehouseSize string
Specifies the size of the virtual warehouse. Larger warehouse sizes 5X-Large and 6X-Large are currently in preview and only available on Amazon Web Services (AWS).
auto_resume bool
Specifies whether to automatically resume a warehouse when a SQL statement (e.g. query) is submitted to it.
auto_suspend int
Specifies the number of seconds of inactivity after which a warehouse is automatically suspended.
comment str
initially_suspended bool
Specifies whether the warehouse is created initially in the ‘Suspended’ state.
max_cluster_count int
Specifies the maximum number of server clusters for the warehouse.
max_concurrency_level int
Object parameter that specifies the concurrency level for SQL statements (i.e. queries and DML) executed by a warehouse.
min_cluster_count int
Specifies the minimum number of server clusters for the warehouse (only applies to multi-cluster warehouses).
name str
Identifier for the virtual warehouse; must be unique for your account.
resource_monitor str
Specifies the name of a resource monitor that is explicitly assigned to the warehouse.
scaling_policy str
Specifies the policy for automatically starting and shutting down clusters in a multi-cluster warehouse running in Auto-scale mode.
statement_queued_timeout_in_seconds int
Object parameter that specifies the time, in seconds, a SQL statement (query, DDL, DML, etc.) can be queued on a warehouse before it is canceled by the system.
statement_timeout_in_seconds int
Specifies the time, in seconds, after which a running SQL statement (query, DDL, DML, etc.) is canceled by the system
wait_for_provisioning bool
Specifies whether the warehouse, after being resized, waits for all the servers to provision before executing any queued or new queries.
warehouse_size str
Specifies the size of the virtual warehouse. Larger warehouse sizes 5X-Large and 6X-Large are currently in preview and only available on Amazon Web Services (AWS).

Package Details

Repository
https://github.com/pulumi/pulumi-snowflake
License
Apache-2.0
Notes
This Pulumi package is based on the snowflake Terraform Provider.