snowflake.WarehouseInteractive

Snowflake v2.19.0, Jul 31 26

Viewing docs for Snowflake v2.19.0
published on Friday, Jul 31, 2026 by Pulumi

Schema (JSON)

pulumi/pulumi-snowflake

Viewing docs for Snowflake v2.19.0
published on Friday, Jul 31, 2026 by Pulumi

Schema (JSON)

pulumi/pulumi-snowflake

Caution: Preview Feature This feature is considered a preview feature in the provider, regardless of the state of the resource in Snowflake. We do not guarantee its stability. It will be reworked and marked as a stable feature in future releases. Breaking changes are expected, even without bumping the major version. To use this feature, add the relevant feature name to previewFeaturesEnabled field in the provider configuration. Please always refer to the Getting Help section in our Github repo to best determine how to get help for your questions.

Resource used to manage interactive warehouse objects. Interactive warehouses are optimized for low-latency, high-concurrency queries against a defined set of tables. For more information, check interactive warehouse documentation.

Example Usage

import * as pulumi from "@pulumi/pulumi";
import * as snowflake from "@pulumi/snowflake";

// Basic interactive warehouse (only required fields)
const basic = new snowflake.WarehouseInteractive("basic", {name: "my_interactive_warehouse"});
// Complete interactive warehouse (all fields set)
const complete = new snowflake.WarehouseInteractive("complete", {
    name: "my_interactive_warehouse_complete",
    comment: "My interactive warehouse with all options set",
    warehouseSize: "XSMALL",
    maxClusterCount: 2,
    minClusterCount: 1,
    autoSuspend: 86400,
    autoResume: "true",
    initiallySuspended: true,
    resourceMonitor: monitor.fullyQualifiedName,
    fallbackWarehouse: fallback.fullyQualifiedName,
    tables: [
        "\"MY_DB\".\"MY_SCHEMA\".\"MY_TABLE_1\"",
        "\"MY_DB\".\"MY_SCHEMA\".\"MY_TABLE_2\"",
    ],
    maxConcurrencyLevel: 8,
    statementQueuedTimeoutInSeconds: 30,
    statementTimeoutInSeconds: 5,
});

import pulumi
import pulumi_snowflake as snowflake

# Basic interactive warehouse (only required fields)
basic = snowflake.WarehouseInteractive("basic", name="my_interactive_warehouse")
# Complete interactive warehouse (all fields set)
complete = snowflake.WarehouseInteractive("complete",
    name="my_interactive_warehouse_complete",
    comment="My interactive warehouse with all options set",
    warehouse_size="XSMALL",
    max_cluster_count=2,
    min_cluster_count=1,
    auto_suspend=86400,
    auto_resume="true",
    initially_suspended=True,
    resource_monitor=monitor["fullyQualifiedName"],
    fallback_warehouse=fallback["fullyQualifiedName"],
    tables=[
        "\"MY_DB\".\"MY_SCHEMA\".\"MY_TABLE_1\"",
        "\"MY_DB\".\"MY_SCHEMA\".\"MY_TABLE_2\"",
    ],
    max_concurrency_level=8,
    statement_queued_timeout_in_seconds=30,
    statement_timeout_in_seconds=5)

package main

import (
	"github.com/pulumi/pulumi-snowflake/sdk/v2/go/snowflake"
	"github.com/pulumi/pulumi/sdk/v3/go/pulumi"
)

func main() {
	pulumi.Run(func(ctx *pulumi.Context) error {
		// Basic interactive warehouse (only required fields)
		_, err := snowflake.NewWarehouseInteractive(ctx, "basic", &snowflake.WarehouseInteractiveArgs{
			Name: pulumi.String("my_interactive_warehouse"),
		})
		if err != nil {
			return err
		}
		// Complete interactive warehouse (all fields set)
		_, err = snowflake.NewWarehouseInteractive(ctx, "complete", &snowflake.WarehouseInteractiveArgs{
			Name:               pulumi.String("my_interactive_warehouse_complete"),
			Comment:            pulumi.String("My interactive warehouse with all options set"),
			WarehouseSize:      pulumi.String("XSMALL"),
			MaxClusterCount:    pulumi.Int(2),
			MinClusterCount:    pulumi.Int(1),
			AutoSuspend:        pulumi.Int(86400),
			AutoResume:         pulumi.String("true"),
			InitiallySuspended: pulumi.Bool(true),
			ResourceMonitor:    pulumi.Any(monitor.FullyQualifiedName),
			FallbackWarehouse:  pulumi.Any(fallback.FullyQualifiedName),
			Tables: pulumi.StringArray{
				pulumi.String("\"MY_DB\".\"MY_SCHEMA\".\"MY_TABLE_1\""),
				pulumi.String("\"MY_DB\".\"MY_SCHEMA\".\"MY_TABLE_2\""),
			},
			MaxConcurrencyLevel:             pulumi.Int(8),
			StatementQueuedTimeoutInSeconds: pulumi.Int(30),
			StatementTimeoutInSeconds:       pulumi.Int(5),
		})
		if err != nil {
			return err
		}
		return nil
	})
}

using System.Collections.Generic;
using System.Linq;
using Pulumi;
using Snowflake = Pulumi.Snowflake;

return await Deployment.RunAsync(() => 
{
    // Basic interactive warehouse (only required fields)
    var basic = new Snowflake.WarehouseInteractive("basic", new()
    {
        Name = "my_interactive_warehouse",
    });

    // Complete interactive warehouse (all fields set)
    var complete = new Snowflake.WarehouseInteractive("complete", new()
    {
        Name = "my_interactive_warehouse_complete",
        Comment = "My interactive warehouse with all options set",
        WarehouseSize = "XSMALL",
        MaxClusterCount = 2,
        MinClusterCount = 1,
        AutoSuspend = 86400,
        AutoResume = "true",
        InitiallySuspended = true,
        ResourceMonitor = monitor.FullyQualifiedName,
        FallbackWarehouse = fallback.FullyQualifiedName,
        Tables = new[]
        {
            "\"MY_DB\".\"MY_SCHEMA\".\"MY_TABLE_1\"",
            "\"MY_DB\".\"MY_SCHEMA\".\"MY_TABLE_2\"",
        },
        MaxConcurrencyLevel = 8,
        StatementQueuedTimeoutInSeconds = 30,
        StatementTimeoutInSeconds = 5,
    });

});

package generated_program;

import com.pulumi.Context;
import com.pulumi.Pulumi;
import com.pulumi.core.Output;
import com.pulumi.snowflake.WarehouseInteractive;
import com.pulumi.snowflake.WarehouseInteractiveArgs;
import java.util.ArrayList;
import java.util.Arrays;
import java.util.Map;
import java.io.File;
import java.nio.file.Files;
import java.nio.file.Paths;

public class App {
    public static void main(String[] args) {
        Pulumi.run(App::stack);
    }

    public static void stack(Context ctx) {
        // Basic interactive warehouse (only required fields)
        var basic = new WarehouseInteractive("basic", WarehouseInteractiveArgs.builder()
            .name("my_interactive_warehouse")
            .build());

        // Complete interactive warehouse (all fields set)
        var complete = new WarehouseInteractive("complete", WarehouseInteractiveArgs.builder()
            .name("my_interactive_warehouse_complete")
            .comment("My interactive warehouse with all options set")
            .warehouseSize("XSMALL")
            .maxClusterCount(2)
            .minClusterCount(1)
            .autoSuspend(86400)
            .autoResume("true")
            .initiallySuspended(true)
            .resourceMonitor(monitor.fullyQualifiedName())
            .fallbackWarehouse(fallback.fullyQualifiedName())
            .tables(            
                "\"MY_DB\".\"MY_SCHEMA\".\"MY_TABLE_1\"",
                "\"MY_DB\".\"MY_SCHEMA\".\"MY_TABLE_2\"")
            .maxConcurrencyLevel(8)
            .statementQueuedTimeoutInSeconds(30)
            .statementTimeoutInSeconds(5)
            .build());

    }
}

resources:
  # Basic interactive warehouse (only required fields)
  basic:
    type: snowflake:WarehouseInteractive
    properties:
      name: my_interactive_warehouse
  # Complete interactive warehouse (all fields set)
  complete:
    type: snowflake:WarehouseInteractive
    properties:
      name: my_interactive_warehouse_complete
      comment: My interactive warehouse with all options set
      warehouseSize: XSMALL
      maxClusterCount: 2
      minClusterCount: 1
      autoSuspend: 86400
      autoResume: 'true'
      initiallySuspended: true
      resourceMonitor: ${monitor.fullyQualifiedName}
      fallbackWarehouse: ${fallback.fullyQualifiedName}
      tables:
        - '"MY_DB"."MY_SCHEMA"."MY_TABLE_1"'
        - '"MY_DB"."MY_SCHEMA"."MY_TABLE_2"'
      maxConcurrencyLevel: 8
      statementQueuedTimeoutInSeconds: 30
      statementTimeoutInSeconds: 5

pulumi {
  required_providers {
    snowflake = {
      source = "pulumi/snowflake"
    }
  }
}

# Basic interactive warehouse (only required fields)
resource "snowflake_warehouseinteractive" "basic" {
  name = "my_interactive_warehouse"
}
# Complete interactive warehouse (all fields set)
resource "snowflake_warehouseinteractive" "complete" {
  name                                = "my_interactive_warehouse_complete"
  comment                             = "My interactive warehouse with all options set"
  warehouse_size                      = "XSMALL"
  max_cluster_count                   = 2
  min_cluster_count                   = 1
  auto_suspend                        = 86400
  auto_resume                         = "true"
  initially_suspended                 = true
  resource_monitor                    = monitor.fullyQualifiedName
  fallback_warehouse                  = fallback.fullyQualifiedName
  tables                              = ["\"MY_DB\".\"MY_SCHEMA\".\"MY_TABLE_1\"", "\"MY_DB\".\"MY_SCHEMA\".\"MY_TABLE_2\""]
  max_concurrency_level               = 8
  statement_queued_timeout_in_seconds = 30
  statement_timeout_in_seconds        = 5
}

Note Instead of using fully_qualified_name, you can reference objects managed outside Terraform by constructing a correct ID, consult identifiers guide.

Note If a field has a default value, it is shown next to the type in the schema.

Interactive warehouse limitations

Interactive warehouses differ from standard warehouses in a few ways that affect how this resource behaves:

autoSuspend has a Snowflake-enforced minimum for interactive warehouses (currently 86400 seconds). The provider does not validate this on the client side (the limit is server-side and may change), so Snowflake will reject values below the current minimum at apply time.
tables associations are applied incrementally with ADD TABLES / DROP TABLES (only the changed entries), rather than by re-associating the full set on every change.
fallbackWarehouse is specific to interactive warehouses; it is not available on standard warehouses (snowflake.Warehouse).
Standard-warehouse-only properties (scalingPolicy, enableQueryAcceleration, queryAccelerationMaxScaleFactor, resourceConstraint, generation) are intentionally omitted from the schema; configuring them yields a plan-time “unsupported argument” error.
warehouseSize cannot be changed with ALTER while the warehouse is running, so a resize briefly suspends the warehouse, applies the new size, and resumes it. Removing warehouseSize from the config recreates the resource, because Snowflake has no UNSET WAREHOUSE_SIZE to fall back to the account default.
The warehouse type cannot be changed to or from INTERACTIVE with ALTER. If the underlying warehouse type changes externally, the only way to reconcile is to recreate the resource.

Create WarehouseInteractive Resource

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

Constructor syntax

new WarehouseInteractive(name: string, args?: WarehouseInteractiveArgs, opts?: CustomResourceOptions);

@overload
def WarehouseInteractive(resource_name: str,
                         args: Optional[WarehouseInteractiveArgs] = None,
                         opts: Optional[ResourceOptions] = None)

@overload
def WarehouseInteractive(resource_name: str,
                         opts: Optional[ResourceOptions] = None,
                         auto_resume: Optional[str] = None,
                         auto_suspend: Optional[int] = None,
                         comment: Optional[str] = None,
                         fallback_warehouse: 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,
                         resource_monitor: Optional[str] = None,
                         statement_queued_timeout_in_seconds: Optional[int] = None,
                         statement_timeout_in_seconds: Optional[int] = None,
                         tables: Optional[Sequence[str]] = None,
                         warehouse_size: Optional[str] = None)

func NewWarehouseInteractive(ctx *Context, name string, args *WarehouseInteractiveArgs, opts ...ResourceOption) (*WarehouseInteractive, error)

public WarehouseInteractive(string name, WarehouseInteractiveArgs? args = null, CustomResourceOptions? opts = null)

public WarehouseInteractive(String name, WarehouseInteractiveArgs args)
public WarehouseInteractive(String name, WarehouseInteractiveArgs args, CustomResourceOptions options)

type: snowflake:WarehouseInteractive
properties: # The arguments to resource properties.
options: # Bag of options to control resource's behavior.

resource "snowflake_warehouse_interactive" "name" {
    # resource properties
}

Parameters

name string: The unique name of the resource.
args WarehouseInteractiveArgs: 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 WarehouseInteractiveArgs: 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 WarehouseInteractiveArgs: The arguments to resource properties.
opts ResourceOption: Bag of options to control resource's behavior.

name string: The unique name of the resource.
args WarehouseInteractiveArgs: The arguments to resource properties.
opts CustomResourceOptions: Bag of options to control resource's behavior.

name String: The unique name of the resource.
args WarehouseInteractiveArgs: 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 warehouseInteractiveResource = new Snowflake.WarehouseInteractive("warehouseInteractiveResource", new()
{
    AutoResume = "string",
    AutoSuspend = 0,
    Comment = "string",
    FallbackWarehouse = "string",
    InitiallySuspended = false,
    MaxClusterCount = 0,
    MaxConcurrencyLevel = 0,
    MinClusterCount = 0,
    Name = "string",
    ResourceMonitor = "string",
    StatementQueuedTimeoutInSeconds = 0,
    StatementTimeoutInSeconds = 0,
    Tables = new[]
    {
        "string",
    },
    WarehouseSize = "string",
});

example, err := snowflake.NewWarehouseInteractive(ctx, "warehouseInteractiveResource", &snowflake.WarehouseInteractiveArgs{
	AutoResume:                      pulumi.String("string"),
	AutoSuspend:                     pulumi.Int(0),
	Comment:                         pulumi.String("string"),
	FallbackWarehouse:               pulumi.String("string"),
	InitiallySuspended:              pulumi.Bool(false),
	MaxClusterCount:                 pulumi.Int(0),
	MaxConcurrencyLevel:             pulumi.Int(0),
	MinClusterCount:                 pulumi.Int(0),
	Name:                            pulumi.String("string"),
	ResourceMonitor:                 pulumi.String("string"),
	StatementQueuedTimeoutInSeconds: pulumi.Int(0),
	StatementTimeoutInSeconds:       pulumi.Int(0),
	Tables: pulumi.StringArray{
		pulumi.String("string"),
	},
	WarehouseSize: pulumi.String("string"),
})

resource "snowflake_warehouse_interactive" "warehouseInteractiveResource" {
  lifecycle {
    create_before_destroy = true
  }
  auto_resume                         = "string"
  auto_suspend                        = 0
  comment                             = "string"
  fallback_warehouse                  = "string"
  initially_suspended                 = false
  max_cluster_count                   = 0
  max_concurrency_level               = 0
  min_cluster_count                   = 0
  name                                = "string"
  resource_monitor                    = "string"
  statement_queued_timeout_in_seconds = 0
  statement_timeout_in_seconds        = 0
  tables                              = ["string"]
  warehouse_size                      = "string"
}

var warehouseInteractiveResource = new WarehouseInteractive("warehouseInteractiveResource", WarehouseInteractiveArgs.builder()
    .autoResume("string")
    .autoSuspend(0)
    .comment("string")
    .fallbackWarehouse("string")
    .initiallySuspended(false)
    .maxClusterCount(0)
    .maxConcurrencyLevel(0)
    .minClusterCount(0)
    .name("string")
    .resourceMonitor("string")
    .statementQueuedTimeoutInSeconds(0)
    .statementTimeoutInSeconds(0)
    .tables("string")
    .warehouseSize("string")
    .build());

warehouse_interactive_resource = snowflake.WarehouseInteractive("warehouseInteractiveResource",
    auto_resume="string",
    auto_suspend=0,
    comment="string",
    fallback_warehouse="string",
    initially_suspended=False,
    max_cluster_count=0,
    max_concurrency_level=0,
    min_cluster_count=0,
    name="string",
    resource_monitor="string",
    statement_queued_timeout_in_seconds=0,
    statement_timeout_in_seconds=0,
    tables=["string"],
    warehouse_size="string")

const warehouseInteractiveResource = new snowflake.WarehouseInteractive("warehouseInteractiveResource", {
    autoResume: "string",
    autoSuspend: 0,
    comment: "string",
    fallbackWarehouse: "string",
    initiallySuspended: false,
    maxClusterCount: 0,
    maxConcurrencyLevel: 0,
    minClusterCount: 0,
    name: "string",
    resourceMonitor: "string",
    statementQueuedTimeoutInSeconds: 0,
    statementTimeoutInSeconds: 0,
    tables: ["string"],
    warehouseSize: "string",
});

type: snowflake:WarehouseInteractive
properties:
    autoResume: string
    autoSuspend: 0
    comment: string
    fallbackWarehouse: string
    initiallySuspended: false
    maxClusterCount: 0
    maxConcurrencyLevel: 0
    minClusterCount: 0
    name: string
    resourceMonitor: string
    statementQueuedTimeoutInSeconds: 0
    statementTimeoutInSeconds: 0
    tables:
        - string
    warehouseSize: string

WarehouseInteractive 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 WarehouseInteractive resource accepts the following input properties:

AutoResume string: (Default: fallback to Snowflake default - uses special value that cannot be set in the configuration manually (default)) Specifies whether to automatically resume an interactive 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: (Default: fallback to Snowflake default - uses special value that cannot be set in the configuration manually (-1)) Specifies the number of seconds of inactivity after which an interactive warehouse is automatically suspended.
Comment string: Specifies a comment for the interactive warehouse.
FallbackWarehouse string: Specifies the name of the fallback warehouse for the interactive warehouse. For more information about this resource, see docs.
InitiallySuspended bool: Specifies whether the interactive warehouse is created initially in the ‘Suspended’ state.
MaxClusterCount int: Specifies the maximum number of server clusters for the interactive warehouse.
MaxConcurrencyLevel int: Object parameter that specifies the concurrency level for SQL statements (i.e. queries and DML) executed by an interactive warehouse.
MinClusterCount int: Specifies the minimum number of server clusters for the interactive warehouse (only applies to multi-cluster warehouses).
Name string: Identifier for the interactive warehouse; must be unique for your account. Due to technical limitations (read more here), avoid using the following characters: |, ., ".
ResourceMonitor string: Specifies the name of a resource monitor that is explicitly assigned to the interactive warehouse. For more information about this resource, see docs.
StatementQueuedTimeoutInSeconds int: Object parameter that specifies the time, in seconds, a SQL statement (query, DDL, DML, etc.) can be queued on an interactive 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.
Tables List<string>: Specifies the fully qualified names of the tables associated with the interactive warehouse. Changes are applied incrementally (ADD TABLES / DROP TABLES) rather than by full re-association.
WarehouseSize string: Specifies the size of the interactive 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. Note: changing the size briefly suspends and resumes the warehouse to apply the resize (an interactive warehouse cannot be resized while running); removing the size from config will result in the resource recreation.

AutoResume string: (Default: fallback to Snowflake default - uses special value that cannot be set in the configuration manually (default)) Specifies whether to automatically resume an interactive 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: (Default: fallback to Snowflake default - uses special value that cannot be set in the configuration manually (-1)) Specifies the number of seconds of inactivity after which an interactive warehouse is automatically suspended.
Comment string: Specifies a comment for the interactive warehouse.
FallbackWarehouse string: Specifies the name of the fallback warehouse for the interactive warehouse. For more information about this resource, see docs.
InitiallySuspended bool: Specifies whether the interactive warehouse is created initially in the ‘Suspended’ state.
MaxClusterCount int: Specifies the maximum number of server clusters for the interactive warehouse.
MaxConcurrencyLevel int: Object parameter that specifies the concurrency level for SQL statements (i.e. queries and DML) executed by an interactive warehouse.
MinClusterCount int: Specifies the minimum number of server clusters for the interactive warehouse (only applies to multi-cluster warehouses).
Name string: Identifier for the interactive warehouse; must be unique for your account. Due to technical limitations (read more here), avoid using the following characters: |, ., ".
ResourceMonitor string: Specifies the name of a resource monitor that is explicitly assigned to the interactive warehouse. For more information about this resource, see docs.
StatementQueuedTimeoutInSeconds int: Object parameter that specifies the time, in seconds, a SQL statement (query, DDL, DML, etc.) can be queued on an interactive 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.
Tables []string: Specifies the fully qualified names of the tables associated with the interactive warehouse. Changes are applied incrementally (ADD TABLES / DROP TABLES) rather than by full re-association.
WarehouseSize string: Specifies the size of the interactive 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. Note: changing the size briefly suspends and resumes the warehouse to apply the resize (an interactive warehouse cannot be resized while running); removing the size from config will result in the resource recreation.

auto_resume string: (Default: fallback to Snowflake default - uses special value that cannot be set in the configuration manually (default)) Specifies whether to automatically resume an interactive 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: (Default: fallback to Snowflake default - uses special value that cannot be set in the configuration manually (-1)) Specifies the number of seconds of inactivity after which an interactive warehouse is automatically suspended.
comment string: Specifies a comment for the interactive warehouse.
fallback_warehouse string: Specifies the name of the fallback warehouse for the interactive warehouse. For more information about this resource, see docs.
initially_suspended bool: Specifies whether the interactive warehouse is created initially in the ‘Suspended’ state.
max_cluster_count number: Specifies the maximum number of server clusters for the interactive warehouse.
max_concurrency_level number: Object parameter that specifies the concurrency level for SQL statements (i.e. queries and DML) executed by an interactive warehouse.
min_cluster_count number: Specifies the minimum number of server clusters for the interactive warehouse (only applies to multi-cluster warehouses).
name string: Identifier for the interactive warehouse; must be unique for your account. Due to technical limitations (read more here), avoid using the following characters: |, ., ".
resource_monitor string: Specifies the name of a resource monitor that is explicitly assigned to the interactive warehouse. For more information about this resource, see docs.
statement_queued_timeout_in_seconds number: Object parameter that specifies the time, in seconds, a SQL statement (query, DDL, DML, etc.) can be queued on an interactive warehouse before it is canceled by the system.
statement_timeout_in_seconds number: Specifies the time, in seconds, after which a running SQL statement (query, DDL, DML, etc.) is canceled by the system.
tables list(string): Specifies the fully qualified names of the tables associated with the interactive warehouse. Changes are applied incrementally (ADD TABLES / DROP TABLES) rather than by full re-association.
warehouse_size string: Specifies the size of the interactive 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. Note: changing the size briefly suspends and resumes the warehouse to apply the resize (an interactive warehouse cannot be resized while running); removing the size from config will result in the resource recreation.

autoResume String: (Default: fallback to Snowflake default - uses special value that cannot be set in the configuration manually (default)) Specifies whether to automatically resume an interactive 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: (Default: fallback to Snowflake default - uses special value that cannot be set in the configuration manually (-1)) Specifies the number of seconds of inactivity after which an interactive warehouse is automatically suspended.
comment String: Specifies a comment for the interactive warehouse.
fallbackWarehouse String: Specifies the name of the fallback warehouse for the interactive warehouse. For more information about this resource, see docs.
initiallySuspended Boolean: Specifies whether the interactive warehouse is created initially in the ‘Suspended’ state.
maxClusterCount Integer: Specifies the maximum number of server clusters for the interactive warehouse.
maxConcurrencyLevel Integer: Object parameter that specifies the concurrency level for SQL statements (i.e. queries and DML) executed by an interactive warehouse.
minClusterCount Integer: Specifies the minimum number of server clusters for the interactive warehouse (only applies to multi-cluster warehouses).
name String: Identifier for the interactive warehouse; must be unique for your account. Due to technical limitations (read more here), avoid using the following characters: |, ., ".
resourceMonitor String: Specifies the name of a resource monitor that is explicitly assigned to the interactive warehouse. For more information about this resource, see docs.
statementQueuedTimeoutInSeconds Integer: Object parameter that specifies the time, in seconds, a SQL statement (query, DDL, DML, etc.) can be queued on an interactive 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.
tables List<String>: Specifies the fully qualified names of the tables associated with the interactive warehouse. Changes are applied incrementally (ADD TABLES / DROP TABLES) rather than by full re-association.
warehouseSize String: Specifies the size of the interactive 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. Note: changing the size briefly suspends and resumes the warehouse to apply the resize (an interactive warehouse cannot be resized while running); removing the size from config will result in the resource recreation.

autoResume string: (Default: fallback to Snowflake default - uses special value that cannot be set in the configuration manually (default)) Specifies whether to automatically resume an interactive 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: (Default: fallback to Snowflake default - uses special value that cannot be set in the configuration manually (-1)) Specifies the number of seconds of inactivity after which an interactive warehouse is automatically suspended.
comment string: Specifies a comment for the interactive warehouse.
fallbackWarehouse string: Specifies the name of the fallback warehouse for the interactive warehouse. For more information about this resource, see docs.
initiallySuspended boolean: Specifies whether the interactive warehouse is created initially in the ‘Suspended’ state.
maxClusterCount number: Specifies the maximum number of server clusters for the interactive warehouse.
maxConcurrencyLevel number: Object parameter that specifies the concurrency level for SQL statements (i.e. queries and DML) executed by an interactive warehouse.
minClusterCount number: Specifies the minimum number of server clusters for the interactive warehouse (only applies to multi-cluster warehouses).
name string: Identifier for the interactive warehouse; must be unique for your account. Due to technical limitations (read more here), avoid using the following characters: |, ., ".
resourceMonitor string: Specifies the name of a resource monitor that is explicitly assigned to the interactive warehouse. For more information about this resource, see docs.
statementQueuedTimeoutInSeconds number: Object parameter that specifies the time, in seconds, a SQL statement (query, DDL, DML, etc.) can be queued on an interactive 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.
tables string[]: Specifies the fully qualified names of the tables associated with the interactive warehouse. Changes are applied incrementally (ADD TABLES / DROP TABLES) rather than by full re-association.
warehouseSize string: Specifies the size of the interactive 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. Note: changing the size briefly suspends and resumes the warehouse to apply the resize (an interactive warehouse cannot be resized while running); removing the size from config will result in the resource recreation.

auto_resume str: (Default: fallback to Snowflake default - uses special value that cannot be set in the configuration manually (default)) Specifies whether to automatically resume an interactive 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: (Default: fallback to Snowflake default - uses special value that cannot be set in the configuration manually (-1)) Specifies the number of seconds of inactivity after which an interactive warehouse is automatically suspended.
comment str: Specifies a comment for the interactive warehouse.
fallback_warehouse str: Specifies the name of the fallback warehouse for the interactive warehouse. For more information about this resource, see docs.
initially_suspended bool: Specifies whether the interactive warehouse is created initially in the ‘Suspended’ state.
max_cluster_count int: Specifies the maximum number of server clusters for the interactive warehouse.
max_concurrency_level int: Object parameter that specifies the concurrency level for SQL statements (i.e. queries and DML) executed by an interactive warehouse.
min_cluster_count int: Specifies the minimum number of server clusters for the interactive warehouse (only applies to multi-cluster warehouses).
name str: Identifier for the interactive warehouse; must be unique for your account. Due to technical limitations (read more here), avoid using the following characters: |, ., ".
resource_monitor str: Specifies the name of a resource monitor that is explicitly assigned to the interactive warehouse. For more information about this resource, see docs.
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 an interactive 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.
tables Sequence[str]: Specifies the fully qualified names of the tables associated with the interactive warehouse. Changes are applied incrementally (ADD TABLES / DROP TABLES) rather than by full re-association.
warehouse_size str: Specifies the size of the interactive 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. Note: changing the size briefly suspends and resumes the warehouse to apply the resize (an interactive warehouse cannot be resized while running); removing the size from config will result in the resource recreation.

autoResume String: (Default: fallback to Snowflake default - uses special value that cannot be set in the configuration manually (default)) Specifies whether to automatically resume an interactive 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: (Default: fallback to Snowflake default - uses special value that cannot be set in the configuration manually (-1)) Specifies the number of seconds of inactivity after which an interactive warehouse is automatically suspended.
comment String: Specifies a comment for the interactive warehouse.
fallbackWarehouse String: Specifies the name of the fallback warehouse for the interactive warehouse. For more information about this resource, see docs.
initiallySuspended Boolean: Specifies whether the interactive warehouse is created initially in the ‘Suspended’ state.
maxClusterCount Number: Specifies the maximum number of server clusters for the interactive warehouse.
maxConcurrencyLevel Number: Object parameter that specifies the concurrency level for SQL statements (i.e. queries and DML) executed by an interactive warehouse.
minClusterCount Number: Specifies the minimum number of server clusters for the interactive warehouse (only applies to multi-cluster warehouses).
name String: Identifier for the interactive warehouse; must be unique for your account. Due to technical limitations (read more here), avoid using the following characters: |, ., ".
resourceMonitor String: Specifies the name of a resource monitor that is explicitly assigned to the interactive warehouse. For more information about this resource, see docs.
statementQueuedTimeoutInSeconds Number: Object parameter that specifies the time, in seconds, a SQL statement (query, DDL, DML, etc.) can be queued on an interactive 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.
tables List<String>: Specifies the fully qualified names of the tables associated with the interactive warehouse. Changes are applied incrementally (ADD TABLES / DROP TABLES) rather than by full re-association.
warehouseSize String: Specifies the size of the interactive 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. Note: changing the size briefly suspends and resumes the warehouse to apply the resize (an interactive warehouse cannot be resized while running); removing the size from config will result in the resource recreation.

Outputs

All input properties are implicitly available as output properties. Additionally, the WarehouseInteractive 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<WarehouseInteractiveParameter>: Outputs the result of SHOW PARAMETERS IN WAREHOUSE for the given interactive warehouse.
ShowOutputs List<WarehouseInteractiveShowOutput>: Outputs the result of SHOW WAREHOUSES for the given interactive warehouse.
WarehouseType string: Specifies the type for the interactive warehouse. This field is used for checking external changes and recreating the resource if needed.

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 []WarehouseInteractiveParameter: Outputs the result of SHOW PARAMETERS IN WAREHOUSE for the given interactive warehouse.
ShowOutputs []WarehouseInteractiveShowOutput: Outputs the result of SHOW WAREHOUSES for the given interactive warehouse.
WarehouseType string: Specifies the type for the interactive warehouse. This field is used for checking external changes and recreating the resource if needed.

fully_qualified_name 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(object): Outputs the result of SHOW PARAMETERS IN WAREHOUSE for the given interactive warehouse.
show_outputs list(object): Outputs the result of SHOW WAREHOUSES for the given interactive warehouse.
warehouse_type string: Specifies the type for the interactive warehouse. This field is used for checking external changes and recreating the resource if needed.

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<WarehouseInteractiveParameter>: Outputs the result of SHOW PARAMETERS IN WAREHOUSE for the given interactive warehouse.
showOutputs List<WarehouseInteractiveShowOutput>: Outputs the result of SHOW WAREHOUSES for the given interactive warehouse.
warehouseType String: Specifies the type for the interactive warehouse. This field is used for checking external changes and recreating the resource if needed.

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 WarehouseInteractiveParameter[]: Outputs the result of SHOW PARAMETERS IN WAREHOUSE for the given interactive warehouse.
showOutputs WarehouseInteractiveShowOutput[]: Outputs the result of SHOW WAREHOUSES for the given interactive warehouse.
warehouseType string: Specifies the type for the interactive warehouse. This field is used for checking external changes and recreating the resource if needed.

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[WarehouseInteractiveParameter]: Outputs the result of SHOW PARAMETERS IN WAREHOUSE for the given interactive warehouse.
show_outputs Sequence[WarehouseInteractiveShowOutput]: Outputs the result of SHOW WAREHOUSES for the given interactive warehouse.
warehouse_type str: Specifies the type for the interactive warehouse. This field is used for checking external changes and recreating the resource if needed.

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 interactive warehouse.
showOutputs List<Property Map>: Outputs the result of SHOW WAREHOUSES for the given interactive warehouse.
warehouseType String: Specifies the type for the interactive warehouse. This field is used for checking external changes and recreating the resource if needed.

Look up Existing WarehouseInteractive Resource

Get an existing WarehouseInteractive 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?: WarehouseInteractiveState, opts?: CustomResourceOptions): WarehouseInteractive

@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,
        fallback_warehouse: 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[WarehouseInteractiveParameterArgs]] = None,
        resource_monitor: Optional[str] = None,
        show_outputs: Optional[Sequence[WarehouseInteractiveShowOutputArgs]] = None,
        statement_queued_timeout_in_seconds: Optional[int] = None,
        statement_timeout_in_seconds: Optional[int] = None,
        tables: Optional[Sequence[str]] = None,
        warehouse_size: Optional[str] = None,
        warehouse_type: Optional[str] = None) -> WarehouseInteractive

func GetWarehouseInteractive(ctx *Context, name string, id IDInput, state *WarehouseInteractiveState, opts ...ResourceOption) (*WarehouseInteractive, error)

public static WarehouseInteractive Get(string name, Input<string> id, WarehouseInteractiveState? state, CustomResourceOptions? opts = null)

public static WarehouseInteractive get(String name, Output<String> id, WarehouseInteractiveState state, CustomResourceOptions options)

resources:  _:    type: snowflake:WarehouseInteractive    get:      id: ${id}

import {
  to = snowflake_warehouse_interactive.example
  id = "${id}"
}

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: (Default: fallback to Snowflake default - uses special value that cannot be set in the configuration manually (default)) Specifies whether to automatically resume an interactive 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: (Default: fallback to Snowflake default - uses special value that cannot be set in the configuration manually (-1)) Specifies the number of seconds of inactivity after which an interactive warehouse is automatically suspended.
Comment string: Specifies a comment for the interactive warehouse.
FallbackWarehouse string: Specifies the name of the fallback warehouse for the interactive warehouse. For more information about this resource, see docs.
FullyQualifiedName string: Fully qualified name of the resource. For more information, see object name resolution.
InitiallySuspended bool: Specifies whether the interactive warehouse is created initially in the ‘Suspended’ state.
MaxClusterCount int: Specifies the maximum number of server clusters for the interactive warehouse.
MaxConcurrencyLevel int: Object parameter that specifies the concurrency level for SQL statements (i.e. queries and DML) executed by an interactive warehouse.
MinClusterCount int: Specifies the minimum number of server clusters for the interactive warehouse (only applies to multi-cluster warehouses).
Name string: Identifier for the interactive warehouse; must be unique for your account. Due to technical limitations (read more here), avoid using the following characters: |, ., ".
Parameters List<WarehouseInteractiveParameter>: Outputs the result of SHOW PARAMETERS IN WAREHOUSE for the given interactive warehouse.
ResourceMonitor string: Specifies the name of a resource monitor that is explicitly assigned to the interactive warehouse. For more information about this resource, see docs.
ShowOutputs List<WarehouseInteractiveShowOutput>: Outputs the result of SHOW WAREHOUSES for the given interactive warehouse.
StatementQueuedTimeoutInSeconds int: Object parameter that specifies the time, in seconds, a SQL statement (query, DDL, DML, etc.) can be queued on an interactive 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.
Tables List<string>: Specifies the fully qualified names of the tables associated with the interactive warehouse. Changes are applied incrementally (ADD TABLES / DROP TABLES) rather than by full re-association.
WarehouseSize string: Specifies the size of the interactive 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. Note: changing the size briefly suspends and resumes the warehouse to apply the resize (an interactive warehouse cannot be resized while running); removing the size from config will result in the resource recreation.
WarehouseType string: Specifies the type for the interactive warehouse. This field is used for checking external changes and recreating the resource if needed.

AutoResume string: (Default: fallback to Snowflake default - uses special value that cannot be set in the configuration manually (default)) Specifies whether to automatically resume an interactive 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: (Default: fallback to Snowflake default - uses special value that cannot be set in the configuration manually (-1)) Specifies the number of seconds of inactivity after which an interactive warehouse is automatically suspended.
Comment string: Specifies a comment for the interactive warehouse.
FallbackWarehouse string: Specifies the name of the fallback warehouse for the interactive warehouse. For more information about this resource, see docs.
FullyQualifiedName string: Fully qualified name of the resource. For more information, see object name resolution.
InitiallySuspended bool: Specifies whether the interactive warehouse is created initially in the ‘Suspended’ state.
MaxClusterCount int: Specifies the maximum number of server clusters for the interactive warehouse.
MaxConcurrencyLevel int: Object parameter that specifies the concurrency level for SQL statements (i.e. queries and DML) executed by an interactive warehouse.
MinClusterCount int: Specifies the minimum number of server clusters for the interactive warehouse (only applies to multi-cluster warehouses).
Name string: Identifier for the interactive warehouse; must be unique for your account. Due to technical limitations (read more here), avoid using the following characters: |, ., ".
Parameters []WarehouseInteractiveParameterArgs: Outputs the result of SHOW PARAMETERS IN WAREHOUSE for the given interactive warehouse.
ResourceMonitor string: Specifies the name of a resource monitor that is explicitly assigned to the interactive warehouse. For more information about this resource, see docs.
ShowOutputs []WarehouseInteractiveShowOutputArgs: Outputs the result of SHOW WAREHOUSES for the given interactive warehouse.
StatementQueuedTimeoutInSeconds int: Object parameter that specifies the time, in seconds, a SQL statement (query, DDL, DML, etc.) can be queued on an interactive 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.
Tables []string: Specifies the fully qualified names of the tables associated with the interactive warehouse. Changes are applied incrementally (ADD TABLES / DROP TABLES) rather than by full re-association.
WarehouseSize string: Specifies the size of the interactive 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. Note: changing the size briefly suspends and resumes the warehouse to apply the resize (an interactive warehouse cannot be resized while running); removing the size from config will result in the resource recreation.
WarehouseType string: Specifies the type for the interactive warehouse. This field is used for checking external changes and recreating the resource if needed.

auto_resume string: (Default: fallback to Snowflake default - uses special value that cannot be set in the configuration manually (default)) Specifies whether to automatically resume an interactive 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: (Default: fallback to Snowflake default - uses special value that cannot be set in the configuration manually (-1)) Specifies the number of seconds of inactivity after which an interactive warehouse is automatically suspended.
comment string: Specifies a comment for the interactive warehouse.
fallback_warehouse string: Specifies the name of the fallback warehouse for the interactive warehouse. For more information about this resource, see docs.
fully_qualified_name string: Fully qualified name of the resource. For more information, see object name resolution.
initially_suspended bool: Specifies whether the interactive warehouse is created initially in the ‘Suspended’ state.
max_cluster_count number: Specifies the maximum number of server clusters for the interactive warehouse.
max_concurrency_level number: Object parameter that specifies the concurrency level for SQL statements (i.e. queries and DML) executed by an interactive warehouse.
min_cluster_count number: Specifies the minimum number of server clusters for the interactive warehouse (only applies to multi-cluster warehouses).
name string: Identifier for the interactive warehouse; must be unique for your account. Due to technical limitations (read more here), avoid using the following characters: |, ., ".
parameters list(object): Outputs the result of SHOW PARAMETERS IN WAREHOUSE for the given interactive warehouse.
resource_monitor string: Specifies the name of a resource monitor that is explicitly assigned to the interactive warehouse. For more information about this resource, see docs.
show_outputs list(object): Outputs the result of SHOW WAREHOUSES for the given interactive warehouse.
statement_queued_timeout_in_seconds number: Object parameter that specifies the time, in seconds, a SQL statement (query, DDL, DML, etc.) can be queued on an interactive warehouse before it is canceled by the system.
statement_timeout_in_seconds number: Specifies the time, in seconds, after which a running SQL statement (query, DDL, DML, etc.) is canceled by the system.
tables list(string): Specifies the fully qualified names of the tables associated with the interactive warehouse. Changes are applied incrementally (ADD TABLES / DROP TABLES) rather than by full re-association.
warehouse_size string: Specifies the size of the interactive 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. Note: changing the size briefly suspends and resumes the warehouse to apply the resize (an interactive warehouse cannot be resized while running); removing the size from config will result in the resource recreation.
warehouse_type string: Specifies the type for the interactive warehouse. This field is used for checking external changes and recreating the resource if needed.

autoResume String: (Default: fallback to Snowflake default - uses special value that cannot be set in the configuration manually (default)) Specifies whether to automatically resume an interactive 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: (Default: fallback to Snowflake default - uses special value that cannot be set in the configuration manually (-1)) Specifies the number of seconds of inactivity after which an interactive warehouse is automatically suspended.
comment String: Specifies a comment for the interactive warehouse.
fallbackWarehouse String: Specifies the name of the fallback warehouse for the interactive warehouse. For more information about this resource, see docs.
fullyQualifiedName String: Fully qualified name of the resource. For more information, see object name resolution.
initiallySuspended Boolean: Specifies whether the interactive warehouse is created initially in the ‘Suspended’ state.
maxClusterCount Integer: Specifies the maximum number of server clusters for the interactive warehouse.
maxConcurrencyLevel Integer: Object parameter that specifies the concurrency level for SQL statements (i.e. queries and DML) executed by an interactive warehouse.
minClusterCount Integer: Specifies the minimum number of server clusters for the interactive warehouse (only applies to multi-cluster warehouses).
name String: Identifier for the interactive warehouse; must be unique for your account. Due to technical limitations (read more here), avoid using the following characters: |, ., ".
parameters List<WarehouseInteractiveParameter>: Outputs the result of SHOW PARAMETERS IN WAREHOUSE for the given interactive warehouse.
resourceMonitor String: Specifies the name of a resource monitor that is explicitly assigned to the interactive warehouse. For more information about this resource, see docs.
showOutputs List<WarehouseInteractiveShowOutput>: Outputs the result of SHOW WAREHOUSES for the given interactive warehouse.
statementQueuedTimeoutInSeconds Integer: Object parameter that specifies the time, in seconds, a SQL statement (query, DDL, DML, etc.) can be queued on an interactive 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.
tables List<String>: Specifies the fully qualified names of the tables associated with the interactive warehouse. Changes are applied incrementally (ADD TABLES / DROP TABLES) rather than by full re-association.
warehouseSize String: Specifies the size of the interactive 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. Note: changing the size briefly suspends and resumes the warehouse to apply the resize (an interactive warehouse cannot be resized while running); removing the size from config will result in the resource recreation.
warehouseType String: Specifies the type for the interactive warehouse. This field is used for checking external changes and recreating the resource if needed.

autoResume string: (Default: fallback to Snowflake default - uses special value that cannot be set in the configuration manually (default)) Specifies whether to automatically resume an interactive 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: (Default: fallback to Snowflake default - uses special value that cannot be set in the configuration manually (-1)) Specifies the number of seconds of inactivity after which an interactive warehouse is automatically suspended.
comment string: Specifies a comment for the interactive warehouse.
fallbackWarehouse string: Specifies the name of the fallback warehouse for the interactive warehouse. For more information about this resource, see docs.
fullyQualifiedName string: Fully qualified name of the resource. For more information, see object name resolution.
initiallySuspended boolean: Specifies whether the interactive warehouse is created initially in the ‘Suspended’ state.
maxClusterCount number: Specifies the maximum number of server clusters for the interactive warehouse.
maxConcurrencyLevel number: Object parameter that specifies the concurrency level for SQL statements (i.e. queries and DML) executed by an interactive warehouse.
minClusterCount number: Specifies the minimum number of server clusters for the interactive warehouse (only applies to multi-cluster warehouses).
name string: Identifier for the interactive warehouse; must be unique for your account. Due to technical limitations (read more here), avoid using the following characters: |, ., ".
parameters WarehouseInteractiveParameter[]: Outputs the result of SHOW PARAMETERS IN WAREHOUSE for the given interactive warehouse.
resourceMonitor string: Specifies the name of a resource monitor that is explicitly assigned to the interactive warehouse. For more information about this resource, see docs.
showOutputs WarehouseInteractiveShowOutput[]: Outputs the result of SHOW WAREHOUSES for the given interactive warehouse.
statementQueuedTimeoutInSeconds number: Object parameter that specifies the time, in seconds, a SQL statement (query, DDL, DML, etc.) can be queued on an interactive 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.
tables string[]: Specifies the fully qualified names of the tables associated with the interactive warehouse. Changes are applied incrementally (ADD TABLES / DROP TABLES) rather than by full re-association.
warehouseSize string: Specifies the size of the interactive 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. Note: changing the size briefly suspends and resumes the warehouse to apply the resize (an interactive warehouse cannot be resized while running); removing the size from config will result in the resource recreation.
warehouseType string: Specifies the type for the interactive warehouse. This field is used for checking external changes and recreating the resource if needed.

auto_resume str: (Default: fallback to Snowflake default - uses special value that cannot be set in the configuration manually (default)) Specifies whether to automatically resume an interactive 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: (Default: fallback to Snowflake default - uses special value that cannot be set in the configuration manually (-1)) Specifies the number of seconds of inactivity after which an interactive warehouse is automatically suspended.
comment str: Specifies a comment for the interactive warehouse.
fallback_warehouse str: Specifies the name of the fallback warehouse for the interactive warehouse. For more information about this resource, see docs.
fully_qualified_name str: Fully qualified name of the resource. For more information, see object name resolution.
initially_suspended bool: Specifies whether the interactive warehouse is created initially in the ‘Suspended’ state.
max_cluster_count int: Specifies the maximum number of server clusters for the interactive warehouse.
max_concurrency_level int: Object parameter that specifies the concurrency level for SQL statements (i.e. queries and DML) executed by an interactive warehouse.
min_cluster_count int: Specifies the minimum number of server clusters for the interactive warehouse (only applies to multi-cluster warehouses).
name str: Identifier for the interactive warehouse; must be unique for your account. Due to technical limitations (read more here), avoid using the following characters: |, ., ".
parameters Sequence[WarehouseInteractiveParameterArgs]: Outputs the result of SHOW PARAMETERS IN WAREHOUSE for the given interactive warehouse.
resource_monitor str: Specifies the name of a resource monitor that is explicitly assigned to the interactive warehouse. For more information about this resource, see docs.
show_outputs Sequence[WarehouseInteractiveShowOutputArgs]: Outputs the result of SHOW WAREHOUSES for the given interactive 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 an interactive 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.
tables Sequence[str]: Specifies the fully qualified names of the tables associated with the interactive warehouse. Changes are applied incrementally (ADD TABLES / DROP TABLES) rather than by full re-association.
warehouse_size str: Specifies the size of the interactive 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. Note: changing the size briefly suspends and resumes the warehouse to apply the resize (an interactive warehouse cannot be resized while running); removing the size from config will result in the resource recreation.
warehouse_type str: Specifies the type for the interactive warehouse. This field is used for checking external changes and recreating the resource if needed.

autoResume String: (Default: fallback to Snowflake default - uses special value that cannot be set in the configuration manually (default)) Specifies whether to automatically resume an interactive 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: (Default: fallback to Snowflake default - uses special value that cannot be set in the configuration manually (-1)) Specifies the number of seconds of inactivity after which an interactive warehouse is automatically suspended.
comment String: Specifies a comment for the interactive warehouse.
fallbackWarehouse String: Specifies the name of the fallback warehouse for the interactive warehouse. For more information about this resource, see docs.
fullyQualifiedName String: Fully qualified name of the resource. For more information, see object name resolution.
initiallySuspended Boolean: Specifies whether the interactive warehouse is created initially in the ‘Suspended’ state.
maxClusterCount Number: Specifies the maximum number of server clusters for the interactive warehouse.
maxConcurrencyLevel Number: Object parameter that specifies the concurrency level for SQL statements (i.e. queries and DML) executed by an interactive warehouse.
minClusterCount Number: Specifies the minimum number of server clusters for the interactive warehouse (only applies to multi-cluster warehouses).
name String: Identifier for the interactive 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 interactive warehouse.
resourceMonitor String: Specifies the name of a resource monitor that is explicitly assigned to the interactive warehouse. For more information about this resource, see docs.
showOutputs List<Property Map>: Outputs the result of SHOW WAREHOUSES for the given interactive warehouse.
statementQueuedTimeoutInSeconds Number: Object parameter that specifies the time, in seconds, a SQL statement (query, DDL, DML, etc.) can be queued on an interactive 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.
tables List<String>: Specifies the fully qualified names of the tables associated with the interactive warehouse. Changes are applied incrementally (ADD TABLES / DROP TABLES) rather than by full re-association.
warehouseSize String: Specifies the size of the interactive 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. Note: changing the size briefly suspends and resumes the warehouse to apply the resize (an interactive warehouse cannot be resized while running); removing the size from config will result in the resource recreation.
warehouseType String: Specifies the type for the interactive warehouse. This field is used for checking external changes and recreating the resource if needed.

Supporting Types

WarehouseInteractiveParameter, WarehouseInteractiveParameterArgs

FallbackWarehouses List<WarehouseInteractiveParameterFallbackWarehouse>
MaxConcurrencyLevels List<WarehouseInteractiveParameterMaxConcurrencyLevel>
StatementQueuedTimeoutInSeconds List<WarehouseInteractiveParameterStatementQueuedTimeoutInSecond>
StatementTimeoutInSeconds List<WarehouseInteractiveParameterStatementTimeoutInSecond>

FallbackWarehouses []WarehouseInteractiveParameterFallbackWarehouse
MaxConcurrencyLevels []WarehouseInteractiveParameterMaxConcurrencyLevel
StatementQueuedTimeoutInSeconds []WarehouseInteractiveParameterStatementQueuedTimeoutInSecond
StatementTimeoutInSeconds []WarehouseInteractiveParameterStatementTimeoutInSecond

fallback_warehouses list(object)
max_concurrency_levels list(object)
statement_queued_timeout_in_seconds list(object)
statement_timeout_in_seconds list(object)

fallbackWarehouses List<WarehouseInteractiveParameterFallbackWarehouse>
maxConcurrencyLevels List<WarehouseInteractiveParameterMaxConcurrencyLevel>
statementQueuedTimeoutInSeconds List<WarehouseInteractiveParameterStatementQueuedTimeoutInSecond>
statementTimeoutInSeconds List<WarehouseInteractiveParameterStatementTimeoutInSecond>

fallbackWarehouses WarehouseInteractiveParameterFallbackWarehouse[]
maxConcurrencyLevels WarehouseInteractiveParameterMaxConcurrencyLevel[]
statementQueuedTimeoutInSeconds WarehouseInteractiveParameterStatementQueuedTimeoutInSecond[]
statementTimeoutInSeconds WarehouseInteractiveParameterStatementTimeoutInSecond[]

fallback_warehouses Sequence[WarehouseInteractiveParameterFallbackWarehouse]
max_concurrency_levels Sequence[WarehouseInteractiveParameterMaxConcurrencyLevel]
statement_queued_timeout_in_seconds Sequence[WarehouseInteractiveParameterStatementQueuedTimeoutInSecond]
statement_timeout_in_seconds Sequence[WarehouseInteractiveParameterStatementTimeoutInSecond]

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

WarehouseInteractiveParameterFallbackWarehouse, WarehouseInteractiveParameterFallbackWarehouseArgs

Default string
Description string
Key string
Level string
Value string

Default string
Description string
Key string
Level string
Value string

default string
description string
key string
level string
value string

default_ String
description String
key String
level String
value String

default string
description string
key string
level string
value string

default str
description str
key str
level str
value str

default String
description String
key String
level String
value String

WarehouseInteractiveParameterMaxConcurrencyLevel, WarehouseInteractiveParameterMaxConcurrencyLevelArgs

Default string
Description string
Key string
Level string
Value string

Default string
Description string
Key string
Level string
Value string

default string
description string
key string
level string
value string

default_ String
description String
key String
level String
value String

default string
description string
key string
level string
value string

default str
description str
key str
level str
value str

default String
description String
key String
level String
value String

WarehouseInteractiveParameterStatementQueuedTimeoutInSecond, WarehouseInteractiveParameterStatementQueuedTimeoutInSecondArgs

Default string
Description string
Key string
Level string
Value string

Default string
Description string
Key string
Level string
Value string

default string
description string
key string
level string
value string

default_ String
description String
key String
level String
value String

default string
description string
key string
level string
value string

default str
description str
key str
level str
value str

default String
description String
key String
level String
value String

WarehouseInteractiveParameterStatementTimeoutInSecond, WarehouseInteractiveParameterStatementTimeoutInSecondArgs

Default string
Description string
Key string
Level string
Value string

Default string
Description string
Key string
Level string
Value string

default string
description string
key string
level string
value string

default_ String
description String
key String
level String
value String

default string
description string
key string
level string
value string

default str
description str
key str
level str
value str

default String
description String
key String
level String
value String

WarehouseInteractiveShowOutput, WarehouseInteractiveShowOutputArgs

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

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

auto_resume bool
auto_suspend number
available number
comment string
created_on string
is_current bool
is_default bool
max_cluster_count number
min_cluster_count number
name string
other number
owner string
owner_role_type string
provisioning number
queued number
quiescing number
resource_monitor string
resumed_on string
running number
size string
started_clusters number
state string
tables list(string)
type string
updated_on string

autoResume Boolean
autoSuspend Integer
available Double
comment String
createdOn String
isCurrent Boolean
isDefault Boolean
maxClusterCount Integer
minClusterCount Integer
name String
other Double
owner String
ownerRoleType String
provisioning Double
queued Integer
quiescing Double
resourceMonitor String
resumedOn String
running Integer
size String
startedClusters Integer
state String
tables List<String>
type String
updatedOn String

autoResume boolean
autoSuspend number
available number
comment string
createdOn string
isCurrent boolean
isDefault boolean
maxClusterCount number
minClusterCount number
name string
other number
owner string
ownerRoleType string
provisioning number
queued number
quiescing number
resourceMonitor string
resumedOn string
running number
size string
startedClusters number
state string
tables string[]
type string
updatedOn string

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

autoResume Boolean
autoSuspend Number
available Number
comment String
createdOn String
isCurrent Boolean
isDefault Boolean
maxClusterCount Number
minClusterCount Number
name String
other Number
owner String
ownerRoleType String
provisioning Number
queued Number
quiescing Number
resourceMonitor String
resumedOn String
running Number
size String
startedClusters Number
state String
tables List<String>
type String
updatedOn String

Import

$ pulumi import snowflake:index/warehouseInteractive:WarehouseInteractive example '"<warehouse_name>"'

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

Package Details

Repository: Snowflake pulumi/pulumi-snowflake
License: Apache-2.0
Notes: This Pulumi package is based on the snowflake Terraform Provider.

Viewing docs for Snowflake v2.19.0
published on Friday, Jul 31, 2026 by Pulumi

Schema (JSON)

pulumi/pulumi-snowflake

snowflake.WarehouseInteractive

On this page

On this page

Example Usage

Interactive warehouse limitations

Create WarehouseInteractive Resource

Constructor syntax

Parameters

Constructor example

WarehouseInteractive Resource Properties

Inputs

Outputs

Look up Existing WarehouseInteractive Resource

Supporting Types

WarehouseInteractiveParameter, WarehouseInteractiveParameterArgs

WarehouseInteractiveParameterFallbackWarehouse, WarehouseInteractiveParameterFallbackWarehouseArgs

WarehouseInteractiveParameterMaxConcurrencyLevel, WarehouseInteractiveParameterMaxConcurrencyLevelArgs

WarehouseInteractiveParameterStatementQueuedTimeoutInSecond, WarehouseInteractiveParameterStatementQueuedTimeoutInSecondArgs

WarehouseInteractiveParameterStatementTimeoutInSecond, WarehouseInteractiveParameterStatementTimeoutInSecondArgs

WarehouseInteractiveShowOutput, WarehouseInteractiveShowOutputArgs

Import

Package Details

On this page

On this page

Try Pulumi Cloud free.
Your team will thank you.

snowflake.WarehouseInteractive

On this page

On this page

Example Usage

Interactive warehouse limitations

Create WarehouseInteractive Resource

Constructor syntax

Parameters

Constructor example

WarehouseInteractive Resource Properties

Inputs

Outputs

Look up Existing WarehouseInteractive Resource

Supporting Types

WarehouseInteractiveParameter, WarehouseInteractiveParameterArgs

WarehouseInteractiveParameterFallbackWarehouse, WarehouseInteractiveParameterFallbackWarehouseArgs

WarehouseInteractiveParameterMaxConcurrencyLevel, WarehouseInteractiveParameterMaxConcurrencyLevelArgs

WarehouseInteractiveParameterStatementQueuedTimeoutInSecond, WarehouseInteractiveParameterStatementQueuedTimeoutInSecondArgs

WarehouseInteractiveParameterStatementTimeoutInSecond, WarehouseInteractiveParameterStatementTimeoutInSecondArgs

WarehouseInteractiveShowOutput, WarehouseInteractiveShowOutputArgs

Import

Package Details

On this page

On this page

Try Pulumi Cloud free.Your team will thank you.

Try Pulumi Cloud free.
Your team will thank you.