1. Packages
  2. Packages
  3. Snowflake Provider
  4. API Docs
  5. WarehouseAdaptive
Viewing docs for Snowflake v2.15.0
published on Saturday, May 9, 2026 by Pulumi
Schema (JSON)
pulumi/pulumi-snowflake

snowflake.WarehouseAdaptive

snowflake logo
Viewing docs for Snowflake v2.15.0
published on Saturday, May 9, 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 adaptive warehouse objects. Adaptive Compute is a compute service focused on delivering strong performance with effortless operations. It replaces the fixed compute of the Standard Warehouse with a workload-aware one that adapts to your queries automatically. The system decides how to allocate resources for the best performance, eliminating the need for infrastructure tuning.

    Example Usage

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

// Basic adaptive warehouse (only required fields)
const basic = new snowflake.WarehouseAdaptive("basic", {name: "my_adaptive_warehouse"});
// Complete adaptive warehouse (all fields set)
const complete = new snowflake.WarehouseAdaptive("complete", {
    name: "my_adaptive_warehouse_complete",
    comment: "My adaptive warehouse with all options set",
    maxQueryPerformanceLevel: "MEDIUM",
    queryThroughputMultiplier: 1,
    statementQueuedTimeoutInSeconds: 30,
    statementTimeoutInSeconds: 3600,
});

    import pulumi
import pulumi_snowflake as snowflake

# Basic adaptive warehouse (only required fields)
basic = snowflake.WarehouseAdaptive("basic", name="my_adaptive_warehouse")
# Complete adaptive warehouse (all fields set)
complete = snowflake.WarehouseAdaptive("complete",
    name="my_adaptive_warehouse_complete",
    comment="My adaptive warehouse with all options set",
    max_query_performance_level="MEDIUM",
    query_throughput_multiplier=1,
    statement_queued_timeout_in_seconds=30,
    statement_timeout_in_seconds=3600)

    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 adaptive warehouse (only required fields)
		_, err := snowflake.NewWarehouseAdaptive(ctx, "basic", &snowflake.WarehouseAdaptiveArgs{
			Name: pulumi.String("my_adaptive_warehouse"),
		})
		if err != nil {
			return err
		}
		// Complete adaptive warehouse (all fields set)
		_, err = snowflake.NewWarehouseAdaptive(ctx, "complete", &snowflake.WarehouseAdaptiveArgs{
			Name:                            pulumi.String("my_adaptive_warehouse_complete"),
			Comment:                         pulumi.String("My adaptive warehouse with all options set"),
			MaxQueryPerformanceLevel:        pulumi.String("MEDIUM"),
			QueryThroughputMultiplier:       pulumi.Int(1),
			StatementQueuedTimeoutInSeconds: pulumi.Int(30),
			StatementTimeoutInSeconds:       pulumi.Int(3600),
		})
		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 adaptive warehouse (only required fields)
    var basic = new Snowflake.WarehouseAdaptive("basic", new()
    {
        Name = "my_adaptive_warehouse",
    });

    // Complete adaptive warehouse (all fields set)
    var complete = new Snowflake.WarehouseAdaptive("complete", new()
    {
        Name = "my_adaptive_warehouse_complete",
        Comment = "My adaptive warehouse with all options set",
        MaxQueryPerformanceLevel = "MEDIUM",
        QueryThroughputMultiplier = 1,
        StatementQueuedTimeoutInSeconds = 30,
        StatementTimeoutInSeconds = 3600,
    });

});

    package generated_program;

import com.pulumi.Context;
import com.pulumi.Pulumi;
import com.pulumi.core.Output;
import com.pulumi.snowflake.WarehouseAdaptive;
import com.pulumi.snowflake.WarehouseAdaptiveArgs;
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 adaptive warehouse (only required fields)
        var basic = new WarehouseAdaptive("basic", WarehouseAdaptiveArgs.builder()
            .name("my_adaptive_warehouse")
            .build());

        // Complete adaptive warehouse (all fields set)
        var complete = new WarehouseAdaptive("complete", WarehouseAdaptiveArgs.builder()
            .name("my_adaptive_warehouse_complete")
            .comment("My adaptive warehouse with all options set")
            .maxQueryPerformanceLevel("MEDIUM")
            .queryThroughputMultiplier(1)
            .statementQueuedTimeoutInSeconds(30)
            .statementTimeoutInSeconds(3600)
            .build());

    }
}

    resources:
  # Basic adaptive warehouse (only required fields)
  basic:
    type: snowflake:WarehouseAdaptive
    properties:
      name: my_adaptive_warehouse
  # Complete adaptive warehouse (all fields set)
  complete:
    type: snowflake:WarehouseAdaptive
    properties:
      name: my_adaptive_warehouse_complete
      comment: My adaptive warehouse with all options set
      maxQueryPerformanceLevel: MEDIUM
      queryThroughputMultiplier: 1
      statementQueuedTimeoutInSeconds: 30
      statementTimeoutInSeconds: 3600

    Example coming soon!

    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.

    Create WarehouseAdaptive Resource

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

    Constructor syntax

    new WarehouseAdaptive(name: string, args?: WarehouseAdaptiveArgs, opts?: CustomResourceOptions);
    @overload
def WarehouseAdaptive(resource_name: str,
                      args: Optional[WarehouseAdaptiveArgs] = None,
                      opts: Optional[ResourceOptions] = None)

@overload
def WarehouseAdaptive(resource_name: str,
                      opts: Optional[ResourceOptions] = None,
                      comment: Optional[str] = None,
                      max_query_performance_level: Optional[str] = None,
                      name: Optional[str] = None,
                      query_throughput_multiplier: Optional[int] = None,
                      statement_queued_timeout_in_seconds: Optional[int] = None,
                      statement_timeout_in_seconds: Optional[int] = None)
    func NewWarehouseAdaptive(ctx *Context, name string, args *WarehouseAdaptiveArgs, opts ...ResourceOption) (*WarehouseAdaptive, error)
    public WarehouseAdaptive(string name, WarehouseAdaptiveArgs? args = null, CustomResourceOptions? opts = null)
    public WarehouseAdaptive(String name, WarehouseAdaptiveArgs args)
public WarehouseAdaptive(String name, WarehouseAdaptiveArgs args, CustomResourceOptions options)

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


    resource "snowflake_warehouseadaptive" "name" {
    # resource properties
}

    Parameters

    name string
    The unique name of the resource.
    args WarehouseAdaptiveArgs
    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 WarehouseAdaptiveArgs
    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 WarehouseAdaptiveArgs
    The arguments to resource properties.
    opts ResourceOption
    Bag of options to control resource's behavior.
    name string
    The unique name of the resource.
    args WarehouseAdaptiveArgs
    The arguments to resource properties.
    opts CustomResourceOptions
    Bag of options to control resource's behavior.
    name String
    The unique name of the resource.
    args WarehouseAdaptiveArgs
    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 warehouseAdaptiveResource = new Snowflake.WarehouseAdaptive("warehouseAdaptiveResource", new()
{
    Comment = "string",
    MaxQueryPerformanceLevel = "string",
    Name = "string",
    QueryThroughputMultiplier = 0,
    StatementQueuedTimeoutInSeconds = 0,
    StatementTimeoutInSeconds = 0,
});

    example, err := snowflake.NewWarehouseAdaptive(ctx, "warehouseAdaptiveResource", &snowflake.WarehouseAdaptiveArgs{
	Comment:                         pulumi.String("string"),
	MaxQueryPerformanceLevel:        pulumi.String("string"),
	Name:                            pulumi.String("string"),
	QueryThroughputMultiplier:       pulumi.Int(0),
	StatementQueuedTimeoutInSeconds: pulumi.Int(0),
	StatementTimeoutInSeconds:       pulumi.Int(0),
})

    resource "snowflake_warehouseadaptive" "warehouseAdaptiveResource" {
  comment                             = "string"
  max_query_performance_level         = "string"
  name                                = "string"
  query_throughput_multiplier         = 0
  statement_queued_timeout_in_seconds = 0
  statement_timeout_in_seconds        = 0
}

    var warehouseAdaptiveResource = new WarehouseAdaptive("warehouseAdaptiveResource", WarehouseAdaptiveArgs.builder()
    .comment("string")
    .maxQueryPerformanceLevel("string")
    .name("string")
    .queryThroughputMultiplier(0)
    .statementQueuedTimeoutInSeconds(0)
    .statementTimeoutInSeconds(0)
    .build());

    warehouse_adaptive_resource = snowflake.WarehouseAdaptive("warehouseAdaptiveResource",
    comment="string",
    max_query_performance_level="string",
    name="string",
    query_throughput_multiplier=0,
    statement_queued_timeout_in_seconds=0,
    statement_timeout_in_seconds=0)

    const warehouseAdaptiveResource = new snowflake.WarehouseAdaptive("warehouseAdaptiveResource", {
    comment: "string",
    maxQueryPerformanceLevel: "string",
    name: "string",
    queryThroughputMultiplier: 0,
    statementQueuedTimeoutInSeconds: 0,
    statementTimeoutInSeconds: 0,
});

    type: snowflake:WarehouseAdaptive
properties:
    comment: string
    maxQueryPerformanceLevel: string
    name: string
    queryThroughputMultiplier: 0
    statementQueuedTimeoutInSeconds: 0
    statementTimeoutInSeconds: 0

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

    Comment string
    Specifies a comment for the adaptive warehouse.
    MaxQueryPerformanceLevel string
    Specifies the maximum query performance level for the adaptive warehouse. Determines the initial compute capacity. Valid values are (case-insensitive): XSMALL | SMALL | MEDIUM | LARGE | XLARGE | XXLARGE | XXXLARGE | X4LARGE.
    Name string
    Identifier for the adaptive warehouse; must be unique for your account. Due to technical limitations (read more here), avoid using the following characters: |, ., ".
    QueryThroughputMultiplier int
    (Default: fallback to Snowflake default - uses special value that cannot be set in the configuration manually (-1)) Specifies the query throughput multiplier for the adaptive warehouse.
    StatementQueuedTimeoutInSeconds int
    Object parameter that specifies the time, in seconds, a SQL statement (query, DDL, DML, etc.) can be queued on a warehouse before it is canceled by the system.
    StatementTimeoutInSeconds int
    Specifies the time, in seconds, after which a running SQL statement (query, DDL, DML, etc.) is canceled by the system.
    Comment string
    Specifies a comment for the adaptive warehouse.
    MaxQueryPerformanceLevel string
    Specifies the maximum query performance level for the adaptive warehouse. Determines the initial compute capacity. Valid values are (case-insensitive): XSMALL | SMALL | MEDIUM | LARGE | XLARGE | XXLARGE | XXXLARGE | X4LARGE.
    Name string
    Identifier for the adaptive warehouse; must be unique for your account. Due to technical limitations (read more here), avoid using the following characters: |, ., ".
    QueryThroughputMultiplier int
    (Default: fallback to Snowflake default - uses special value that cannot be set in the configuration manually (-1)) Specifies the query throughput multiplier for the adaptive warehouse.
    StatementQueuedTimeoutInSeconds int
    Object parameter that specifies the time, in seconds, a SQL statement (query, DDL, DML, etc.) can be queued on a warehouse before it is canceled by the system.
    StatementTimeoutInSeconds int
    Specifies the time, in seconds, after which a running SQL statement (query, DDL, DML, etc.) is canceled by the system.
    comment string
    Specifies a comment for the adaptive warehouse.
    max_query_performance_level string
    Specifies the maximum query performance level for the adaptive warehouse. Determines the initial compute capacity. Valid values are (case-insensitive): XSMALL | SMALL | MEDIUM | LARGE | XLARGE | XXLARGE | XXXLARGE | X4LARGE.
    name string
    Identifier for the adaptive warehouse; must be unique for your account. Due to technical limitations (read more here), avoid using the following characters: |, ., ".
    query_throughput_multiplier number
    (Default: fallback to Snowflake default - uses special value that cannot be set in the configuration manually (-1)) Specifies the query throughput multiplier for the adaptive 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 a 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.
    comment String
    Specifies a comment for the adaptive warehouse.
    maxQueryPerformanceLevel String
    Specifies the maximum query performance level for the adaptive warehouse. Determines the initial compute capacity. Valid values are (case-insensitive): XSMALL | SMALL | MEDIUM | LARGE | XLARGE | XXLARGE | XXXLARGE | X4LARGE.
    name String
    Identifier for the adaptive warehouse; must be unique for your account. Due to technical limitations (read more here), avoid using the following characters: |, ., ".
    queryThroughputMultiplier Integer
    (Default: fallback to Snowflake default - uses special value that cannot be set in the configuration manually (-1)) Specifies the query throughput multiplier for the adaptive warehouse.
    statementQueuedTimeoutInSeconds Integer
    Object parameter that specifies the time, in seconds, a SQL statement (query, DDL, DML, etc.) can be queued on a warehouse before it is canceled by the system.
    statementTimeoutInSeconds Integer
    Specifies the time, in seconds, after which a running SQL statement (query, DDL, DML, etc.) is canceled by the system.
    comment string
    Specifies a comment for the adaptive warehouse.
    maxQueryPerformanceLevel string
    Specifies the maximum query performance level for the adaptive warehouse. Determines the initial compute capacity. Valid values are (case-insensitive): XSMALL | SMALL | MEDIUM | LARGE | XLARGE | XXLARGE | XXXLARGE | X4LARGE.
    name string
    Identifier for the adaptive warehouse; must be unique for your account. Due to technical limitations (read more here), avoid using the following characters: |, ., ".
    queryThroughputMultiplier number
    (Default: fallback to Snowflake default - uses special value that cannot be set in the configuration manually (-1)) Specifies the query throughput multiplier for the adaptive warehouse.
    statementQueuedTimeoutInSeconds number
    Object parameter that specifies the time, in seconds, a SQL statement (query, DDL, DML, etc.) can be queued on a warehouse before it is canceled by the system.
    statementTimeoutInSeconds number
    Specifies the time, in seconds, after which a running SQL statement (query, DDL, DML, etc.) is canceled by the system.
    comment str
    Specifies a comment for the adaptive warehouse.
    max_query_performance_level str
    Specifies the maximum query performance level for the adaptive warehouse. Determines the initial compute capacity. Valid values are (case-insensitive): XSMALL | SMALL | MEDIUM | LARGE | XLARGE | XXLARGE | XXXLARGE | X4LARGE.
    name str
    Identifier for the adaptive warehouse; must be unique for your account. Due to technical limitations (read more here), avoid using the following characters: |, ., ".
    query_throughput_multiplier int
    (Default: fallback to Snowflake default - uses special value that cannot be set in the configuration manually (-1)) Specifies the query throughput multiplier for the adaptive warehouse.
    statement_queued_timeout_in_seconds int
    Object parameter that specifies the time, in seconds, a SQL statement (query, DDL, DML, etc.) can be queued on a warehouse before it is canceled by the system.
    statement_timeout_in_seconds int
    Specifies the time, in seconds, after which a running SQL statement (query, DDL, DML, etc.) is canceled by the system.
    comment String
    Specifies a comment for the adaptive warehouse.
    maxQueryPerformanceLevel String
    Specifies the maximum query performance level for the adaptive warehouse. Determines the initial compute capacity. Valid values are (case-insensitive): XSMALL | SMALL | MEDIUM | LARGE | XLARGE | XXLARGE | XXXLARGE | X4LARGE.
    name String
    Identifier for the adaptive warehouse; must be unique for your account. Due to technical limitations (read more here), avoid using the following characters: |, ., ".
    queryThroughputMultiplier Number
    (Default: fallback to Snowflake default - uses special value that cannot be set in the configuration manually (-1)) Specifies the query throughput multiplier for the adaptive warehouse.
    statementQueuedTimeoutInSeconds Number
    Object parameter that specifies the time, in seconds, a SQL statement (query, DDL, DML, etc.) can be queued on a warehouse before it is canceled by the system.
    statementTimeoutInSeconds Number
    Specifies the time, in seconds, after which a running SQL statement (query, DDL, DML, etc.) is canceled by the system.

    Outputs

    All input properties are implicitly available as output properties. Additionally, the WarehouseAdaptive 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<WarehouseAdaptiveParameter>
    Outputs the result of SHOW PARAMETERS IN WAREHOUSE for the given adaptive warehouse.
    ShowOutputs List<WarehouseAdaptiveShowOutput>
    Outputs the result of SHOW WAREHOUSES for the given adaptive warehouse.
    WarehouseType string
    Specifies the type for the adaptive 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 []WarehouseAdaptiveParameter
    Outputs the result of SHOW PARAMETERS IN WAREHOUSE for the given adaptive warehouse.
    ShowOutputs []WarehouseAdaptiveShowOutput
    Outputs the result of SHOW WAREHOUSES for the given adaptive warehouse.
    WarehouseType string
    Specifies the type for the adaptive 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 adaptive warehouse.
    show_outputs list(object)
    Outputs the result of SHOW WAREHOUSES for the given adaptive warehouse.
    warehouse_type string
    Specifies the type for the adaptive 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<WarehouseAdaptiveParameter>
    Outputs the result of SHOW PARAMETERS IN WAREHOUSE for the given adaptive warehouse.
    showOutputs List<WarehouseAdaptiveShowOutput>
    Outputs the result of SHOW WAREHOUSES for the given adaptive warehouse.
    warehouseType String
    Specifies the type for the adaptive 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 WarehouseAdaptiveParameter[]
    Outputs the result of SHOW PARAMETERS IN WAREHOUSE for the given adaptive warehouse.
    showOutputs WarehouseAdaptiveShowOutput[]
    Outputs the result of SHOW WAREHOUSES for the given adaptive warehouse.
    warehouseType string
    Specifies the type for the adaptive 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[WarehouseAdaptiveParameter]
    Outputs the result of SHOW PARAMETERS IN WAREHOUSE for the given adaptive warehouse.
    show_outputs Sequence[WarehouseAdaptiveShowOutput]
    Outputs the result of SHOW WAREHOUSES for the given adaptive warehouse.
    warehouse_type str
    Specifies the type for the adaptive 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 adaptive warehouse.
    showOutputs List<Property Map>
    Outputs the result of SHOW WAREHOUSES for the given adaptive warehouse.
    warehouseType String
    Specifies the type for the adaptive warehouse. This field is used for checking external changes and recreating the resource if needed.

    Look up Existing WarehouseAdaptive Resource

    Get an existing WarehouseAdaptive 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?: WarehouseAdaptiveState, opts?: CustomResourceOptions): WarehouseAdaptive
    @staticmethod
def get(resource_name: str,
        id: str,
        opts: Optional[ResourceOptions] = None,
        comment: Optional[str] = None,
        fully_qualified_name: Optional[str] = None,
        max_query_performance_level: Optional[str] = None,
        name: Optional[str] = None,
        parameters: Optional[Sequence[WarehouseAdaptiveParameterArgs]] = None,
        query_throughput_multiplier: Optional[int] = None,
        show_outputs: Optional[Sequence[WarehouseAdaptiveShowOutputArgs]] = None,
        statement_queued_timeout_in_seconds: Optional[int] = None,
        statement_timeout_in_seconds: Optional[int] = None,
        warehouse_type: Optional[str] = None) -> WarehouseAdaptive
    func GetWarehouseAdaptive(ctx *Context, name string, id IDInput, state *WarehouseAdaptiveState, opts ...ResourceOption) (*WarehouseAdaptive, error)
    public static WarehouseAdaptive Get(string name, Input<string> id, WarehouseAdaptiveState? state, CustomResourceOptions? opts = null)
    public static WarehouseAdaptive get(String name, Output<String> id, WarehouseAdaptiveState state, CustomResourceOptions options)
    resources:  _:    type: snowflake:WarehouseAdaptive    get:      id: ${id}
    import {
  to = snowflake_warehouseadaptive.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:
    Comment string
    Specifies a comment for the adaptive warehouse.
    FullyQualifiedName string
    Fully qualified name of the resource. For more information, see object name resolution.
    MaxQueryPerformanceLevel string
    Specifies the maximum query performance level for the adaptive warehouse. Determines the initial compute capacity. Valid values are (case-insensitive): XSMALL | SMALL | MEDIUM | LARGE | XLARGE | XXLARGE | XXXLARGE | X4LARGE.
    Name string
    Identifier for the adaptive warehouse; must be unique for your account. Due to technical limitations (read more here), avoid using the following characters: |, ., ".
    Parameters List<WarehouseAdaptiveParameter>
    Outputs the result of SHOW PARAMETERS IN WAREHOUSE for the given adaptive warehouse.
    QueryThroughputMultiplier int
    (Default: fallback to Snowflake default - uses special value that cannot be set in the configuration manually (-1)) Specifies the query throughput multiplier for the adaptive warehouse.
    ShowOutputs List<WarehouseAdaptiveShowOutput>
    Outputs the result of SHOW WAREHOUSES for the given adaptive warehouse.
    StatementQueuedTimeoutInSeconds int
    Object parameter that specifies the time, in seconds, a SQL statement (query, DDL, DML, etc.) can be queued on a warehouse before it is canceled by the system.
    StatementTimeoutInSeconds int
    Specifies the time, in seconds, after which a running SQL statement (query, DDL, DML, etc.) is canceled by the system.
    WarehouseType string
    Specifies the type for the adaptive warehouse. This field is used for checking external changes and recreating the resource if needed.
    Comment string
    Specifies a comment for the adaptive warehouse.
    FullyQualifiedName string
    Fully qualified name of the resource. For more information, see object name resolution.
    MaxQueryPerformanceLevel string
    Specifies the maximum query performance level for the adaptive warehouse. Determines the initial compute capacity. Valid values are (case-insensitive): XSMALL | SMALL | MEDIUM | LARGE | XLARGE | XXLARGE | XXXLARGE | X4LARGE.
    Name string
    Identifier for the adaptive warehouse; must be unique for your account. Due to technical limitations (read more here), avoid using the following characters: |, ., ".
    Parameters []WarehouseAdaptiveParameterArgs
    Outputs the result of SHOW PARAMETERS IN WAREHOUSE for the given adaptive warehouse.
    QueryThroughputMultiplier int
    (Default: fallback to Snowflake default - uses special value that cannot be set in the configuration manually (-1)) Specifies the query throughput multiplier for the adaptive warehouse.
    ShowOutputs []WarehouseAdaptiveShowOutputArgs
    Outputs the result of SHOW WAREHOUSES for the given adaptive warehouse.
    StatementQueuedTimeoutInSeconds int
    Object parameter that specifies the time, in seconds, a SQL statement (query, DDL, DML, etc.) can be queued on a warehouse before it is canceled by the system.
    StatementTimeoutInSeconds int
    Specifies the time, in seconds, after which a running SQL statement (query, DDL, DML, etc.) is canceled by the system.
    WarehouseType string
    Specifies the type for the adaptive warehouse. This field is used for checking external changes and recreating the resource if needed.
    comment string
    Specifies a comment for the adaptive warehouse.
    fully_qualified_name string
    Fully qualified name of the resource. For more information, see object name resolution.
    max_query_performance_level string
    Specifies the maximum query performance level for the adaptive warehouse. Determines the initial compute capacity. Valid values are (case-insensitive): XSMALL | SMALL | MEDIUM | LARGE | XLARGE | XXLARGE | XXXLARGE | X4LARGE.
    name string
    Identifier for the adaptive 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 adaptive warehouse.
    query_throughput_multiplier number
    (Default: fallback to Snowflake default - uses special value that cannot be set in the configuration manually (-1)) Specifies the query throughput multiplier for the adaptive warehouse.
    show_outputs list(object)
    Outputs the result of SHOW WAREHOUSES for the given adaptive 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 a 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.
    warehouse_type string
    Specifies the type for the adaptive warehouse. This field is used for checking external changes and recreating the resource if needed.
    comment String
    Specifies a comment for the adaptive warehouse.
    fullyQualifiedName String
    Fully qualified name of the resource. For more information, see object name resolution.
    maxQueryPerformanceLevel String
    Specifies the maximum query performance level for the adaptive warehouse. Determines the initial compute capacity. Valid values are (case-insensitive): XSMALL | SMALL | MEDIUM | LARGE | XLARGE | XXLARGE | XXXLARGE | X4LARGE.
    name String
    Identifier for the adaptive warehouse; must be unique for your account. Due to technical limitations (read more here), avoid using the following characters: |, ., ".
    parameters List<WarehouseAdaptiveParameter>
    Outputs the result of SHOW PARAMETERS IN WAREHOUSE for the given adaptive warehouse.
    queryThroughputMultiplier Integer
    (Default: fallback to Snowflake default - uses special value that cannot be set in the configuration manually (-1)) Specifies the query throughput multiplier for the adaptive warehouse.
    showOutputs List<WarehouseAdaptiveShowOutput>
    Outputs the result of SHOW WAREHOUSES for the given adaptive warehouse.
    statementQueuedTimeoutInSeconds Integer
    Object parameter that specifies the time, in seconds, a SQL statement (query, DDL, DML, etc.) can be queued on a warehouse before it is canceled by the system.
    statementTimeoutInSeconds Integer
    Specifies the time, in seconds, after which a running SQL statement (query, DDL, DML, etc.) is canceled by the system.
    warehouseType String
    Specifies the type for the adaptive warehouse. This field is used for checking external changes and recreating the resource if needed.
    comment string
    Specifies a comment for the adaptive warehouse.
    fullyQualifiedName string
    Fully qualified name of the resource. For more information, see object name resolution.
    maxQueryPerformanceLevel string
    Specifies the maximum query performance level for the adaptive warehouse. Determines the initial compute capacity. Valid values are (case-insensitive): XSMALL | SMALL | MEDIUM | LARGE | XLARGE | XXLARGE | XXXLARGE | X4LARGE.
    name string
    Identifier for the adaptive warehouse; must be unique for your account. Due to technical limitations (read more here), avoid using the following characters: |, ., ".
    parameters WarehouseAdaptiveParameter[]
    Outputs the result of SHOW PARAMETERS IN WAREHOUSE for the given adaptive warehouse.
    queryThroughputMultiplier number
    (Default: fallback to Snowflake default - uses special value that cannot be set in the configuration manually (-1)) Specifies the query throughput multiplier for the adaptive warehouse.
    showOutputs WarehouseAdaptiveShowOutput[]
    Outputs the result of SHOW WAREHOUSES for the given adaptive warehouse.
    statementQueuedTimeoutInSeconds number
    Object parameter that specifies the time, in seconds, a SQL statement (query, DDL, DML, etc.) can be queued on a warehouse before it is canceled by the system.
    statementTimeoutInSeconds number
    Specifies the time, in seconds, after which a running SQL statement (query, DDL, DML, etc.) is canceled by the system.
    warehouseType string
    Specifies the type for the adaptive warehouse. This field is used for checking external changes and recreating the resource if needed.
    comment str
    Specifies a comment for the adaptive warehouse.
    fully_qualified_name str
    Fully qualified name of the resource. For more information, see object name resolution.
    max_query_performance_level str
    Specifies the maximum query performance level for the adaptive warehouse. Determines the initial compute capacity. Valid values are (case-insensitive): XSMALL | SMALL | MEDIUM | LARGE | XLARGE | XXLARGE | XXXLARGE | X4LARGE.
    name str
    Identifier for the adaptive warehouse; must be unique for your account. Due to technical limitations (read more here), avoid using the following characters: |, ., ".
    parameters Sequence[WarehouseAdaptiveParameterArgs]
    Outputs the result of SHOW PARAMETERS IN WAREHOUSE for the given adaptive warehouse.
    query_throughput_multiplier int
    (Default: fallback to Snowflake default - uses special value that cannot be set in the configuration manually (-1)) Specifies the query throughput multiplier for the adaptive warehouse.
    show_outputs Sequence[WarehouseAdaptiveShowOutputArgs]
    Outputs the result of SHOW WAREHOUSES for the given adaptive warehouse.
    statement_queued_timeout_in_seconds int
    Object parameter that specifies the time, in seconds, a SQL statement (query, DDL, DML, etc.) can be queued on a warehouse before it is canceled by the system.
    statement_timeout_in_seconds int
    Specifies the time, in seconds, after which a running SQL statement (query, DDL, DML, etc.) is canceled by the system.
    warehouse_type str
    Specifies the type for the adaptive warehouse. This field is used for checking external changes and recreating the resource if needed.
    comment String
    Specifies a comment for the adaptive warehouse.
    fullyQualifiedName String
    Fully qualified name of the resource. For more information, see object name resolution.
    maxQueryPerformanceLevel String
    Specifies the maximum query performance level for the adaptive warehouse. Determines the initial compute capacity. Valid values are (case-insensitive): XSMALL | SMALL | MEDIUM | LARGE | XLARGE | XXLARGE | XXXLARGE | X4LARGE.
    name String
    Identifier for the adaptive 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 adaptive warehouse.
    queryThroughputMultiplier Number
    (Default: fallback to Snowflake default - uses special value that cannot be set in the configuration manually (-1)) Specifies the query throughput multiplier for the adaptive warehouse.
    showOutputs List<Property Map>
    Outputs the result of SHOW WAREHOUSES for the given adaptive warehouse.
    statementQueuedTimeoutInSeconds Number
    Object parameter that specifies the time, in seconds, a SQL statement (query, DDL, DML, etc.) can be queued on a warehouse before it is canceled by the system.
    statementTimeoutInSeconds Number
    Specifies the time, in seconds, after which a running SQL statement (query, DDL, DML, etc.) is canceled by the system.
    warehouseType String
    Specifies the type for the adaptive warehouse. This field is used for checking external changes and recreating the resource if needed.

    Supporting Types

    WarehouseAdaptiveParameter, WarehouseAdaptiveParameterArgs

    WarehouseAdaptiveParameterStatementQueuedTimeoutInSecond, WarehouseAdaptiveParameterStatementQueuedTimeoutInSecondArgs

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

    WarehouseAdaptiveParameterStatementTimeoutInSecond, WarehouseAdaptiveParameterStatementTimeoutInSecondArgs

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

    WarehouseAdaptiveShowOutput, WarehouseAdaptiveShowOutputArgs

    autoResume Boolean
    available Double
    comment String
    createdOn String
    isCurrent Boolean
    isDefault Boolean
    maxQueryPerformanceLevel String
    name String
    other Double
    owner String
    ownerRoleType String
    provisioning Double
    queryThroughputMultiplier Integer
    queued Integer
    quiescing Double
    resourceMonitor String
    resumedOn String
    running Integer
    state String
    type String
    updatedOn String
    autoResume boolean
    available number
    comment string
    createdOn string
    isCurrent boolean
    isDefault boolean
    maxQueryPerformanceLevel string
    name string
    other number
    owner string
    ownerRoleType string
    provisioning number
    queryThroughputMultiplier number
    queued number
    quiescing number
    resourceMonitor string
    resumedOn string
    running number
    state string
    type string
    updatedOn string
    autoResume Boolean
    available Number
    comment String
    createdOn String
    isCurrent Boolean
    isDefault Boolean
    maxQueryPerformanceLevel String
    name String
    other Number
    owner String
    ownerRoleType String
    provisioning Number
    queryThroughputMultiplier Number
    queued Number
    quiescing Number
    resourceMonitor String
    resumedOn String
    running Number
    state String
    type String
    updatedOn String

    Import

    $ pulumi import snowflake:index/warehouseAdaptive:WarehouseAdaptive 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.
    snowflake logo
    Viewing docs for Snowflake v2.15.0
    published on Saturday, May 9, 2026 by Pulumi
    Schema (JSON)
    pulumi/pulumi-snowflake
      Try Pulumi Cloud free. Your team will thank you.