1. Packages
  2. Snowflake
  3. API Docs
  4. Warehouse
Snowflake v0.59.0 published on Friday, Sep 20, 2024 by Pulumi

snowflake.Warehouse

Explore with Pulumi AI

snowflake logo
Snowflake v0.59.0 published on Friday, Sep 20, 2024 by Pulumi

    Import

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

    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[str] = None,
                  auto_suspend: Optional[int] = None,
                  comment: Optional[str] = None,
                  enable_query_acceleration: 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,
                  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,
                  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 = "string",
        AutoSuspend = 0,
        Comment = "string",
        EnableQueryAcceleration = "string",
        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.String("string"),
    	AutoSuspend:                     pulumi.Int(0),
    	Comment:                         pulumi.String("string"),
    	EnableQueryAcceleration:         pulumi.String("string"),
    	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("string")
        .autoSuspend(0)
        .comment("string")
        .enableQueryAcceleration("string")
        .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="string",
        auto_suspend=0,
        comment="string",
        enable_query_acceleration="string",
        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: "string",
        autoSuspend: 0,
        comment: "string",
        enableQueryAcceleration: "string",
        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: string
        autoSuspend: 0
        comment: string
        enableQueryAcceleration: string
        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 string
    Specifies whether to automatically resume a warehouse when a SQL statement (e.g. query) is submitted to it. Available options are: "true" or "false". When the value is not set in the configuration the provider will put "default" there which means to use the Snowflake default for this value.
    AutoSuspend int
    Specifies the number of seconds of inactivity after which a warehouse is automatically suspended.
    Comment string
    Specifies a comment for the warehouse.
    EnableQueryAcceleration string
    Specifies whether to enable the query acceleration service for queries that rely on this warehouse for compute resources. Available options are: "true" or "false". When the value is not set in the configuration the provider will put "default" there which means to use the Snowflake default for this value.
    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. Due to technical limitations (read more here), avoid using the following characters: |, ., (, ), "
    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. Valid values are (case-insensitive): STANDARD | ECONOMY.
    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
    WarehouseSize string
    Specifies the size of the virtual warehouse. Valid values are (case-insensitive): XSMALL | X-SMALL | SMALL | MEDIUM | LARGE | XLARGE | X-LARGE | XXLARGE | X2LARGE | 2X-LARGE | XXXLARGE | X3LARGE | 3X-LARGE | X4LARGE | 4X-LARGE | X5LARGE | 5X-LARGE | X6LARGE | 6X-LARGE. Consult warehouse documentation for the details. Note: removing the size from config will result in the resource recreation.
    WarehouseType string
    Specifies warehouse type. Valid values are (case-insensitive): STANDARD | SNOWPARK-OPTIMIZED. Warehouse needs to be suspended to change its type. Provider will handle automatic suspension and resumption if needed.
    AutoResume string
    Specifies whether to automatically resume a warehouse when a SQL statement (e.g. query) is submitted to it. Available options are: "true" or "false". When the value is not set in the configuration the provider will put "default" there which means to use the Snowflake default for this value.
    AutoSuspend int
    Specifies the number of seconds of inactivity after which a warehouse is automatically suspended.
    Comment string
    Specifies a comment for the warehouse.
    EnableQueryAcceleration string
    Specifies whether to enable the query acceleration service for queries that rely on this warehouse for compute resources. Available options are: "true" or "false". When the value is not set in the configuration the provider will put "default" there which means to use the Snowflake default for this value.
    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. Due to technical limitations (read more here), avoid using the following characters: |, ., (, ), "
    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. Valid values are (case-insensitive): STANDARD | ECONOMY.
    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
    WarehouseSize string
    Specifies the size of the virtual warehouse. Valid values are (case-insensitive): XSMALL | X-SMALL | SMALL | MEDIUM | LARGE | XLARGE | X-LARGE | XXLARGE | X2LARGE | 2X-LARGE | XXXLARGE | X3LARGE | 3X-LARGE | X4LARGE | 4X-LARGE | X5LARGE | 5X-LARGE | X6LARGE | 6X-LARGE. Consult warehouse documentation for the details. Note: removing the size from config will result in the resource recreation.
    WarehouseType string
    Specifies warehouse type. Valid values are (case-insensitive): STANDARD | SNOWPARK-OPTIMIZED. Warehouse needs to be suspended to change its type. Provider will handle automatic suspension and resumption if needed.
    autoResume String
    Specifies whether to automatically resume a warehouse when a SQL statement (e.g. query) is submitted to it. Available options are: "true" or "false". When the value is not set in the configuration the provider will put "default" there which means to use the Snowflake default for this value.
    autoSuspend Integer
    Specifies the number of seconds of inactivity after which a warehouse is automatically suspended.
    comment String
    Specifies a comment for the warehouse.
    enableQueryAcceleration String
    Specifies whether to enable the query acceleration service for queries that rely on this warehouse for compute resources. Available options are: "true" or "false". When the value is not set in the configuration the provider will put "default" there which means to use the Snowflake default for this value.
    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. Due to technical limitations (read more here), avoid using the following characters: |, ., (, ), "
    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. Valid values are (case-insensitive): STANDARD | ECONOMY.
    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
    warehouseSize String
    Specifies the size of the virtual warehouse. Valid values are (case-insensitive): XSMALL | X-SMALL | SMALL | MEDIUM | LARGE | XLARGE | X-LARGE | XXLARGE | X2LARGE | 2X-LARGE | XXXLARGE | X3LARGE | 3X-LARGE | X4LARGE | 4X-LARGE | X5LARGE | 5X-LARGE | X6LARGE | 6X-LARGE. Consult warehouse documentation for the details. Note: removing the size from config will result in the resource recreation.
    warehouseType String
    Specifies warehouse type. Valid values are (case-insensitive): STANDARD | SNOWPARK-OPTIMIZED. Warehouse needs to be suspended to change its type. Provider will handle automatic suspension and resumption if needed.
    autoResume string
    Specifies whether to automatically resume a warehouse when a SQL statement (e.g. query) is submitted to it. Available options are: "true" or "false". When the value is not set in the configuration the provider will put "default" there which means to use the Snowflake default for this value.
    autoSuspend number
    Specifies the number of seconds of inactivity after which a warehouse is automatically suspended.
    comment string
    Specifies a comment for the warehouse.
    enableQueryAcceleration string
    Specifies whether to enable the query acceleration service for queries that rely on this warehouse for compute resources. Available options are: "true" or "false". When the value is not set in the configuration the provider will put "default" there which means to use the Snowflake default for this value.
    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. Due to technical limitations (read more here), avoid using the following characters: |, ., (, ), "
    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. Valid values are (case-insensitive): STANDARD | ECONOMY.
    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
    warehouseSize string
    Specifies the size of the virtual warehouse. Valid values are (case-insensitive): XSMALL | X-SMALL | SMALL | MEDIUM | LARGE | XLARGE | X-LARGE | XXLARGE | X2LARGE | 2X-LARGE | XXXLARGE | X3LARGE | 3X-LARGE | X4LARGE | 4X-LARGE | X5LARGE | 5X-LARGE | X6LARGE | 6X-LARGE. Consult warehouse documentation for the details. Note: removing the size from config will result in the resource recreation.
    warehouseType string
    Specifies warehouse type. Valid values are (case-insensitive): STANDARD | SNOWPARK-OPTIMIZED. Warehouse needs to be suspended to change its type. Provider will handle automatic suspension and resumption if needed.
    auto_resume str
    Specifies whether to automatically resume a warehouse when a SQL statement (e.g. query) is submitted to it. Available options are: "true" or "false". When the value is not set in the configuration the provider will put "default" there which means to use the Snowflake default for this value.
    auto_suspend int
    Specifies the number of seconds of inactivity after which a warehouse is automatically suspended.
    comment str
    Specifies a comment for the warehouse.
    enable_query_acceleration str
    Specifies whether to enable the query acceleration service for queries that rely on this warehouse for compute resources. Available options are: "true" or "false". When the value is not set in the configuration the provider will put "default" there which means to use the Snowflake default for this value.
    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. Due to technical limitations (read more here), avoid using the following characters: |, ., (, ), "
    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. Valid values are (case-insensitive): STANDARD | ECONOMY.
    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
    warehouse_size str
    Specifies the size of the virtual warehouse. Valid values are (case-insensitive): XSMALL | X-SMALL | SMALL | MEDIUM | LARGE | XLARGE | X-LARGE | XXLARGE | X2LARGE | 2X-LARGE | XXXLARGE | X3LARGE | 3X-LARGE | X4LARGE | 4X-LARGE | X5LARGE | 5X-LARGE | X6LARGE | 6X-LARGE. Consult warehouse documentation for the details. Note: removing the size from config will result in the resource recreation.
    warehouse_type str
    Specifies warehouse type. Valid values are (case-insensitive): STANDARD | SNOWPARK-OPTIMIZED. Warehouse needs to be suspended to change its type. Provider will handle automatic suspension and resumption if needed.
    autoResume String
    Specifies whether to automatically resume a warehouse when a SQL statement (e.g. query) is submitted to it. Available options are: "true" or "false". When the value is not set in the configuration the provider will put "default" there which means to use the Snowflake default for this value.
    autoSuspend Number
    Specifies the number of seconds of inactivity after which a warehouse is automatically suspended.
    comment String
    Specifies a comment for the warehouse.
    enableQueryAcceleration String
    Specifies whether to enable the query acceleration service for queries that rely on this warehouse for compute resources. Available options are: "true" or "false". When the value is not set in the configuration the provider will put "default" there which means to use the Snowflake default for this value.
    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. Due to technical limitations (read more here), avoid using the following characters: |, ., (, ), "
    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. Valid values are (case-insensitive): STANDARD | ECONOMY.
    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
    warehouseSize String
    Specifies the size of the virtual warehouse. Valid values are (case-insensitive): XSMALL | X-SMALL | SMALL | MEDIUM | LARGE | XLARGE | X-LARGE | XXLARGE | X2LARGE | 2X-LARGE | XXXLARGE | X3LARGE | 3X-LARGE | X4LARGE | 4X-LARGE | X5LARGE | 5X-LARGE | X6LARGE | 6X-LARGE. Consult warehouse documentation for the details. Note: removing the size from config will result in the resource recreation.
    warehouseType String
    Specifies warehouse type. Valid values are (case-insensitive): STANDARD | SNOWPARK-OPTIMIZED. Warehouse needs to be suspended to change its type. Provider will handle automatic suspension and resumption if needed.

    Outputs

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

    FullyQualifiedName string
    Fully qualified name of the resource. For more information, see object name resolution.
    Id string
    The provider-assigned unique ID for this managed resource.
    Parameters List<WarehouseParameter>
    Outputs the result of SHOW PARAMETERS IN WAREHOUSE for the given warehouse.
    ShowOutputs List<WarehouseShowOutput>
    Outputs the result of SHOW WAREHOUSES for the given warehouse.
    FullyQualifiedName string
    Fully qualified name of the resource. For more information, see object name resolution.
    Id string
    The provider-assigned unique ID for this managed resource.
    Parameters []WarehouseParameter
    Outputs the result of SHOW PARAMETERS IN WAREHOUSE for the given warehouse.
    ShowOutputs []WarehouseShowOutput
    Outputs the result of SHOW WAREHOUSES for the given warehouse.
    fullyQualifiedName String
    Fully qualified name of the resource. For more information, see object name resolution.
    id String
    The provider-assigned unique ID for this managed resource.
    parameters List<WarehouseParameter>
    Outputs the result of SHOW PARAMETERS IN WAREHOUSE for the given warehouse.
    showOutputs List<WarehouseShowOutput>
    Outputs the result of SHOW WAREHOUSES for the given warehouse.
    fullyQualifiedName string
    Fully qualified name of the resource. For more information, see object name resolution.
    id string
    The provider-assigned unique ID for this managed resource.
    parameters WarehouseParameter[]
    Outputs the result of SHOW PARAMETERS IN WAREHOUSE for the given warehouse.
    showOutputs WarehouseShowOutput[]
    Outputs the result of SHOW WAREHOUSES for the given warehouse.
    fully_qualified_name str
    Fully qualified name of the resource. For more information, see object name resolution.
    id str
    The provider-assigned unique ID for this managed resource.
    parameters Sequence[WarehouseParameter]
    Outputs the result of SHOW PARAMETERS IN WAREHOUSE for the given warehouse.
    show_outputs Sequence[WarehouseShowOutput]
    Outputs the result of SHOW WAREHOUSES for the given warehouse.
    fullyQualifiedName String
    Fully qualified name of the resource. For more information, see object name resolution.
    id String
    The provider-assigned unique ID for this managed resource.
    parameters List<Property Map>
    Outputs the result of SHOW PARAMETERS IN WAREHOUSE for the given warehouse.
    showOutputs List<Property Map>
    Outputs the result of SHOW WAREHOUSES for the given warehouse.

    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[str] = None,
            auto_suspend: Optional[int] = None,
            comment: Optional[str] = None,
            enable_query_acceleration: Optional[str] = None,
            fully_qualified_name: 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,
            parameters: Optional[Sequence[WarehouseParameterArgs]] = None,
            query_acceleration_max_scale_factor: Optional[int] = None,
            resource_monitor: Optional[str] = None,
            scaling_policy: Optional[str] = None,
            show_outputs: Optional[Sequence[WarehouseShowOutputArgs]] = None,
            statement_queued_timeout_in_seconds: Optional[int] = None,
            statement_timeout_in_seconds: Optional[int] = 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 string
    Specifies whether to automatically resume a warehouse when a SQL statement (e.g. query) is submitted to it. Available options are: "true" or "false". When the value is not set in the configuration the provider will put "default" there which means to use the Snowflake default for this value.
    AutoSuspend int
    Specifies the number of seconds of inactivity after which a warehouse is automatically suspended.
    Comment string
    Specifies a comment for the warehouse.
    EnableQueryAcceleration string
    Specifies whether to enable the query acceleration service for queries that rely on this warehouse for compute resources. Available options are: "true" or "false". When the value is not set in the configuration the provider will put "default" there which means to use the Snowflake default for this value.
    FullyQualifiedName string
    Fully qualified name of the resource. For more information, see object name resolution.
    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. Due to technical limitations (read more here), avoid using the following characters: |, ., (, ), "
    Parameters List<WarehouseParameter>
    Outputs the result of SHOW PARAMETERS IN WAREHOUSE for the given warehouse.
    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. Valid values are (case-insensitive): STANDARD | ECONOMY.
    ShowOutputs List<WarehouseShowOutput>
    Outputs the result of SHOW WAREHOUSES for the given warehouse.
    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
    WarehouseSize string
    Specifies the size of the virtual warehouse. Valid values are (case-insensitive): XSMALL | X-SMALL | SMALL | MEDIUM | LARGE | XLARGE | X-LARGE | XXLARGE | X2LARGE | 2X-LARGE | XXXLARGE | X3LARGE | 3X-LARGE | X4LARGE | 4X-LARGE | X5LARGE | 5X-LARGE | X6LARGE | 6X-LARGE. Consult warehouse documentation for the details. Note: removing the size from config will result in the resource recreation.
    WarehouseType string
    Specifies warehouse type. Valid values are (case-insensitive): STANDARD | SNOWPARK-OPTIMIZED. Warehouse needs to be suspended to change its type. Provider will handle automatic suspension and resumption if needed.
    AutoResume string
    Specifies whether to automatically resume a warehouse when a SQL statement (e.g. query) is submitted to it. Available options are: "true" or "false". When the value is not set in the configuration the provider will put "default" there which means to use the Snowflake default for this value.
    AutoSuspend int
    Specifies the number of seconds of inactivity after which a warehouse is automatically suspended.
    Comment string
    Specifies a comment for the warehouse.
    EnableQueryAcceleration string
    Specifies whether to enable the query acceleration service for queries that rely on this warehouse for compute resources. Available options are: "true" or "false". When the value is not set in the configuration the provider will put "default" there which means to use the Snowflake default for this value.
    FullyQualifiedName string
    Fully qualified name of the resource. For more information, see object name resolution.
    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. Due to technical limitations (read more here), avoid using the following characters: |, ., (, ), "
    Parameters []WarehouseParameterArgs
    Outputs the result of SHOW PARAMETERS IN WAREHOUSE for the given warehouse.
    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. Valid values are (case-insensitive): STANDARD | ECONOMY.
    ShowOutputs []WarehouseShowOutputArgs
    Outputs the result of SHOW WAREHOUSES for the given warehouse.
    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
    WarehouseSize string
    Specifies the size of the virtual warehouse. Valid values are (case-insensitive): XSMALL | X-SMALL | SMALL | MEDIUM | LARGE | XLARGE | X-LARGE | XXLARGE | X2LARGE | 2X-LARGE | XXXLARGE | X3LARGE | 3X-LARGE | X4LARGE | 4X-LARGE | X5LARGE | 5X-LARGE | X6LARGE | 6X-LARGE. Consult warehouse documentation for the details. Note: removing the size from config will result in the resource recreation.
    WarehouseType string
    Specifies warehouse type. Valid values are (case-insensitive): STANDARD | SNOWPARK-OPTIMIZED. Warehouse needs to be suspended to change its type. Provider will handle automatic suspension and resumption if needed.
    autoResume String
    Specifies whether to automatically resume a warehouse when a SQL statement (e.g. query) is submitted to it. Available options are: "true" or "false". When the value is not set in the configuration the provider will put "default" there which means to use the Snowflake default for this value.
    autoSuspend Integer
    Specifies the number of seconds of inactivity after which a warehouse is automatically suspended.
    comment String
    Specifies a comment for the warehouse.
    enableQueryAcceleration String
    Specifies whether to enable the query acceleration service for queries that rely on this warehouse for compute resources. Available options are: "true" or "false". When the value is not set in the configuration the provider will put "default" there which means to use the Snowflake default for this value.
    fullyQualifiedName String
    Fully qualified name of the resource. For more information, see object name resolution.
    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. Due to technical limitations (read more here), avoid using the following characters: |, ., (, ), "
    parameters List<WarehouseParameter>
    Outputs the result of SHOW PARAMETERS IN WAREHOUSE for the given warehouse.
    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. Valid values are (case-insensitive): STANDARD | ECONOMY.
    showOutputs List<WarehouseShowOutput>
    Outputs the result of SHOW WAREHOUSES for the given warehouse.
    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
    warehouseSize String
    Specifies the size of the virtual warehouse. Valid values are (case-insensitive): XSMALL | X-SMALL | SMALL | MEDIUM | LARGE | XLARGE | X-LARGE | XXLARGE | X2LARGE | 2X-LARGE | XXXLARGE | X3LARGE | 3X-LARGE | X4LARGE | 4X-LARGE | X5LARGE | 5X-LARGE | X6LARGE | 6X-LARGE. Consult warehouse documentation for the details. Note: removing the size from config will result in the resource recreation.
    warehouseType String
    Specifies warehouse type. Valid values are (case-insensitive): STANDARD | SNOWPARK-OPTIMIZED. Warehouse needs to be suspended to change its type. Provider will handle automatic suspension and resumption if needed.
    autoResume string
    Specifies whether to automatically resume a warehouse when a SQL statement (e.g. query) is submitted to it. Available options are: "true" or "false". When the value is not set in the configuration the provider will put "default" there which means to use the Snowflake default for this value.
    autoSuspend number
    Specifies the number of seconds of inactivity after which a warehouse is automatically suspended.
    comment string
    Specifies a comment for the warehouse.
    enableQueryAcceleration string
    Specifies whether to enable the query acceleration service for queries that rely on this warehouse for compute resources. Available options are: "true" or "false". When the value is not set in the configuration the provider will put "default" there which means to use the Snowflake default for this value.
    fullyQualifiedName string
    Fully qualified name of the resource. For more information, see object name resolution.
    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. Due to technical limitations (read more here), avoid using the following characters: |, ., (, ), "
    parameters WarehouseParameter[]
    Outputs the result of SHOW PARAMETERS IN WAREHOUSE for the given warehouse.
    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. Valid values are (case-insensitive): STANDARD | ECONOMY.
    showOutputs WarehouseShowOutput[]
    Outputs the result of SHOW WAREHOUSES for the given warehouse.
    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
    warehouseSize string
    Specifies the size of the virtual warehouse. Valid values are (case-insensitive): XSMALL | X-SMALL | SMALL | MEDIUM | LARGE | XLARGE | X-LARGE | XXLARGE | X2LARGE | 2X-LARGE | XXXLARGE | X3LARGE | 3X-LARGE | X4LARGE | 4X-LARGE | X5LARGE | 5X-LARGE | X6LARGE | 6X-LARGE. Consult warehouse documentation for the details. Note: removing the size from config will result in the resource recreation.
    warehouseType string
    Specifies warehouse type. Valid values are (case-insensitive): STANDARD | SNOWPARK-OPTIMIZED. Warehouse needs to be suspended to change its type. Provider will handle automatic suspension and resumption if needed.
    auto_resume str
    Specifies whether to automatically resume a warehouse when a SQL statement (e.g. query) is submitted to it. Available options are: "true" or "false". When the value is not set in the configuration the provider will put "default" there which means to use the Snowflake default for this value.
    auto_suspend int
    Specifies the number of seconds of inactivity after which a warehouse is automatically suspended.
    comment str
    Specifies a comment for the warehouse.
    enable_query_acceleration str
    Specifies whether to enable the query acceleration service for queries that rely on this warehouse for compute resources. Available options are: "true" or "false". When the value is not set in the configuration the provider will put "default" there which means to use the Snowflake default for this value.
    fully_qualified_name str
    Fully qualified name of the resource. For more information, see object name resolution.
    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. Due to technical limitations (read more here), avoid using the following characters: |, ., (, ), "
    parameters Sequence[WarehouseParameterArgs]
    Outputs the result of SHOW PARAMETERS IN WAREHOUSE for the given warehouse.
    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. Valid values are (case-insensitive): STANDARD | ECONOMY.
    show_outputs Sequence[WarehouseShowOutputArgs]
    Outputs the result of SHOW WAREHOUSES for the given warehouse.
    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
    warehouse_size str
    Specifies the size of the virtual warehouse. Valid values are (case-insensitive): XSMALL | X-SMALL | SMALL | MEDIUM | LARGE | XLARGE | X-LARGE | XXLARGE | X2LARGE | 2X-LARGE | XXXLARGE | X3LARGE | 3X-LARGE | X4LARGE | 4X-LARGE | X5LARGE | 5X-LARGE | X6LARGE | 6X-LARGE. Consult warehouse documentation for the details. Note: removing the size from config will result in the resource recreation.
    warehouse_type str
    Specifies warehouse type. Valid values are (case-insensitive): STANDARD | SNOWPARK-OPTIMIZED. Warehouse needs to be suspended to change its type. Provider will handle automatic suspension and resumption if needed.
    autoResume String
    Specifies whether to automatically resume a warehouse when a SQL statement (e.g. query) is submitted to it. Available options are: "true" or "false". When the value is not set in the configuration the provider will put "default" there which means to use the Snowflake default for this value.
    autoSuspend Number
    Specifies the number of seconds of inactivity after which a warehouse is automatically suspended.
    comment String
    Specifies a comment for the warehouse.
    enableQueryAcceleration String
    Specifies whether to enable the query acceleration service for queries that rely on this warehouse for compute resources. Available options are: "true" or "false". When the value is not set in the configuration the provider will put "default" there which means to use the Snowflake default for this value.
    fullyQualifiedName String
    Fully qualified name of the resource. For more information, see object name resolution.
    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. Due to technical limitations (read more here), avoid using the following characters: |, ., (, ), "
    parameters List<Property Map>
    Outputs the result of SHOW PARAMETERS IN WAREHOUSE for the given warehouse.
    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. Valid values are (case-insensitive): STANDARD | ECONOMY.
    showOutputs List<Property Map>
    Outputs the result of SHOW WAREHOUSES for the given warehouse.
    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
    warehouseSize String
    Specifies the size of the virtual warehouse. Valid values are (case-insensitive): XSMALL | X-SMALL | SMALL | MEDIUM | LARGE | XLARGE | X-LARGE | XXLARGE | X2LARGE | 2X-LARGE | XXXLARGE | X3LARGE | 3X-LARGE | X4LARGE | 4X-LARGE | X5LARGE | 5X-LARGE | X6LARGE | 6X-LARGE. Consult warehouse documentation for the details. Note: removing the size from config will result in the resource recreation.
    warehouseType String
    Specifies warehouse type. Valid values are (case-insensitive): STANDARD | SNOWPARK-OPTIMIZED. Warehouse needs to be suspended to change its type. Provider will handle automatic suspension and resumption if needed.

    Supporting Types

    WarehouseParameter, WarehouseParameterArgs

    WarehouseParameterMaxConcurrencyLevel, WarehouseParameterMaxConcurrencyLevelArgs

    Default string
    Description string
    Key string
    Level string
    Value string
    Default string
    Description string
    Key string
    Level string
    Value string
    default_ String
    description String
    key String
    level String
    value String
    default string
    description string
    key string
    level string
    value string
    default String
    description String
    key String
    level String
    value String

    WarehouseParameterStatementQueuedTimeoutInSecond, WarehouseParameterStatementQueuedTimeoutInSecondArgs

    Default string
    Description string
    Key string
    Level string
    Value string
    Default string
    Description string
    Key string
    Level string
    Value string
    default_ String
    description String
    key String
    level String
    value String
    default string
    description string
    key string
    level string
    value string
    default String
    description String
    key String
    level String
    value String

    WarehouseParameterStatementTimeoutInSecond, WarehouseParameterStatementTimeoutInSecondArgs

    Default string
    Description string
    Key string
    Level string
    Value string
    Default string
    Description string
    Key string
    Level string
    Value string
    default_ String
    description String
    key String
    level String
    value String
    default string
    description string
    key string
    level string
    value string
    default String
    description String
    key String
    level String
    value String

    WarehouseShowOutput, WarehouseShowOutputArgs

    autoResume Boolean
    autoSuspend Integer
    available Double
    comment String
    createdOn String
    enableQueryAcceleration Boolean
    isCurrent Boolean
    isDefault Boolean
    maxClusterCount Integer
    minClusterCount Integer
    name String
    other Double
    owner String
    ownerRoleType String
    provisioning Double
    queryAccelerationMaxScaleFactor Integer
    queued Integer
    quiescing Double
    resourceMonitor String
    resumedOn String
    running Integer
    scalingPolicy String
    size String
    startedClusters Integer
    state String
    type String
    updatedOn String
    autoResume boolean
    autoSuspend number
    available number
    comment string
    createdOn string
    enableQueryAcceleration boolean
    isCurrent boolean
    isDefault boolean
    maxClusterCount number
    minClusterCount number
    name string
    other number
    owner string
    ownerRoleType string
    provisioning number
    queryAccelerationMaxScaleFactor number
    queued number
    quiescing number
    resourceMonitor string
    resumedOn string
    running number
    scalingPolicy string
    size string
    startedClusters number
    state string
    type string
    updatedOn string
    autoResume Boolean
    autoSuspend Number
    available Number
    comment String
    createdOn String
    enableQueryAcceleration Boolean
    isCurrent Boolean
    isDefault Boolean
    maxClusterCount Number
    minClusterCount Number
    name String
    other Number
    owner String
    ownerRoleType String
    provisioning Number
    queryAccelerationMaxScaleFactor Number
    queued Number
    quiescing Number
    resourceMonitor String
    resumedOn String
    running Number
    scalingPolicy String
    size String
    startedClusters Number
    state String
    type String
    updatedOn String

    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.59.0 published on Friday, Sep 20, 2024 by Pulumi