Snowflake v0.56.0, Jul 22 24

Snowflake v0.56.0 published on Monday, Jul 22, 2024 by Pulumi

snowflake.Warehouse

Explore with Pulumi AI

Snowflake v0.56.0 published on Monday, Jul 22, 2024 by Pulumi

!> V1 release candidate This resource was reworked and is a release candidate for the V1. We do not expect significant changes in it before the V1. We will welcome any feedback and adjust the resource if needed. Any errors reported will be resolved with a higher priority. We encourage checking this resource out before the V1 release. Please follow the migration guide to use it.

Resource used to manage warehouse objects. For more information, check warehouse documentation.

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[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.
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.
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.
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.
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.
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.
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:

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 WAREHOUSE for the given warehouse.

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 WAREHOUSE for the given warehouse.

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 WAREHOUSE for the given warehouse.

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 WAREHOUSE for the given warehouse.

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 WAREHOUSE for the given warehouse.

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 WAREHOUSE 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,
        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.
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.
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 WAREHOUSE 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.
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.
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 WAREHOUSE 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.
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.
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 WAREHOUSE 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.
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.
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 WAREHOUSE 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.
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.
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 WAREHOUSE 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.
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.
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 WAREHOUSE 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

MaxConcurrencyLevels List<WarehouseParameterMaxConcurrencyLevel>
StatementQueuedTimeoutInSeconds List<WarehouseParameterStatementQueuedTimeoutInSecond>
StatementTimeoutInSeconds List<WarehouseParameterStatementTimeoutInSecond>

MaxConcurrencyLevels []WarehouseParameterMaxConcurrencyLevel
StatementQueuedTimeoutInSeconds []WarehouseParameterStatementQueuedTimeoutInSecond
StatementTimeoutInSeconds []WarehouseParameterStatementTimeoutInSecond

maxConcurrencyLevels List<WarehouseParameterMaxConcurrencyLevel>
statementQueuedTimeoutInSeconds List<WarehouseParameterStatementQueuedTimeoutInSecond>
statementTimeoutInSeconds List<WarehouseParameterStatementTimeoutInSecond>

maxConcurrencyLevels WarehouseParameterMaxConcurrencyLevel[]
statementQueuedTimeoutInSeconds WarehouseParameterStatementQueuedTimeoutInSecond[]
statementTimeoutInSeconds WarehouseParameterStatementTimeoutInSecond[]

max_concurrency_levels Sequence[WarehouseParameterMaxConcurrencyLevel]
statement_queued_timeout_in_seconds Sequence[WarehouseParameterStatementQueuedTimeoutInSecond]
statement_timeout_in_seconds Sequence[WarehouseParameterStatementTimeoutInSecond]

maxConcurrencyLevels List<Property Map>
statementQueuedTimeoutInSeconds List<Property Map>
statementTimeoutInSeconds List<Property Map>

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 str
description str
key str
level str
value str

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 str
description str
key str
level str
value str

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 str
description str
key str
level str
value str

default String
description String
key String
level String
value String

WarehouseShowOutput, WarehouseShowOutputArgs

AutoResume bool
AutoSuspend int
Available double
Comment string
CreatedOn string
EnableQueryAcceleration bool
IsCurrent bool
IsDefault bool
MaxClusterCount int
MinClusterCount int
Name string
Other double
Owner string
OwnerRoleType string
Provisioning double
QueryAccelerationMaxScaleFactor int
Queued int
Quiescing double
ResourceMonitor string
ResumedOn string
Running int
ScalingPolicy string
Size string
StartedClusters int
State string
Type string
UpdatedOn string

AutoResume bool
AutoSuspend int
Available float64
Comment string
CreatedOn string
EnableQueryAcceleration bool
IsCurrent bool
IsDefault bool
MaxClusterCount int
MinClusterCount int
Name string
Other float64
Owner string
OwnerRoleType string
Provisioning float64
QueryAccelerationMaxScaleFactor int
Queued int
Quiescing float64
ResourceMonitor string
ResumedOn string
Running int
ScalingPolicy string
Size string
StartedClusters int
State string
Type string
UpdatedOn string

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

auto_resume bool
auto_suspend int
available float
comment str
created_on str
enable_query_acceleration bool
is_current bool
is_default bool
max_cluster_count int
min_cluster_count int
name str
other float
owner str
owner_role_type str
provisioning float
query_acceleration_max_scale_factor int
queued int
quiescing float
resource_monitor str
resumed_on str
running int
scaling_policy str
size str
started_clusters int
state str
type str
updated_on str

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

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 v0.56.0 published on Monday, Jul 22, 2024 by Pulumi

pulumi/pulumi-snowflake

snowflake.Warehouse

On this page

On this page

Example Usage

Create Warehouse Resource

Constructor syntax

Parameters

Constructor example

Warehouse Resource Properties

Inputs

Outputs

Look up Existing Warehouse Resource

Supporting Types

WarehouseParameter, WarehouseParameterArgs

WarehouseParameterMaxConcurrencyLevel, WarehouseParameterMaxConcurrencyLevelArgs

WarehouseParameterStatementQueuedTimeoutInSecond, WarehouseParameterStatementQueuedTimeoutInSecondArgs

WarehouseParameterStatementTimeoutInSecond, WarehouseParameterStatementTimeoutInSecondArgs

WarehouseShowOutput, WarehouseShowOutputArgs

Import

Package Details

On this page

On this page