Snowflake v0.59.0 published on Friday, Sep 20, 2024 by Pulumi
snowflake.Warehouse
Explore with Pulumi AI
Import
$ pulumi import snowflake:index/warehouse:Warehouse example warehouseName
Create Warehouse Resource
Resources are created with functions called constructors. To learn more about declaring and configuring resources, see Resources.
Constructor syntax
new Warehouse(name: string, args?: WarehouseArgs, opts?: CustomResourceOptions);
@overload
def Warehouse(resource_name: str,
args: Optional[WarehouseArgs] = None,
opts: Optional[ResourceOptions] = None)
@overload
def Warehouse(resource_name: str,
opts: Optional[ResourceOptions] = None,
auto_resume: Optional[str] = None,
auto_suspend: Optional[int] = None,
comment: Optional[str] = None,
enable_query_acceleration: Optional[str] = None,
initially_suspended: Optional[bool] = None,
max_cluster_count: Optional[int] = None,
max_concurrency_level: Optional[int] = None,
min_cluster_count: Optional[int] = None,
name: Optional[str] = None,
query_acceleration_max_scale_factor: Optional[int] = None,
resource_monitor: Optional[str] = None,
scaling_policy: Optional[str] = None,
statement_queued_timeout_in_seconds: Optional[int] = None,
statement_timeout_in_seconds: Optional[int] = None,
warehouse_size: Optional[str] = None,
warehouse_type: Optional[str] = None)
func NewWarehouse(ctx *Context, name string, args *WarehouseArgs, opts ...ResourceOption) (*Warehouse, error)
public Warehouse(string name, WarehouseArgs? args = null, CustomResourceOptions? opts = null)
public Warehouse(String name, WarehouseArgs args)
public Warehouse(String name, WarehouseArgs args, CustomResourceOptions options)
type: snowflake:Warehouse
properties: # The arguments to resource properties.
options: # Bag of options to control resource's behavior.
Parameters
- name string
- The unique name of the resource.
- args WarehouseArgs
- The arguments to resource properties.
- opts CustomResourceOptions
- Bag of options to control resource's behavior.
- resource_name str
- The unique name of the resource.
- args WarehouseArgs
- The arguments to resource properties.
- opts ResourceOptions
- Bag of options to control resource's behavior.
- ctx Context
- Context object for the current deployment.
- name string
- The unique name of the resource.
- args WarehouseArgs
- The arguments to resource properties.
- opts ResourceOption
- Bag of options to control resource's behavior.
- name string
- The unique name of the resource.
- args WarehouseArgs
- The arguments to resource properties.
- opts CustomResourceOptions
- Bag of options to control resource's behavior.
- name String
- The unique name of the resource.
- args WarehouseArgs
- The arguments to resource properties.
- options CustomResourceOptions
- Bag of options to control resource's behavior.
Constructor example
The following reference example uses placeholder values for all input properties.
var warehouseResource = new Snowflake.Warehouse("warehouseResource", new()
{
AutoResume = "string",
AutoSuspend = 0,
Comment = "string",
EnableQueryAcceleration = "string",
InitiallySuspended = false,
MaxClusterCount = 0,
MaxConcurrencyLevel = 0,
MinClusterCount = 0,
Name = "string",
QueryAccelerationMaxScaleFactor = 0,
ResourceMonitor = "string",
ScalingPolicy = "string",
StatementQueuedTimeoutInSeconds = 0,
StatementTimeoutInSeconds = 0,
WarehouseSize = "string",
WarehouseType = "string",
});
example, err := snowflake.NewWarehouse(ctx, "warehouseResource", &snowflake.WarehouseArgs{
AutoResume: pulumi.String("string"),
AutoSuspend: pulumi.Int(0),
Comment: pulumi.String("string"),
EnableQueryAcceleration: pulumi.String("string"),
InitiallySuspended: pulumi.Bool(false),
MaxClusterCount: pulumi.Int(0),
MaxConcurrencyLevel: pulumi.Int(0),
MinClusterCount: pulumi.Int(0),
Name: pulumi.String("string"),
QueryAccelerationMaxScaleFactor: pulumi.Int(0),
ResourceMonitor: pulumi.String("string"),
ScalingPolicy: pulumi.String("string"),
StatementQueuedTimeoutInSeconds: pulumi.Int(0),
StatementTimeoutInSeconds: pulumi.Int(0),
WarehouseSize: pulumi.String("string"),
WarehouseType: pulumi.String("string"),
})
var warehouseResource = new Warehouse("warehouseResource", WarehouseArgs.builder()
.autoResume("string")
.autoSuspend(0)
.comment("string")
.enableQueryAcceleration("string")
.initiallySuspended(false)
.maxClusterCount(0)
.maxConcurrencyLevel(0)
.minClusterCount(0)
.name("string")
.queryAccelerationMaxScaleFactor(0)
.resourceMonitor("string")
.scalingPolicy("string")
.statementQueuedTimeoutInSeconds(0)
.statementTimeoutInSeconds(0)
.warehouseSize("string")
.warehouseType("string")
.build());
warehouse_resource = snowflake.Warehouse("warehouseResource",
auto_resume="string",
auto_suspend=0,
comment="string",
enable_query_acceleration="string",
initially_suspended=False,
max_cluster_count=0,
max_concurrency_level=0,
min_cluster_count=0,
name="string",
query_acceleration_max_scale_factor=0,
resource_monitor="string",
scaling_policy="string",
statement_queued_timeout_in_seconds=0,
statement_timeout_in_seconds=0,
warehouse_size="string",
warehouse_type="string")
const warehouseResource = new snowflake.Warehouse("warehouseResource", {
autoResume: "string",
autoSuspend: 0,
comment: "string",
enableQueryAcceleration: "string",
initiallySuspended: false,
maxClusterCount: 0,
maxConcurrencyLevel: 0,
minClusterCount: 0,
name: "string",
queryAccelerationMaxScaleFactor: 0,
resourceMonitor: "string",
scalingPolicy: "string",
statementQueuedTimeoutInSeconds: 0,
statementTimeoutInSeconds: 0,
warehouseSize: "string",
warehouseType: "string",
});
type: snowflake:Warehouse
properties:
autoResume: string
autoSuspend: 0
comment: string
enableQueryAcceleration: string
initiallySuspended: false
maxClusterCount: 0
maxConcurrencyLevel: 0
minClusterCount: 0
name: string
queryAccelerationMaxScaleFactor: 0
resourceMonitor: string
scalingPolicy: string
statementQueuedTimeoutInSeconds: 0
statementTimeoutInSeconds: 0
warehouseSize: string
warehouseType: string
Warehouse Resource Properties
To learn more about resource properties and how to use them, see Inputs and Outputs in the Architecture and Concepts docs.
Inputs
The Warehouse resource accepts the following input properties:
- Auto
Resume 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.
- Auto
Suspend int - Specifies the number of seconds of inactivity after which a warehouse is automatically suspended.
- Comment string
- Specifies a comment for the warehouse.
- Enable
Query stringAcceleration - 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 intCount - Specifies the maximum number of server clusters for the warehouse.
- Max
Concurrency intLevel - Object parameter that specifies the concurrency level for SQL statements (i.e. queries and DML) executed by a warehouse.
- Min
Cluster intCount - 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:
|
,.
,(
,)
,"
- Query
Acceleration intMax Scale Factor - 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 string - Specifies the name of a resource monitor that is explicitly assigned to the warehouse.
- Scaling
Policy 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
. - Statement
Queued intTimeout In Seconds - 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 intIn Seconds - Specifies the time, in seconds, after which a running SQL statement (query, DDL, DML, etc.) is canceled by the system
- Warehouse
Size 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. - Warehouse
Type 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 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.
- Auto
Suspend int - Specifies the number of seconds of inactivity after which a warehouse is automatically suspended.
- Comment string
- Specifies a comment for the warehouse.
- Enable
Query stringAcceleration - 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 intCount - Specifies the maximum number of server clusters for the warehouse.
- Max
Concurrency intLevel - Object parameter that specifies the concurrency level for SQL statements (i.e. queries and DML) executed by a warehouse.
- Min
Cluster intCount - 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:
|
,.
,(
,)
,"
- Query
Acceleration intMax Scale Factor - 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 string - Specifies the name of a resource monitor that is explicitly assigned to the warehouse.
- Scaling
Policy 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
. - Statement
Queued intTimeout In Seconds - 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 intIn Seconds - Specifies the time, in seconds, after which a running SQL statement (query, DDL, DML, etc.) is canceled by the system
- Warehouse
Size 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. - Warehouse
Type 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 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.
- auto
Suspend Integer - Specifies the number of seconds of inactivity after which a warehouse is automatically suspended.
- comment String
- Specifies a comment for the warehouse.
- enable
Query StringAcceleration - 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 Boolean - Specifies whether the warehouse is created initially in the ‘Suspended’ state.
- max
Cluster IntegerCount - Specifies the maximum number of server clusters for the warehouse.
- max
Concurrency IntegerLevel - Object parameter that specifies the concurrency level for SQL statements (i.e. queries and DML) executed by a warehouse.
- min
Cluster IntegerCount - 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:
|
,.
,(
,)
,"
- query
Acceleration IntegerMax Scale Factor - 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 String - Specifies the name of a resource monitor that is explicitly assigned to the warehouse.
- scaling
Policy 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
. - statement
Queued IntegerTimeout In Seconds - 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 IntegerIn Seconds - Specifies the time, in seconds, after which a running SQL statement (query, DDL, DML, etc.) is canceled by the system
- warehouse
Size 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. - warehouse
Type 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 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.
- auto
Suspend number - Specifies the number of seconds of inactivity after which a warehouse is automatically suspended.
- comment string
- Specifies a comment for the warehouse.
- enable
Query stringAcceleration - 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 boolean - Specifies whether the warehouse is created initially in the ‘Suspended’ state.
- max
Cluster numberCount - Specifies the maximum number of server clusters for the warehouse.
- max
Concurrency numberLevel - Object parameter that specifies the concurrency level for SQL statements (i.e. queries and DML) executed by a warehouse.
- min
Cluster numberCount - 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:
|
,.
,(
,)
,"
- query
Acceleration numberMax Scale Factor - 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 string - Specifies the name of a resource monitor that is explicitly assigned to the warehouse.
- scaling
Policy 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
. - statement
Queued numberTimeout In Seconds - 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 numberIn Seconds - Specifies the time, in seconds, after which a running SQL statement (query, DDL, DML, etc.) is canceled by the system
- warehouse
Size 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. - warehouse
Type 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_ stracceleration - 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_ intcount - Specifies the maximum number of server clusters for the warehouse.
- max_
concurrency_ intlevel - Object parameter that specifies the concurrency level for SQL statements (i.e. queries and DML) executed by a warehouse.
- min_
cluster_ intcount - 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_ intmax_ scale_ factor - 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_ inttimeout_ in_ seconds - 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_ intin_ seconds - 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.
- auto
Resume 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.
- auto
Suspend Number - Specifies the number of seconds of inactivity after which a warehouse is automatically suspended.
- comment String
- Specifies a comment for the warehouse.
- enable
Query StringAcceleration - 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 Boolean - Specifies whether the warehouse is created initially in the ‘Suspended’ state.
- max
Cluster NumberCount - Specifies the maximum number of server clusters for the warehouse.
- max
Concurrency NumberLevel - Object parameter that specifies the concurrency level for SQL statements (i.e. queries and DML) executed by a warehouse.
- min
Cluster NumberCount - 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:
|
,.
,(
,)
,"
- query
Acceleration NumberMax Scale Factor - 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 String - Specifies the name of a resource monitor that is explicitly assigned to the warehouse.
- scaling
Policy 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
. - statement
Queued NumberTimeout In Seconds - 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 NumberIn Seconds - Specifies the time, in seconds, after which a running SQL statement (query, DDL, DML, etc.) is canceled by the system
- warehouse
Size 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. - warehouse
Type 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:
- Fully
Qualified stringName - 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<Warehouse
Parameter> - Outputs the result of
SHOW PARAMETERS IN WAREHOUSE
for the given warehouse. - Show
Outputs List<WarehouseShow Output> - Outputs the result of
SHOW WAREHOUSES
for the given warehouse.
- Fully
Qualified stringName - 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
[]Warehouse
Parameter - Outputs the result of
SHOW PARAMETERS IN WAREHOUSE
for the given warehouse. - Show
Outputs []WarehouseShow Output - Outputs the result of
SHOW WAREHOUSES
for the given warehouse.
- fully
Qualified StringName - 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<Warehouse
Parameter> - Outputs the result of
SHOW PARAMETERS IN WAREHOUSE
for the given warehouse. - show
Outputs List<WarehouseShow Output> - Outputs the result of
SHOW WAREHOUSES
for the given warehouse.
- fully
Qualified stringName - 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
Warehouse
Parameter[] - Outputs the result of
SHOW PARAMETERS IN WAREHOUSE
for the given warehouse. - show
Outputs WarehouseShow Output[] - Outputs the result of
SHOW WAREHOUSES
for the given warehouse.
- fully_
qualified_ strname - 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[Warehouse
Parameter] - Outputs the result of
SHOW PARAMETERS IN WAREHOUSE
for the given warehouse. - show_
outputs Sequence[WarehouseShow Output] - Outputs the result of
SHOW WAREHOUSES
for the given warehouse.
- fully
Qualified StringName - 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. - show
Outputs 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.
- Auto
Resume 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.
- Auto
Suspend int - Specifies the number of seconds of inactivity after which a warehouse is automatically suspended.
- Comment string
- Specifies a comment for the warehouse.
- Enable
Query stringAcceleration - 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 stringName - 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 intCount - Specifies the maximum number of server clusters for the warehouse.
- Max
Concurrency intLevel - Object parameter that specifies the concurrency level for SQL statements (i.e. queries and DML) executed by a warehouse.
- Min
Cluster intCount - 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<Warehouse
Parameter> - Outputs the result of
SHOW PARAMETERS IN WAREHOUSE
for the given warehouse. - Query
Acceleration intMax Scale Factor - 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 string - Specifies the name of a resource monitor that is explicitly assigned to the warehouse.
- Scaling
Policy 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
. - Show
Outputs List<WarehouseShow Output> - Outputs the result of
SHOW WAREHOUSES
for the given warehouse. - Statement
Queued intTimeout In Seconds - 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 intIn Seconds - Specifies the time, in seconds, after which a running SQL statement (query, DDL, DML, etc.) is canceled by the system
- Warehouse
Size 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. - Warehouse
Type 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 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.
- Auto
Suspend int - Specifies the number of seconds of inactivity after which a warehouse is automatically suspended.
- Comment string
- Specifies a comment for the warehouse.
- Enable
Query stringAcceleration - 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 stringName - 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 intCount - Specifies the maximum number of server clusters for the warehouse.
- Max
Concurrency intLevel - Object parameter that specifies the concurrency level for SQL statements (i.e. queries and DML) executed by a warehouse.
- Min
Cluster intCount - 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
[]Warehouse
Parameter Args - Outputs the result of
SHOW PARAMETERS IN WAREHOUSE
for the given warehouse. - Query
Acceleration intMax Scale Factor - 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 string - Specifies the name of a resource monitor that is explicitly assigned to the warehouse.
- Scaling
Policy 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
. - Show
Outputs []WarehouseShow Output Args - Outputs the result of
SHOW WAREHOUSES
for the given warehouse. - Statement
Queued intTimeout In Seconds - 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 intIn Seconds - Specifies the time, in seconds, after which a running SQL statement (query, DDL, DML, etc.) is canceled by the system
- Warehouse
Size 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. - Warehouse
Type 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 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.
- auto
Suspend Integer - Specifies the number of seconds of inactivity after which a warehouse is automatically suspended.
- comment String
- Specifies a comment for the warehouse.
- enable
Query StringAcceleration - 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 StringName - Fully qualified name of the resource. For more information, see object name resolution.
- initially
Suspended Boolean - Specifies whether the warehouse is created initially in the ‘Suspended’ state.
- max
Cluster IntegerCount - Specifies the maximum number of server clusters for the warehouse.
- max
Concurrency IntegerLevel - Object parameter that specifies the concurrency level for SQL statements (i.e. queries and DML) executed by a warehouse.
- min
Cluster IntegerCount - 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<Warehouse
Parameter> - Outputs the result of
SHOW PARAMETERS IN WAREHOUSE
for the given warehouse. - query
Acceleration IntegerMax Scale Factor - 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 String - Specifies the name of a resource monitor that is explicitly assigned to the warehouse.
- scaling
Policy 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
. - show
Outputs List<WarehouseShow Output> - Outputs the result of
SHOW WAREHOUSES
for the given warehouse. - statement
Queued IntegerTimeout In Seconds - 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 IntegerIn Seconds - Specifies the time, in seconds, after which a running SQL statement (query, DDL, DML, etc.) is canceled by the system
- warehouse
Size 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. - warehouse
Type 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 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.
- auto
Suspend number - Specifies the number of seconds of inactivity after which a warehouse is automatically suspended.
- comment string
- Specifies a comment for the warehouse.
- enable
Query stringAcceleration - 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 stringName - Fully qualified name of the resource. For more information, see object name resolution.
- initially
Suspended boolean - Specifies whether the warehouse is created initially in the ‘Suspended’ state.
- max
Cluster numberCount - Specifies the maximum number of server clusters for the warehouse.
- max
Concurrency numberLevel - Object parameter that specifies the concurrency level for SQL statements (i.e. queries and DML) executed by a warehouse.
- min
Cluster numberCount - 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
Warehouse
Parameter[] - Outputs the result of
SHOW PARAMETERS IN WAREHOUSE
for the given warehouse. - query
Acceleration numberMax Scale Factor - 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 string - Specifies the name of a resource monitor that is explicitly assigned to the warehouse.
- scaling
Policy 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
. - show
Outputs WarehouseShow Output[] - Outputs the result of
SHOW WAREHOUSES
for the given warehouse. - statement
Queued numberTimeout In Seconds - 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 numberIn Seconds - Specifies the time, in seconds, after which a running SQL statement (query, DDL, DML, etc.) is canceled by the system
- warehouse
Size 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. - warehouse
Type 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_ stracceleration - 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_ strname - 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_ intcount - Specifies the maximum number of server clusters for the warehouse.
- max_
concurrency_ intlevel - Object parameter that specifies the concurrency level for SQL statements (i.e. queries and DML) executed by a warehouse.
- min_
cluster_ intcount - 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[Warehouse
Parameter Args] - Outputs the result of
SHOW PARAMETERS IN WAREHOUSE
for the given warehouse. - query_
acceleration_ intmax_ scale_ factor - 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[WarehouseShow Output Args] - Outputs the result of
SHOW WAREHOUSES
for the given warehouse. - statement_
queued_ inttimeout_ in_ seconds - 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_ intin_ seconds - 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.
- auto
Resume 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.
- auto
Suspend Number - Specifies the number of seconds of inactivity after which a warehouse is automatically suspended.
- comment String
- Specifies a comment for the warehouse.
- enable
Query StringAcceleration - 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 StringName - Fully qualified name of the resource. For more information, see object name resolution.
- initially
Suspended Boolean - Specifies whether the warehouse is created initially in the ‘Suspended’ state.
- max
Cluster NumberCount - Specifies the maximum number of server clusters for the warehouse.
- max
Concurrency NumberLevel - Object parameter that specifies the concurrency level for SQL statements (i.e. queries and DML) executed by a warehouse.
- min
Cluster NumberCount - 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. - query
Acceleration NumberMax Scale Factor - 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 String - Specifies the name of a resource monitor that is explicitly assigned to the warehouse.
- scaling
Policy 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
. - show
Outputs List<Property Map> - Outputs the result of
SHOW WAREHOUSES
for the given warehouse. - statement
Queued NumberTimeout In Seconds - 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 NumberIn Seconds - Specifies the time, in seconds, after which a running SQL statement (query, DDL, DML, etc.) is canceled by the system
- warehouse
Size 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. - warehouse
Type String - Specifies warehouse type. Valid values are (case-insensitive):
STANDARD
|SNOWPARK-OPTIMIZED
. Warehouse needs to be suspended to change its type. Provider will handle automatic suspension and resumption if needed.
Supporting Types
WarehouseParameter, WarehouseParameterArgs
WarehouseParameterMaxConcurrencyLevel, WarehouseParameterMaxConcurrencyLevelArgs
- Default string
- Description string
- Key string
- Level string
- Value string
- Default string
- Description string
- Key string
- Level string
- Value string
- default_ String
- description String
- key String
- level String
- value String
- default string
- description string
- key string
- level string
- value string
- default 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
- Auto
Resume bool - Auto
Suspend int - Available double
- Comment string
- Created
On string - Enable
Query boolAcceleration - Is
Current bool - Is
Default bool - Max
Cluster intCount - Min
Cluster intCount - Name string
- Other double
- Owner string
- Owner
Role stringType - Provisioning double
- Query
Acceleration intMax Scale Factor - Queued int
- Quiescing double
- Resource
Monitor string - Resumed
On string - Running int
- Scaling
Policy string - Size string
- Started
Clusters int - State string
- Type string
- Updated
On string
- Auto
Resume bool - Auto
Suspend int - Available float64
- Comment string
- Created
On string - Enable
Query boolAcceleration - Is
Current bool - Is
Default bool - Max
Cluster intCount - Min
Cluster intCount - Name string
- Other float64
- Owner string
- Owner
Role stringType - Provisioning float64
- Query
Acceleration intMax Scale Factor - Queued int
- Quiescing float64
- Resource
Monitor string - Resumed
On string - Running int
- Scaling
Policy string - Size string
- Started
Clusters int - State string
- Type string
- Updated
On string
- auto
Resume Boolean - auto
Suspend Integer - available Double
- comment String
- created
On String - enable
Query BooleanAcceleration - is
Current Boolean - is
Default Boolean - max
Cluster IntegerCount - min
Cluster IntegerCount - name String
- other Double
- owner String
- owner
Role StringType - provisioning Double
- query
Acceleration IntegerMax Scale Factor - queued Integer
- quiescing Double
- resource
Monitor String - resumed
On String - running Integer
- scaling
Policy String - size String
- started
Clusters Integer - state String
- type String
- updated
On String
- auto
Resume boolean - auto
Suspend number - available number
- comment string
- created
On string - enable
Query booleanAcceleration - is
Current boolean - is
Default boolean - max
Cluster numberCount - min
Cluster numberCount - name string
- other number
- owner string
- owner
Role stringType - provisioning number
- query
Acceleration numberMax Scale Factor - queued number
- quiescing number
- resource
Monitor string - resumed
On string - running number
- scaling
Policy string - size string
- started
Clusters number - state string
- type string
- updated
On string
- auto_
resume bool - auto_
suspend int - available float
- comment str
- created_
on str - enable_
query_ boolacceleration - is_
current bool - is_
default bool - max_
cluster_ intcount - min_
cluster_ intcount - name str
- other float
- owner str
- owner_
role_ strtype - provisioning float
- query_
acceleration_ intmax_ scale_ factor - 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
- auto
Resume Boolean - auto
Suspend Number - available Number
- comment String
- created
On String - enable
Query BooleanAcceleration - is
Current Boolean - is
Default Boolean - max
Cluster NumberCount - min
Cluster NumberCount - name String
- other Number
- owner String
- owner
Role StringType - provisioning Number
- query
Acceleration NumberMax Scale Factor - queued Number
- quiescing Number
- resource
Monitor String - resumed
On String - running Number
- scaling
Policy String - size String
- started
Clusters Number - state String
- type String
- updated
On String
Package Details
- Repository
- Snowflake pulumi/pulumi-snowflake
- License
- Apache-2.0
- Notes
- This Pulumi package is based on the
snowflake
Terraform Provider.