Snowflake v0.61.1, Nov 14 24

Snowflake v0.61.1 published on Thursday, Nov 14, 2024 by Pulumi

snowflake.Warehouse

Explore with Pulumi AI

Snowflake v0.61.1 published on Thursday, Nov 14, 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

In Python, inputs that are objects can be passed either as argument classes or as dictionary literals.

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.