1. Packages
  2. Snowflake
  3. API Docs
  4. Warehouse
Snowflake v0.55.0 published on Friday, Jun 7, 2024 by Pulumi

snowflake.Warehouse

Explore with Pulumi AI

snowflake logo
Snowflake v0.55.0 published on Friday, Jun 7, 2024 by Pulumi

    Example Usage

    import * as pulumi from "@pulumi/pulumi";
    import * as snowflake from "@pulumi/snowflake";
    
    const warehouse = new snowflake.Warehouse("warehouse", {
        name: "test",
        comment: "foo",
        warehouseSize: "small",
    });
    
    import pulumi
    import pulumi_snowflake as snowflake
    
    warehouse = snowflake.Warehouse("warehouse",
        name="test",
        comment="foo",
        warehouse_size="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{
    			Name:          pulumi.String("test"),
    			Comment:       pulumi.String("foo"),
    			WarehouseSize: pulumi.String("small"),
    		})
    		if err != nil {
    			return err
    		}
    		return nil
    	})
    }
    
    using System.Collections.Generic;
    using System.Linq;
    using Pulumi;
    using Snowflake = Pulumi.Snowflake;
    
    return await Deployment.RunAsync(() => 
    {
        var warehouse = new Snowflake.Warehouse("warehouse", new()
        {
            Name = "test",
            Comment = "foo",
            WarehouseSize = "small",
        });
    
    });
    
    package generated_program;
    
    import com.pulumi.Context;
    import com.pulumi.Pulumi;
    import com.pulumi.core.Output;
    import com.pulumi.snowflake.Warehouse;
    import com.pulumi.snowflake.WarehouseArgs;
    import java.util.List;
    import java.util.ArrayList;
    import java.util.Map;
    import java.io.File;
    import java.nio.file.Files;
    import java.nio.file.Paths;
    
    public class App {
        public static void main(String[] args) {
            Pulumi.run(App::stack);
        }
    
        public static void stack(Context ctx) {
            var warehouse = new Warehouse("warehouse", WarehouseArgs.builder()
                .name("test")
                .comment("foo")
                .warehouseSize("small")
                .build());
    
        }
    }
    
    resources:
      warehouse:
        type: snowflake:Warehouse
        properties:
          name: test
          comment: foo
          warehouseSize: small
    

    Create Warehouse Resource

    Resources are created with functions called constructors. To learn more about declaring and configuring resources, see Resources.

    Constructor syntax

    new Warehouse(name: string, args?: WarehouseArgs, opts?: CustomResourceOptions);
    @overload
    def Warehouse(resource_name: str,
                  args: Optional[WarehouseArgs] = None,
                  opts: Optional[ResourceOptions] = None)
    
    @overload
    def Warehouse(resource_name: str,
                  opts: Optional[ResourceOptions] = None,
                  auto_resume: Optional[bool] = None,
                  auto_suspend: Optional[int] = None,
                  comment: Optional[str] = None,
                  enable_query_acceleration: Optional[bool] = 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,
                  query_acceleration_max_scale_factor: Optional[int] = 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_type: Optional[str] = None)
    func NewWarehouse(ctx *Context, name string, args *WarehouseArgs, opts ...ResourceOption) (*Warehouse, error)
    public Warehouse(string name, WarehouseArgs? args = null, CustomResourceOptions? opts = null)
    public Warehouse(String name, WarehouseArgs args)
    public Warehouse(String name, WarehouseArgs args, CustomResourceOptions options)
    
    type: snowflake:Warehouse
    properties: # The arguments to resource properties.
    options: # Bag of options to control resource's behavior.
    
    

    Parameters

    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.
    name String
    The unique name of the resource.
    args WarehouseArgs
    The arguments to resource properties.
    options CustomResourceOptions
    Bag of options to control resource's behavior.

    Constructor example

    The following reference example uses placeholder values for all input properties.

    var warehouseResource = new Snowflake.Warehouse("warehouseResource", new()
    {
        AutoResume = false,
        AutoSuspend = 0,
        Comment = "string",
        EnableQueryAcceleration = false,
        InitiallySuspended = false,
        MaxClusterCount = 0,
        MaxConcurrencyLevel = 0,
        MinClusterCount = 0,
        Name = "string",
        QueryAccelerationMaxScaleFactor = 0,
        ResourceMonitor = "string",
        ScalingPolicy = "string",
        StatementQueuedTimeoutInSeconds = 0,
        StatementTimeoutInSeconds = 0,
        WarehouseSize = "string",
        WarehouseType = "string",
    });
    
    example, err := snowflake.NewWarehouse(ctx, "warehouseResource", &snowflake.WarehouseArgs{
    	AutoResume:                      pulumi.Bool(false),
    	AutoSuspend:                     pulumi.Int(0),
    	Comment:                         pulumi.String("string"),
    	EnableQueryAcceleration:         pulumi.Bool(false),
    	InitiallySuspended:              pulumi.Bool(false),
    	MaxClusterCount:                 pulumi.Int(0),
    	MaxConcurrencyLevel:             pulumi.Int(0),
    	MinClusterCount:                 pulumi.Int(0),
    	Name:                            pulumi.String("string"),
    	QueryAccelerationMaxScaleFactor: pulumi.Int(0),
    	ResourceMonitor:                 pulumi.String("string"),
    	ScalingPolicy:                   pulumi.String("string"),
    	StatementQueuedTimeoutInSeconds: pulumi.Int(0),
    	StatementTimeoutInSeconds:       pulumi.Int(0),
    	WarehouseSize:                   pulumi.String("string"),
    	WarehouseType:                   pulumi.String("string"),
    })
    
    var warehouseResource = new Warehouse("warehouseResource", WarehouseArgs.builder()
        .autoResume(false)
        .autoSuspend(0)
        .comment("string")
        .enableQueryAcceleration(false)
        .initiallySuspended(false)
        .maxClusterCount(0)
        .maxConcurrencyLevel(0)
        .minClusterCount(0)
        .name("string")
        .queryAccelerationMaxScaleFactor(0)
        .resourceMonitor("string")
        .scalingPolicy("string")
        .statementQueuedTimeoutInSeconds(0)
        .statementTimeoutInSeconds(0)
        .warehouseSize("string")
        .warehouseType("string")
        .build());
    
    warehouse_resource = snowflake.Warehouse("warehouseResource",
        auto_resume=False,
        auto_suspend=0,
        comment="string",
        enable_query_acceleration=False,
        initially_suspended=False,
        max_cluster_count=0,
        max_concurrency_level=0,
        min_cluster_count=0,
        name="string",
        query_acceleration_max_scale_factor=0,
        resource_monitor="string",
        scaling_policy="string",
        statement_queued_timeout_in_seconds=0,
        statement_timeout_in_seconds=0,
        warehouse_size="string",
        warehouse_type="string")
    
    const warehouseResource = new snowflake.Warehouse("warehouseResource", {
        autoResume: false,
        autoSuspend: 0,
        comment: "string",
        enableQueryAcceleration: false,
        initiallySuspended: false,
        maxClusterCount: 0,
        maxConcurrencyLevel: 0,
        minClusterCount: 0,
        name: "string",
        queryAccelerationMaxScaleFactor: 0,
        resourceMonitor: "string",
        scalingPolicy: "string",
        statementQueuedTimeoutInSeconds: 0,
        statementTimeoutInSeconds: 0,
        warehouseSize: "string",
        warehouseType: "string",
    });
    
    type: snowflake:Warehouse
    properties:
        autoResume: false
        autoSuspend: 0
        comment: string
        enableQueryAcceleration: false
        initiallySuspended: false
        maxClusterCount: 0
        maxConcurrencyLevel: 0
        minClusterCount: 0
        name: string
        queryAccelerationMaxScaleFactor: 0
        resourceMonitor: string
        scalingPolicy: string
        statementQueuedTimeoutInSeconds: 0
        statementTimeoutInSeconds: 0
        warehouseSize: string
        warehouseType: string
    

    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
    EnableQueryAcceleration bool
    Specifies whether to enable the query acceleration service for queries that rely on this warehouse for compute resources.
    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.
    QueryAccelerationMaxScaleFactor int
    Specifies the maximum scale factor for leasing compute resources for query acceleration. The scale factor is used as a multiplier based on warehouse size.
    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.

    Deprecated: This field is deprecated and will be removed in the next major version of the provider. It doesn't do anything and should be removed from your configuration.

    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).
    WarehouseType string
    Specifies a STANDARD or SNOWPARK-OPTIMIZED warehouse
    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
    EnableQueryAcceleration bool
    Specifies whether to enable the query acceleration service for queries that rely on this warehouse for compute resources.
    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.
    QueryAccelerationMaxScaleFactor int
    Specifies the maximum scale factor for leasing compute resources for query acceleration. The scale factor is used as a multiplier based on warehouse size.
    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.

    Deprecated: This field is deprecated and will be removed in the next major version of the provider. It doesn't do anything and should be removed from your configuration.

    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).
    WarehouseType string
    Specifies a STANDARD or SNOWPARK-OPTIMIZED warehouse
    autoResume Boolean
    Specifies whether to automatically resume a warehouse when a SQL statement (e.g. query) is submitted to it.
    autoSuspend Integer
    Specifies the number of seconds of inactivity after which a warehouse is automatically suspended.
    comment String
    enableQueryAcceleration Boolean
    Specifies whether to enable the query acceleration service for queries that rely on this warehouse for compute resources.
    initiallySuspended Boolean
    Specifies whether the warehouse is created initially in the ‘Suspended’ state.
    maxClusterCount Integer
    Specifies the maximum number of server clusters for the warehouse.
    maxConcurrencyLevel Integer
    Object parameter that specifies the concurrency level for SQL statements (i.e. queries and DML) executed by a warehouse.
    minClusterCount Integer
    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.
    queryAccelerationMaxScaleFactor Integer
    Specifies the maximum scale factor for leasing compute resources for query acceleration. The scale factor is used as a multiplier based on warehouse size.
    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 Integer
    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 Integer
    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.

    Deprecated: This field is deprecated and will be removed in the next major version of the provider. It doesn't do anything and should be removed from your configuration.

    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).
    warehouseType String
    Specifies a STANDARD or SNOWPARK-OPTIMIZED warehouse
    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
    enableQueryAcceleration boolean
    Specifies whether to enable the query acceleration service for queries that rely on this warehouse for compute resources.
    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.
    queryAccelerationMaxScaleFactor number
    Specifies the maximum scale factor for leasing compute resources for query acceleration. The scale factor is used as a multiplier based on warehouse size.
    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.

    Deprecated: This field is deprecated and will be removed in the next major version of the provider. It doesn't do anything and should be removed from your configuration.

    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).
    warehouseType string
    Specifies a STANDARD or SNOWPARK-OPTIMIZED warehouse
    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
    enable_query_acceleration bool
    Specifies whether to enable the query acceleration service for queries that rely on this warehouse for compute resources.
    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.
    query_acceleration_max_scale_factor int
    Specifies the maximum scale factor for leasing compute resources for query acceleration. The scale factor is used as a multiplier based on warehouse size.
    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.

    Deprecated: This field is deprecated and will be removed in the next major version of the provider. It doesn't do anything and should be removed from your configuration.

    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).
    warehouse_type str
    Specifies a STANDARD or SNOWPARK-OPTIMIZED warehouse
    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
    enableQueryAcceleration Boolean
    Specifies whether to enable the query acceleration service for queries that rely on this warehouse for compute resources.
    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.
    queryAccelerationMaxScaleFactor Number
    Specifies the maximum scale factor for leasing compute resources for query acceleration. The scale factor is used as a multiplier based on warehouse size.
    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.

    Deprecated: This field is deprecated and will be removed in the next major version of the provider. It doesn't do anything and should be removed from your configuration.

    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).
    warehouseType String
    Specifies a STANDARD or SNOWPARK-OPTIMIZED warehouse

    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 string
    The provider-assigned unique ID for this managed resource.
    id str
    The provider-assigned unique ID for this managed resource.
    id String
    The provider-assigned unique ID for this managed resource.

    Look up 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,
            enable_query_acceleration: Optional[bool] = 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,
            query_acceleration_max_scale_factor: Optional[int] = 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_type: 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)
    public static Warehouse get(String name, Output<String> id, WarehouseState state, CustomResourceOptions options)
    Resource lookup is not supported in YAML
    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.
    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
    EnableQueryAcceleration bool
    Specifies whether to enable the query acceleration service for queries that rely on this warehouse for compute resources.
    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.
    QueryAccelerationMaxScaleFactor int
    Specifies the maximum scale factor for leasing compute resources for query acceleration. The scale factor is used as a multiplier based on warehouse size.
    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.

    Deprecated: This field is deprecated and will be removed in the next major version of the provider. It doesn't do anything and should be removed from your configuration.

    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).
    WarehouseType string
    Specifies a STANDARD or SNOWPARK-OPTIMIZED warehouse
    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
    EnableQueryAcceleration bool
    Specifies whether to enable the query acceleration service for queries that rely on this warehouse for compute resources.
    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.
    QueryAccelerationMaxScaleFactor int
    Specifies the maximum scale factor for leasing compute resources for query acceleration. The scale factor is used as a multiplier based on warehouse size.
    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.

    Deprecated: This field is deprecated and will be removed in the next major version of the provider. It doesn't do anything and should be removed from your configuration.

    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).
    WarehouseType string
    Specifies a STANDARD or SNOWPARK-OPTIMIZED warehouse
    autoResume Boolean
    Specifies whether to automatically resume a warehouse when a SQL statement (e.g. query) is submitted to it.
    autoSuspend Integer
    Specifies the number of seconds of inactivity after which a warehouse is automatically suspended.
    comment String
    enableQueryAcceleration Boolean
    Specifies whether to enable the query acceleration service for queries that rely on this warehouse for compute resources.
    initiallySuspended Boolean
    Specifies whether the warehouse is created initially in the ‘Suspended’ state.
    maxClusterCount Integer
    Specifies the maximum number of server clusters for the warehouse.
    maxConcurrencyLevel Integer
    Object parameter that specifies the concurrency level for SQL statements (i.e. queries and DML) executed by a warehouse.
    minClusterCount Integer
    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.
    queryAccelerationMaxScaleFactor Integer
    Specifies the maximum scale factor for leasing compute resources for query acceleration. The scale factor is used as a multiplier based on warehouse size.
    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 Integer
    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 Integer
    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.

    Deprecated: This field is deprecated and will be removed in the next major version of the provider. It doesn't do anything and should be removed from your configuration.

    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).
    warehouseType String
    Specifies a STANDARD or SNOWPARK-OPTIMIZED warehouse
    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
    enableQueryAcceleration boolean
    Specifies whether to enable the query acceleration service for queries that rely on this warehouse for compute resources.
    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.
    queryAccelerationMaxScaleFactor number
    Specifies the maximum scale factor for leasing compute resources for query acceleration. The scale factor is used as a multiplier based on warehouse size.
    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.

    Deprecated: This field is deprecated and will be removed in the next major version of the provider. It doesn't do anything and should be removed from your configuration.

    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).
    warehouseType string
    Specifies a STANDARD or SNOWPARK-OPTIMIZED warehouse
    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
    enable_query_acceleration bool
    Specifies whether to enable the query acceleration service for queries that rely on this warehouse for compute resources.
    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.
    query_acceleration_max_scale_factor int
    Specifies the maximum scale factor for leasing compute resources for query acceleration. The scale factor is used as a multiplier based on warehouse size.
    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.

    Deprecated: This field is deprecated and will be removed in the next major version of the provider. It doesn't do anything and should be removed from your configuration.

    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).
    warehouse_type str
    Specifies a STANDARD or SNOWPARK-OPTIMIZED warehouse
    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
    enableQueryAcceleration Boolean
    Specifies whether to enable the query acceleration service for queries that rely on this warehouse for compute resources.
    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.
    queryAccelerationMaxScaleFactor Number
    Specifies the maximum scale factor for leasing compute resources for query acceleration. The scale factor is used as a multiplier based on warehouse size.
    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.

    Deprecated: This field is deprecated and will be removed in the next major version of the provider. It doesn't do anything and should be removed from your configuration.

    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).
    warehouseType String
    Specifies a STANDARD or SNOWPARK-OPTIMIZED warehouse

    Import

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

    To learn more about importing existing cloud resources, see Importing resources.

    Package Details

    Repository
    Snowflake pulumi/pulumi-snowflake
    License
    Apache-2.0
    Notes
    This Pulumi package is based on the snowflake Terraform Provider.
    snowflake logo
    Snowflake v0.55.0 published on Friday, Jun 7, 2024 by Pulumi