1. Registry
  2. Packages
  3. Snowflake Provider
  4. API Docs
  5. Schema
Viewing docs for Snowflake v2.23.0
published on Friday, Nov 6, 2026 by Pulumi
snowflake logo
Viewing docs for Snowflake v2.23.0
published on Friday, Nov 6, 2026 by Pulumi

    Note Field CLASSIFICATION_ROLE is currently missing. It will be added in the future.

    Note A schema cannot be dropped successfully if it contains network rule-network policy associations. The error looks like 098508 (2BP01): Cannot drop schema SCHEMA as it includes network rule - policy associations. . Currently, the provider does not unassign such objects automatically. Before dropping the resource, first unassign the network rule from the relevant objects. See guide for more details.

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

    Create Schema Resource

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

    Constructor syntax

    new Schema(name: string, args: SchemaArgs, opts?: CustomResourceOptions);
    @overload
    def Schema(resource_name: str,
               args: SchemaArgs,
               opts: Optional[ResourceOptions] = None)
    
    @overload
    def Schema(resource_name: str,
               opts: Optional[ResourceOptions] = None,
               database: Optional[str] = None,
               max_data_extension_time_in_days: Optional[int] = None,
               enable_console_output: Optional[bool] = None,
               comment: Optional[str] = None,
               default_ddl_collation: Optional[str] = None,
               default_notebook_compute_pool_cpu: Optional[str] = None,
               default_notebook_compute_pool_gpu: Optional[str] = None,
               catalog: Optional[str] = None,
               external_volume: Optional[str] = None,
               is_transient: Optional[str] = None,
               log_event_level: Optional[str] = None,
               data_retention_time_in_days: Optional[int] = None,
               log_level: Optional[str] = None,
               storage_serialization_policy: Optional[str] = None,
               pipe_execution_paused: Optional[bool] = None,
               quoted_identifiers_ignore_case: Optional[bool] = None,
               replace_invalid_characters: Optional[bool] = None,
               name: Optional[str] = None,
               suspend_task_after_num_failures: Optional[int] = None,
               task_auto_retry_attempts: Optional[int] = None,
               trace_level: Optional[str] = None,
               user_task_managed_initial_warehouse_size: Optional[str] = None,
               user_task_minimum_trigger_interval_in_seconds: Optional[int] = None,
               user_task_timeout_ms: Optional[int] = None,
               with_managed_access: Optional[str] = None)
    func NewSchema(ctx *Context, name string, args SchemaArgs, opts ...ResourceOption) (*Schema, error)
    public Schema(string name, SchemaArgs args, CustomResourceOptions? opts = null)
    public Schema(String name, SchemaArgs args)
    public Schema(String name, SchemaArgs args, CustomResourceOptions options)
    
    type: snowflake:Schema
    properties: # The arguments to resource properties.
    options: # Bag of options to control resource's behavior.
    
    
    resource "snowflake_schema" "name" {
        # resource properties
    }

    Parameters

    name string
    The unique name of the resource.
    args SchemaArgs
    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 SchemaArgs
    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 SchemaArgs
    The arguments to resource properties.
    opts ResourceOption
    Bag of options to control resource's behavior.
    name string
    The unique name of the resource.
    args SchemaArgs
    The arguments to resource properties.
    opts CustomResourceOptions
    Bag of options to control resource's behavior.
    name String
    The unique name of the resource.
    args SchemaArgs
    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 schemaResource = new Snowflake.Schema("schemaResource", new()
    {
        Database = "string",
        MaxDataExtensionTimeInDays = 0,
        EnableConsoleOutput = false,
        Comment = "string",
        DefaultDdlCollation = "string",
        DefaultNotebookComputePoolCpu = "string",
        DefaultNotebookComputePoolGpu = "string",
        Catalog = "string",
        ExternalVolume = "string",
        IsTransient = "string",
        LogEventLevel = "string",
        DataRetentionTimeInDays = 0,
        LogLevel = "string",
        StorageSerializationPolicy = "string",
        PipeExecutionPaused = false,
        QuotedIdentifiersIgnoreCase = false,
        ReplaceInvalidCharacters = false,
        Name = "string",
        SuspendTaskAfterNumFailures = 0,
        TaskAutoRetryAttempts = 0,
        TraceLevel = "string",
        UserTaskManagedInitialWarehouseSize = "string",
        UserTaskMinimumTriggerIntervalInSeconds = 0,
        UserTaskTimeoutMs = 0,
        WithManagedAccess = "string",
    });
    
    example, err := snowflake.NewSchema(ctx, "schemaResource", &snowflake.SchemaArgs{
    	Database:                                pulumi.String("string"),
    	MaxDataExtensionTimeInDays:              pulumi.Int(0),
    	EnableConsoleOutput:                     pulumi.Bool(false),
    	Comment:                                 pulumi.String("string"),
    	DefaultDdlCollation:                     pulumi.String("string"),
    	DefaultNotebookComputePoolCpu:           pulumi.String("string"),
    	DefaultNotebookComputePoolGpu:           pulumi.String("string"),
    	Catalog:                                 pulumi.String("string"),
    	ExternalVolume:                          pulumi.String("string"),
    	IsTransient:                             pulumi.String("string"),
    	LogEventLevel:                           pulumi.String("string"),
    	DataRetentionTimeInDays:                 pulumi.Int(0),
    	LogLevel:                                pulumi.String("string"),
    	StorageSerializationPolicy:              pulumi.String("string"),
    	PipeExecutionPaused:                     pulumi.Bool(false),
    	QuotedIdentifiersIgnoreCase:             pulumi.Bool(false),
    	ReplaceInvalidCharacters:                pulumi.Bool(false),
    	Name:                                    pulumi.String("string"),
    	SuspendTaskAfterNumFailures:             pulumi.Int(0),
    	TaskAutoRetryAttempts:                   pulumi.Int(0),
    	TraceLevel:                              pulumi.String("string"),
    	UserTaskManagedInitialWarehouseSize:     pulumi.String("string"),
    	UserTaskMinimumTriggerIntervalInSeconds: pulumi.Int(0),
    	UserTaskTimeoutMs:                       pulumi.Int(0),
    	WithManagedAccess:                       pulumi.String("string"),
    })
    
    resource "snowflake_schema" "schemaResource" {
      lifecycle {
        create_before_destroy = true
      }
      database                                      = "string"
      max_data_extension_time_in_days               = 0
      enable_console_output                         = false
      comment                                       = "string"
      default_ddl_collation                         = "string"
      default_notebook_compute_pool_cpu             = "string"
      default_notebook_compute_pool_gpu             = "string"
      catalog                                       = "string"
      external_volume                               = "string"
      is_transient                                  = "string"
      log_event_level                               = "string"
      data_retention_time_in_days                   = 0
      log_level                                     = "string"
      storage_serialization_policy                  = "string"
      pipe_execution_paused                         = false
      quoted_identifiers_ignore_case                = false
      replace_invalid_characters                    = false
      name                                          = "string"
      suspend_task_after_num_failures               = 0
      task_auto_retry_attempts                      = 0
      trace_level                                   = "string"
      user_task_managed_initial_warehouse_size      = "string"
      user_task_minimum_trigger_interval_in_seconds = 0
      user_task_timeout_ms                          = 0
      with_managed_access                           = "string"
    }
    
    var schemaResource = new Schema("schemaResource", SchemaArgs.builder()
        .database("string")
        .maxDataExtensionTimeInDays(0)
        .enableConsoleOutput(false)
        .comment("string")
        .defaultDdlCollation("string")
        .defaultNotebookComputePoolCpu("string")
        .defaultNotebookComputePoolGpu("string")
        .catalog("string")
        .externalVolume("string")
        .isTransient("string")
        .logEventLevel("string")
        .dataRetentionTimeInDays(0)
        .logLevel("string")
        .storageSerializationPolicy("string")
        .pipeExecutionPaused(false)
        .quotedIdentifiersIgnoreCase(false)
        .replaceInvalidCharacters(false)
        .name("string")
        .suspendTaskAfterNumFailures(0)
        .taskAutoRetryAttempts(0)
        .traceLevel("string")
        .userTaskManagedInitialWarehouseSize("string")
        .userTaskMinimumTriggerIntervalInSeconds(0)
        .userTaskTimeoutMs(0)
        .withManagedAccess("string")
        .build());
    
    schema_resource = snowflake.Schema("schemaResource",
        database="string",
        max_data_extension_time_in_days=0,
        enable_console_output=False,
        comment="string",
        default_ddl_collation="string",
        default_notebook_compute_pool_cpu="string",
        default_notebook_compute_pool_gpu="string",
        catalog="string",
        external_volume="string",
        is_transient="string",
        log_event_level="string",
        data_retention_time_in_days=0,
        log_level="string",
        storage_serialization_policy="string",
        pipe_execution_paused=False,
        quoted_identifiers_ignore_case=False,
        replace_invalid_characters=False,
        name="string",
        suspend_task_after_num_failures=0,
        task_auto_retry_attempts=0,
        trace_level="string",
        user_task_managed_initial_warehouse_size="string",
        user_task_minimum_trigger_interval_in_seconds=0,
        user_task_timeout_ms=0,
        with_managed_access="string")
    
    const schemaResource = new snowflake.Schema("schemaResource", {
        database: "string",
        maxDataExtensionTimeInDays: 0,
        enableConsoleOutput: false,
        comment: "string",
        defaultDdlCollation: "string",
        defaultNotebookComputePoolCpu: "string",
        defaultNotebookComputePoolGpu: "string",
        catalog: "string",
        externalVolume: "string",
        isTransient: "string",
        logEventLevel: "string",
        dataRetentionTimeInDays: 0,
        logLevel: "string",
        storageSerializationPolicy: "string",
        pipeExecutionPaused: false,
        quotedIdentifiersIgnoreCase: false,
        replaceInvalidCharacters: false,
        name: "string",
        suspendTaskAfterNumFailures: 0,
        taskAutoRetryAttempts: 0,
        traceLevel: "string",
        userTaskManagedInitialWarehouseSize: "string",
        userTaskMinimumTriggerIntervalInSeconds: 0,
        userTaskTimeoutMs: 0,
        withManagedAccess: "string",
    });
    
    type: snowflake:Schema
    properties:
        catalog: string
        comment: string
        dataRetentionTimeInDays: 0
        database: string
        defaultDdlCollation: string
        defaultNotebookComputePoolCpu: string
        defaultNotebookComputePoolGpu: string
        enableConsoleOutput: false
        externalVolume: string
        isTransient: string
        logEventLevel: string
        logLevel: string
        maxDataExtensionTimeInDays: 0
        name: string
        pipeExecutionPaused: false
        quotedIdentifiersIgnoreCase: false
        replaceInvalidCharacters: false
        storageSerializationPolicy: string
        suspendTaskAfterNumFailures: 0
        taskAutoRetryAttempts: 0
        traceLevel: string
        userTaskManagedInitialWarehouseSize: string
        userTaskMinimumTriggerIntervalInSeconds: 0
        userTaskTimeoutMs: 0
        withManagedAccess: string
    

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

    Database string
    The database in which to create the schema. Due to technical limitations (read more here), avoid using the following characters: |, ., ".
    Catalog string
    The parameter that specifies the default catalog to use for Iceberg tables. For more information, check CATALOG docs.
    Comment string
    Specifies a comment for the schema.
    DataRetentionTimeInDays int
    Specifies the number of days for which Time Travel actions (CLONE and UNDROP) can be performed on the database, as well as specifying the default Time Travel retention time for all schemas created in the database. For more details, see Understanding & Using Time Travel. For more information, check DATARETENTIONTIMEINDAYS docs.
    DefaultDdlCollation string
    Specifies a default collation specification for all schemas and tables added to the database. It can be overridden on schema or table level. For more information, see collation specification. For more information, check DEFAULTDDLCOLLATION docs.
    DefaultNotebookComputePoolCpu string
    Sets the preferred CPU compute pool used for Notebooks on CPU Container Runtime. For more information, check DEFAULTNOTEBOOKCOMPUTEPOOLCPU docs.
    DefaultNotebookComputePoolGpu string
    Sets the preferred GPU compute pool used for Notebooks on GPU Container Runtime. For more information, check DEFAULTNOTEBOOKCOMPUTEPOOLGPU docs.
    EnableConsoleOutput bool
    If true, enables stdout/stderr fast path logging for anonymous stored procedures. For more information, check ENABLECONSOLEOUTPUT docs.
    ExternalVolume string
    The parameter that specifies the default external volume to use for Iceberg tables. For more information, check EXTERNAL_VOLUME docs.
    IsTransient string
    (Default: fallback to Snowflake default - uses special value that cannot be set in the configuration manually (default)) Specifies the schema as transient. Transient schemas do not have a Fail-safe period so they do not incur additional storage costs once they leave Time Travel; however, this means they are also not protected by Fail-safe in the event of a data loss. 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.
    LogEventLevel string
    Specifies the severity level of log events (rows with record type EVENT) that should be ingested and made available in the active event table. Log events at the specified level (and at more severe levels) are ingested. Valid values are (case-insensitive): TRACE | DEBUG | INFO | WARN | ERROR | FATAL | OFF. For more information, check LOGEVENTLEVEL docs.
    LogLevel string
    Specifies the severity level of messages that should be ingested and made available in the active event table. Messages at the specified level (and at more severe levels) are ingested. Valid values are (case-insensitive): TRACE | DEBUG | INFO | WARN | ERROR | FATAL | OFF. For more information, check LOG_LEVEL docs.
    MaxDataExtensionTimeInDays int
    Object parameter that specifies the maximum number of days for which Snowflake can extend the data retention period for tables in the database to prevent streams on the tables from becoming stale. For more information, check MAXDATAEXTENSIONTIMEIN_DAYS docs.
    Name string
    Specifies the identifier for the schema; must be unique for the database in which the schema is created. When the name is PUBLIC, during creation the provider checks if this schema has already been created and, in such case, ALTER is used to match the desired state. Due to technical limitations (read more here), avoid using the following characters: |, ., ".
    PipeExecutionPaused bool
    Specifies whether to pause a running pipe, primarily in preparation for transferring ownership of the pipe to a different role. For more information, check PIPEEXECUTIONPAUSED docs.
    QuotedIdentifiersIgnoreCase bool
    If true, the case of quoted identifiers is ignored. For more information, check QUOTEDIDENTIFIERSIGNORE_CASE docs.
    ReplaceInvalidCharacters bool
    Specifies whether to replace invalid UTF-8 characters with the Unicode replacement character in query results for an Iceberg table. You can only set this parameter for tables that use an external Iceberg catalog. For more information, check REPLACEINVALIDCHARACTERS docs.
    StorageSerializationPolicy string
    The storage serialization policy for Iceberg tables that use Snowflake as the catalog. COMPATIBLE: Snowflake performs encoding and compression of data files that ensures interoperability with third-party compute engines. OPTIMIZED: Snowflake performs encoding and compression of data files that ensures the best table performance within Snowflake. Valid values are (case-insensitive): COMPATIBLE | OPTIMIZED. For more information, check STORAGESERIALIZATIONPOLICY docs.
    SuspendTaskAfterNumFailures int
    How many times a task must fail in a row before it is automatically suspended. 0 disables auto-suspending. For more information, check SUSPENDTASKAFTERNUMFAILURES docs.
    TaskAutoRetryAttempts int
    Maximum automatic retries allowed for a user task. For more information, check TASKAUTORETRY_ATTEMPTS docs.
    TraceLevel string
    Controls how trace events are ingested into the event table. Valid values are (case-insensitive): ALWAYS | ON_EVENT | PROPAGATE | OFF. For more information, check TRACE_LEVEL docs.
    UserTaskManagedInitialWarehouseSize string
    The initial size of warehouse to use for managed warehouses in the absence of history. Valid values are (case-insensitive): XSMALL | SMALL | MEDIUM | LARGE | XLARGE | XXLARGE | XXXLARGE | X4LARGE | X5LARGE | X6LARGE. For more information, check USERTASKMANAGEDINITIALWAREHOUSE_SIZE docs.
    UserTaskMinimumTriggerIntervalInSeconds int
    Minimum amount of time between Triggered Task executions in seconds. For more information, check USERTASKMINIMUMTRIGGERINTERVALINSECONDS docs.
    UserTaskTimeoutMs int
    User task execution timeout in milliseconds. For more information, check USERTASKTIMEOUT_MS docs.
    WithManagedAccess string
    (Default: fallback to Snowflake default - uses special value that cannot be set in the configuration manually (default)) Specifies a managed schema. Managed access schemas centralize privilege management with the schema owner. 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.
    Database string
    The database in which to create the schema. Due to technical limitations (read more here), avoid using the following characters: |, ., ".
    Catalog string
    The parameter that specifies the default catalog to use for Iceberg tables. For more information, check CATALOG docs.
    Comment string
    Specifies a comment for the schema.
    DataRetentionTimeInDays int
    Specifies the number of days for which Time Travel actions (CLONE and UNDROP) can be performed on the database, as well as specifying the default Time Travel retention time for all schemas created in the database. For more details, see Understanding & Using Time Travel. For more information, check DATARETENTIONTIMEINDAYS docs.
    DefaultDdlCollation string
    Specifies a default collation specification for all schemas and tables added to the database. It can be overridden on schema or table level. For more information, see collation specification. For more information, check DEFAULTDDLCOLLATION docs.
    DefaultNotebookComputePoolCpu string
    Sets the preferred CPU compute pool used for Notebooks on CPU Container Runtime. For more information, check DEFAULTNOTEBOOKCOMPUTEPOOLCPU docs.
    DefaultNotebookComputePoolGpu string
    Sets the preferred GPU compute pool used for Notebooks on GPU Container Runtime. For more information, check DEFAULTNOTEBOOKCOMPUTEPOOLGPU docs.
    EnableConsoleOutput bool
    If true, enables stdout/stderr fast path logging for anonymous stored procedures. For more information, check ENABLECONSOLEOUTPUT docs.
    ExternalVolume string
    The parameter that specifies the default external volume to use for Iceberg tables. For more information, check EXTERNAL_VOLUME docs.
    IsTransient string
    (Default: fallback to Snowflake default - uses special value that cannot be set in the configuration manually (default)) Specifies the schema as transient. Transient schemas do not have a Fail-safe period so they do not incur additional storage costs once they leave Time Travel; however, this means they are also not protected by Fail-safe in the event of a data loss. 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.
    LogEventLevel string
    Specifies the severity level of log events (rows with record type EVENT) that should be ingested and made available in the active event table. Log events at the specified level (and at more severe levels) are ingested. Valid values are (case-insensitive): TRACE | DEBUG | INFO | WARN | ERROR | FATAL | OFF. For more information, check LOGEVENTLEVEL docs.
    LogLevel string
    Specifies the severity level of messages that should be ingested and made available in the active event table. Messages at the specified level (and at more severe levels) are ingested. Valid values are (case-insensitive): TRACE | DEBUG | INFO | WARN | ERROR | FATAL | OFF. For more information, check LOG_LEVEL docs.
    MaxDataExtensionTimeInDays int
    Object parameter that specifies the maximum number of days for which Snowflake can extend the data retention period for tables in the database to prevent streams on the tables from becoming stale. For more information, check MAXDATAEXTENSIONTIMEIN_DAYS docs.
    Name string
    Specifies the identifier for the schema; must be unique for the database in which the schema is created. When the name is PUBLIC, during creation the provider checks if this schema has already been created and, in such case, ALTER is used to match the desired state. Due to technical limitations (read more here), avoid using the following characters: |, ., ".
    PipeExecutionPaused bool
    Specifies whether to pause a running pipe, primarily in preparation for transferring ownership of the pipe to a different role. For more information, check PIPEEXECUTIONPAUSED docs.
    QuotedIdentifiersIgnoreCase bool
    If true, the case of quoted identifiers is ignored. For more information, check QUOTEDIDENTIFIERSIGNORE_CASE docs.
    ReplaceInvalidCharacters bool
    Specifies whether to replace invalid UTF-8 characters with the Unicode replacement character in query results for an Iceberg table. You can only set this parameter for tables that use an external Iceberg catalog. For more information, check REPLACEINVALIDCHARACTERS docs.
    StorageSerializationPolicy string
    The storage serialization policy for Iceberg tables that use Snowflake as the catalog. COMPATIBLE: Snowflake performs encoding and compression of data files that ensures interoperability with third-party compute engines. OPTIMIZED: Snowflake performs encoding and compression of data files that ensures the best table performance within Snowflake. Valid values are (case-insensitive): COMPATIBLE | OPTIMIZED. For more information, check STORAGESERIALIZATIONPOLICY docs.
    SuspendTaskAfterNumFailures int
    How many times a task must fail in a row before it is automatically suspended. 0 disables auto-suspending. For more information, check SUSPENDTASKAFTERNUMFAILURES docs.
    TaskAutoRetryAttempts int
    Maximum automatic retries allowed for a user task. For more information, check TASKAUTORETRY_ATTEMPTS docs.
    TraceLevel string
    Controls how trace events are ingested into the event table. Valid values are (case-insensitive): ALWAYS | ON_EVENT | PROPAGATE | OFF. For more information, check TRACE_LEVEL docs.
    UserTaskManagedInitialWarehouseSize string
    The initial size of warehouse to use for managed warehouses in the absence of history. Valid values are (case-insensitive): XSMALL | SMALL | MEDIUM | LARGE | XLARGE | XXLARGE | XXXLARGE | X4LARGE | X5LARGE | X6LARGE. For more information, check USERTASKMANAGEDINITIALWAREHOUSE_SIZE docs.
    UserTaskMinimumTriggerIntervalInSeconds int
    Minimum amount of time between Triggered Task executions in seconds. For more information, check USERTASKMINIMUMTRIGGERINTERVALINSECONDS docs.
    UserTaskTimeoutMs int
    User task execution timeout in milliseconds. For more information, check USERTASKTIMEOUT_MS docs.
    WithManagedAccess string
    (Default: fallback to Snowflake default - uses special value that cannot be set in the configuration manually (default)) Specifies a managed schema. Managed access schemas centralize privilege management with the schema owner. 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.
    database string
    The database in which to create the schema. Due to technical limitations (read more here), avoid using the following characters: |, ., ".
    catalog string
    The parameter that specifies the default catalog to use for Iceberg tables. For more information, check CATALOG docs.
    comment string
    Specifies a comment for the schema.
    data_retention_time_in_days number
    Specifies the number of days for which Time Travel actions (CLONE and UNDROP) can be performed on the database, as well as specifying the default Time Travel retention time for all schemas created in the database. For more details, see Understanding & Using Time Travel. For more information, check DATARETENTIONTIMEINDAYS docs.
    default_ddl_collation string
    Specifies a default collation specification for all schemas and tables added to the database. It can be overridden on schema or table level. For more information, see collation specification. For more information, check DEFAULTDDLCOLLATION docs.
    default_notebook_compute_pool_cpu string
    Sets the preferred CPU compute pool used for Notebooks on CPU Container Runtime. For more information, check DEFAULTNOTEBOOKCOMPUTEPOOLCPU docs.
    default_notebook_compute_pool_gpu string
    Sets the preferred GPU compute pool used for Notebooks on GPU Container Runtime. For more information, check DEFAULTNOTEBOOKCOMPUTEPOOLGPU docs.
    enable_console_output bool
    If true, enables stdout/stderr fast path logging for anonymous stored procedures. For more information, check ENABLECONSOLEOUTPUT docs.
    external_volume string
    The parameter that specifies the default external volume to use for Iceberg tables. For more information, check EXTERNAL_VOLUME docs.
    is_transient string
    (Default: fallback to Snowflake default - uses special value that cannot be set in the configuration manually (default)) Specifies the schema as transient. Transient schemas do not have a Fail-safe period so they do not incur additional storage costs once they leave Time Travel; however, this means they are also not protected by Fail-safe in the event of a data loss. 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.
    log_event_level string
    Specifies the severity level of log events (rows with record type EVENT) that should be ingested and made available in the active event table. Log events at the specified level (and at more severe levels) are ingested. Valid values are (case-insensitive): TRACE | DEBUG | INFO | WARN | ERROR | FATAL | OFF. For more information, check LOGEVENTLEVEL docs.
    log_level string
    Specifies the severity level of messages that should be ingested and made available in the active event table. Messages at the specified level (and at more severe levels) are ingested. Valid values are (case-insensitive): TRACE | DEBUG | INFO | WARN | ERROR | FATAL | OFF. For more information, check LOG_LEVEL docs.
    max_data_extension_time_in_days number
    Object parameter that specifies the maximum number of days for which Snowflake can extend the data retention period for tables in the database to prevent streams on the tables from becoming stale. For more information, check MAXDATAEXTENSIONTIMEIN_DAYS docs.
    name string
    Specifies the identifier for the schema; must be unique for the database in which the schema is created. When the name is PUBLIC, during creation the provider checks if this schema has already been created and, in such case, ALTER is used to match the desired state. Due to technical limitations (read more here), avoid using the following characters: |, ., ".
    pipe_execution_paused bool
    Specifies whether to pause a running pipe, primarily in preparation for transferring ownership of the pipe to a different role. For more information, check PIPEEXECUTIONPAUSED docs.
    quoted_identifiers_ignore_case bool
    If true, the case of quoted identifiers is ignored. For more information, check QUOTEDIDENTIFIERSIGNORE_CASE docs.
    replace_invalid_characters bool
    Specifies whether to replace invalid UTF-8 characters with the Unicode replacement character in query results for an Iceberg table. You can only set this parameter for tables that use an external Iceberg catalog. For more information, check REPLACEINVALIDCHARACTERS docs.
    storage_serialization_policy string
    The storage serialization policy for Iceberg tables that use Snowflake as the catalog. COMPATIBLE: Snowflake performs encoding and compression of data files that ensures interoperability with third-party compute engines. OPTIMIZED: Snowflake performs encoding and compression of data files that ensures the best table performance within Snowflake. Valid values are (case-insensitive): COMPATIBLE | OPTIMIZED. For more information, check STORAGESERIALIZATIONPOLICY docs.
    suspend_task_after_num_failures number
    How many times a task must fail in a row before it is automatically suspended. 0 disables auto-suspending. For more information, check SUSPENDTASKAFTERNUMFAILURES docs.
    task_auto_retry_attempts number
    Maximum automatic retries allowed for a user task. For more information, check TASKAUTORETRY_ATTEMPTS docs.
    trace_level string
    Controls how trace events are ingested into the event table. Valid values are (case-insensitive): ALWAYS | ON_EVENT | PROPAGATE | OFF. For more information, check TRACE_LEVEL docs.
    user_task_managed_initial_warehouse_size string
    The initial size of warehouse to use for managed warehouses in the absence of history. Valid values are (case-insensitive): XSMALL | SMALL | MEDIUM | LARGE | XLARGE | XXLARGE | XXXLARGE | X4LARGE | X5LARGE | X6LARGE. For more information, check USERTASKMANAGEDINITIALWAREHOUSE_SIZE docs.
    user_task_minimum_trigger_interval_in_seconds number
    Minimum amount of time between Triggered Task executions in seconds. For more information, check USERTASKMINIMUMTRIGGERINTERVALINSECONDS docs.
    user_task_timeout_ms number
    User task execution timeout in milliseconds. For more information, check USERTASKTIMEOUT_MS docs.
    with_managed_access string
    (Default: fallback to Snowflake default - uses special value that cannot be set in the configuration manually (default)) Specifies a managed schema. Managed access schemas centralize privilege management with the schema owner. 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.
    database String
    The database in which to create the schema. Due to technical limitations (read more here), avoid using the following characters: |, ., ".
    catalog String
    The parameter that specifies the default catalog to use for Iceberg tables. For more information, check CATALOG docs.
    comment String
    Specifies a comment for the schema.
    dataRetentionTimeInDays Integer
    Specifies the number of days for which Time Travel actions (CLONE and UNDROP) can be performed on the database, as well as specifying the default Time Travel retention time for all schemas created in the database. For more details, see Understanding & Using Time Travel. For more information, check DATARETENTIONTIMEINDAYS docs.
    defaultDdlCollation String
    Specifies a default collation specification for all schemas and tables added to the database. It can be overridden on schema or table level. For more information, see collation specification. For more information, check DEFAULTDDLCOLLATION docs.
    defaultNotebookComputePoolCpu String
    Sets the preferred CPU compute pool used for Notebooks on CPU Container Runtime. For more information, check DEFAULTNOTEBOOKCOMPUTEPOOLCPU docs.
    defaultNotebookComputePoolGpu String
    Sets the preferred GPU compute pool used for Notebooks on GPU Container Runtime. For more information, check DEFAULTNOTEBOOKCOMPUTEPOOLGPU docs.
    enableConsoleOutput Boolean
    If true, enables stdout/stderr fast path logging for anonymous stored procedures. For more information, check ENABLECONSOLEOUTPUT docs.
    externalVolume String
    The parameter that specifies the default external volume to use for Iceberg tables. For more information, check EXTERNAL_VOLUME docs.
    isTransient String
    (Default: fallback to Snowflake default - uses special value that cannot be set in the configuration manually (default)) Specifies the schema as transient. Transient schemas do not have a Fail-safe period so they do not incur additional storage costs once they leave Time Travel; however, this means they are also not protected by Fail-safe in the event of a data loss. 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.
    logEventLevel String
    Specifies the severity level of log events (rows with record type EVENT) that should be ingested and made available in the active event table. Log events at the specified level (and at more severe levels) are ingested. Valid values are (case-insensitive): TRACE | DEBUG | INFO | WARN | ERROR | FATAL | OFF. For more information, check LOGEVENTLEVEL docs.
    logLevel String
    Specifies the severity level of messages that should be ingested and made available in the active event table. Messages at the specified level (and at more severe levels) are ingested. Valid values are (case-insensitive): TRACE | DEBUG | INFO | WARN | ERROR | FATAL | OFF. For more information, check LOG_LEVEL docs.
    maxDataExtensionTimeInDays Integer
    Object parameter that specifies the maximum number of days for which Snowflake can extend the data retention period for tables in the database to prevent streams on the tables from becoming stale. For more information, check MAXDATAEXTENSIONTIMEIN_DAYS docs.
    name String
    Specifies the identifier for the schema; must be unique for the database in which the schema is created. When the name is PUBLIC, during creation the provider checks if this schema has already been created and, in such case, ALTER is used to match the desired state. Due to technical limitations (read more here), avoid using the following characters: |, ., ".
    pipeExecutionPaused Boolean
    Specifies whether to pause a running pipe, primarily in preparation for transferring ownership of the pipe to a different role. For more information, check PIPEEXECUTIONPAUSED docs.
    quotedIdentifiersIgnoreCase Boolean
    If true, the case of quoted identifiers is ignored. For more information, check QUOTEDIDENTIFIERSIGNORE_CASE docs.
    replaceInvalidCharacters Boolean
    Specifies whether to replace invalid UTF-8 characters with the Unicode replacement character in query results for an Iceberg table. You can only set this parameter for tables that use an external Iceberg catalog. For more information, check REPLACEINVALIDCHARACTERS docs.
    storageSerializationPolicy String
    The storage serialization policy for Iceberg tables that use Snowflake as the catalog. COMPATIBLE: Snowflake performs encoding and compression of data files that ensures interoperability with third-party compute engines. OPTIMIZED: Snowflake performs encoding and compression of data files that ensures the best table performance within Snowflake. Valid values are (case-insensitive): COMPATIBLE | OPTIMIZED. For more information, check STORAGESERIALIZATIONPOLICY docs.
    suspendTaskAfterNumFailures Integer
    How many times a task must fail in a row before it is automatically suspended. 0 disables auto-suspending. For more information, check SUSPENDTASKAFTERNUMFAILURES docs.
    taskAutoRetryAttempts Integer
    Maximum automatic retries allowed for a user task. For more information, check TASKAUTORETRY_ATTEMPTS docs.
    traceLevel String
    Controls how trace events are ingested into the event table. Valid values are (case-insensitive): ALWAYS | ON_EVENT | PROPAGATE | OFF. For more information, check TRACE_LEVEL docs.
    userTaskManagedInitialWarehouseSize String
    The initial size of warehouse to use for managed warehouses in the absence of history. Valid values are (case-insensitive): XSMALL | SMALL | MEDIUM | LARGE | XLARGE | XXLARGE | XXXLARGE | X4LARGE | X5LARGE | X6LARGE. For more information, check USERTASKMANAGEDINITIALWAREHOUSE_SIZE docs.
    userTaskMinimumTriggerIntervalInSeconds Integer
    Minimum amount of time between Triggered Task executions in seconds. For more information, check USERTASKMINIMUMTRIGGERINTERVALINSECONDS docs.
    userTaskTimeoutMs Integer
    User task execution timeout in milliseconds. For more information, check USERTASKTIMEOUT_MS docs.
    withManagedAccess String
    (Default: fallback to Snowflake default - uses special value that cannot be set in the configuration manually (default)) Specifies a managed schema. Managed access schemas centralize privilege management with the schema owner. 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.
    database string
    The database in which to create the schema. Due to technical limitations (read more here), avoid using the following characters: |, ., ".
    catalog string
    The parameter that specifies the default catalog to use for Iceberg tables. For more information, check CATALOG docs.
    comment string
    Specifies a comment for the schema.
    dataRetentionTimeInDays number
    Specifies the number of days for which Time Travel actions (CLONE and UNDROP) can be performed on the database, as well as specifying the default Time Travel retention time for all schemas created in the database. For more details, see Understanding & Using Time Travel. For more information, check DATARETENTIONTIMEINDAYS docs.
    defaultDdlCollation string
    Specifies a default collation specification for all schemas and tables added to the database. It can be overridden on schema or table level. For more information, see collation specification. For more information, check DEFAULTDDLCOLLATION docs.
    defaultNotebookComputePoolCpu string
    Sets the preferred CPU compute pool used for Notebooks on CPU Container Runtime. For more information, check DEFAULTNOTEBOOKCOMPUTEPOOLCPU docs.
    defaultNotebookComputePoolGpu string
    Sets the preferred GPU compute pool used for Notebooks on GPU Container Runtime. For more information, check DEFAULTNOTEBOOKCOMPUTEPOOLGPU docs.
    enableConsoleOutput boolean
    If true, enables stdout/stderr fast path logging for anonymous stored procedures. For more information, check ENABLECONSOLEOUTPUT docs.
    externalVolume string
    The parameter that specifies the default external volume to use for Iceberg tables. For more information, check EXTERNAL_VOLUME docs.
    isTransient string
    (Default: fallback to Snowflake default - uses special value that cannot be set in the configuration manually (default)) Specifies the schema as transient. Transient schemas do not have a Fail-safe period so they do not incur additional storage costs once they leave Time Travel; however, this means they are also not protected by Fail-safe in the event of a data loss. 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.
    logEventLevel string
    Specifies the severity level of log events (rows with record type EVENT) that should be ingested and made available in the active event table. Log events at the specified level (and at more severe levels) are ingested. Valid values are (case-insensitive): TRACE | DEBUG | INFO | WARN | ERROR | FATAL | OFF. For more information, check LOGEVENTLEVEL docs.
    logLevel string
    Specifies the severity level of messages that should be ingested and made available in the active event table. Messages at the specified level (and at more severe levels) are ingested. Valid values are (case-insensitive): TRACE | DEBUG | INFO | WARN | ERROR | FATAL | OFF. For more information, check LOG_LEVEL docs.
    maxDataExtensionTimeInDays number
    Object parameter that specifies the maximum number of days for which Snowflake can extend the data retention period for tables in the database to prevent streams on the tables from becoming stale. For more information, check MAXDATAEXTENSIONTIMEIN_DAYS docs.
    name string
    Specifies the identifier for the schema; must be unique for the database in which the schema is created. When the name is PUBLIC, during creation the provider checks if this schema has already been created and, in such case, ALTER is used to match the desired state. Due to technical limitations (read more here), avoid using the following characters: |, ., ".
    pipeExecutionPaused boolean
    Specifies whether to pause a running pipe, primarily in preparation for transferring ownership of the pipe to a different role. For more information, check PIPEEXECUTIONPAUSED docs.
    quotedIdentifiersIgnoreCase boolean
    If true, the case of quoted identifiers is ignored. For more information, check QUOTEDIDENTIFIERSIGNORE_CASE docs.
    replaceInvalidCharacters boolean
    Specifies whether to replace invalid UTF-8 characters with the Unicode replacement character in query results for an Iceberg table. You can only set this parameter for tables that use an external Iceberg catalog. For more information, check REPLACEINVALIDCHARACTERS docs.
    storageSerializationPolicy string
    The storage serialization policy for Iceberg tables that use Snowflake as the catalog. COMPATIBLE: Snowflake performs encoding and compression of data files that ensures interoperability with third-party compute engines. OPTIMIZED: Snowflake performs encoding and compression of data files that ensures the best table performance within Snowflake. Valid values are (case-insensitive): COMPATIBLE | OPTIMIZED. For more information, check STORAGESERIALIZATIONPOLICY docs.
    suspendTaskAfterNumFailures number
    How many times a task must fail in a row before it is automatically suspended. 0 disables auto-suspending. For more information, check SUSPENDTASKAFTERNUMFAILURES docs.
    taskAutoRetryAttempts number
    Maximum automatic retries allowed for a user task. For more information, check TASKAUTORETRY_ATTEMPTS docs.
    traceLevel string
    Controls how trace events are ingested into the event table. Valid values are (case-insensitive): ALWAYS | ON_EVENT | PROPAGATE | OFF. For more information, check TRACE_LEVEL docs.
    userTaskManagedInitialWarehouseSize string
    The initial size of warehouse to use for managed warehouses in the absence of history. Valid values are (case-insensitive): XSMALL | SMALL | MEDIUM | LARGE | XLARGE | XXLARGE | XXXLARGE | X4LARGE | X5LARGE | X6LARGE. For more information, check USERTASKMANAGEDINITIALWAREHOUSE_SIZE docs.
    userTaskMinimumTriggerIntervalInSeconds number
    Minimum amount of time between Triggered Task executions in seconds. For more information, check USERTASKMINIMUMTRIGGERINTERVALINSECONDS docs.
    userTaskTimeoutMs number
    User task execution timeout in milliseconds. For more information, check USERTASKTIMEOUT_MS docs.
    withManagedAccess string
    (Default: fallback to Snowflake default - uses special value that cannot be set in the configuration manually (default)) Specifies a managed schema. Managed access schemas centralize privilege management with the schema owner. 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.
    database str
    The database in which to create the schema. Due to technical limitations (read more here), avoid using the following characters: |, ., ".
    catalog str
    The parameter that specifies the default catalog to use for Iceberg tables. For more information, check CATALOG docs.
    comment str
    Specifies a comment for the schema.
    data_retention_time_in_days int
    Specifies the number of days for which Time Travel actions (CLONE and UNDROP) can be performed on the database, as well as specifying the default Time Travel retention time for all schemas created in the database. For more details, see Understanding & Using Time Travel. For more information, check DATARETENTIONTIMEINDAYS docs.
    default_ddl_collation str
    Specifies a default collation specification for all schemas and tables added to the database. It can be overridden on schema or table level. For more information, see collation specification. For more information, check DEFAULTDDLCOLLATION docs.
    default_notebook_compute_pool_cpu str
    Sets the preferred CPU compute pool used for Notebooks on CPU Container Runtime. For more information, check DEFAULTNOTEBOOKCOMPUTEPOOLCPU docs.
    default_notebook_compute_pool_gpu str
    Sets the preferred GPU compute pool used for Notebooks on GPU Container Runtime. For more information, check DEFAULTNOTEBOOKCOMPUTEPOOLGPU docs.
    enable_console_output bool
    If true, enables stdout/stderr fast path logging for anonymous stored procedures. For more information, check ENABLECONSOLEOUTPUT docs.
    external_volume str
    The parameter that specifies the default external volume to use for Iceberg tables. For more information, check EXTERNAL_VOLUME docs.
    is_transient str
    (Default: fallback to Snowflake default - uses special value that cannot be set in the configuration manually (default)) Specifies the schema as transient. Transient schemas do not have a Fail-safe period so they do not incur additional storage costs once they leave Time Travel; however, this means they are also not protected by Fail-safe in the event of a data loss. 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.
    log_event_level str
    Specifies the severity level of log events (rows with record type EVENT) that should be ingested and made available in the active event table. Log events at the specified level (and at more severe levels) are ingested. Valid values are (case-insensitive): TRACE | DEBUG | INFO | WARN | ERROR | FATAL | OFF. For more information, check LOGEVENTLEVEL docs.
    log_level str
    Specifies the severity level of messages that should be ingested and made available in the active event table. Messages at the specified level (and at more severe levels) are ingested. Valid values are (case-insensitive): TRACE | DEBUG | INFO | WARN | ERROR | FATAL | OFF. For more information, check LOG_LEVEL docs.
    max_data_extension_time_in_days int
    Object parameter that specifies the maximum number of days for which Snowflake can extend the data retention period for tables in the database to prevent streams on the tables from becoming stale. For more information, check MAXDATAEXTENSIONTIMEIN_DAYS docs.
    name str
    Specifies the identifier for the schema; must be unique for the database in which the schema is created. When the name is PUBLIC, during creation the provider checks if this schema has already been created and, in such case, ALTER is used to match the desired state. Due to technical limitations (read more here), avoid using the following characters: |, ., ".
    pipe_execution_paused bool
    Specifies whether to pause a running pipe, primarily in preparation for transferring ownership of the pipe to a different role. For more information, check PIPEEXECUTIONPAUSED docs.
    quoted_identifiers_ignore_case bool
    If true, the case of quoted identifiers is ignored. For more information, check QUOTEDIDENTIFIERSIGNORE_CASE docs.
    replace_invalid_characters bool
    Specifies whether to replace invalid UTF-8 characters with the Unicode replacement character in query results for an Iceberg table. You can only set this parameter for tables that use an external Iceberg catalog. For more information, check REPLACEINVALIDCHARACTERS docs.
    storage_serialization_policy str
    The storage serialization policy for Iceberg tables that use Snowflake as the catalog. COMPATIBLE: Snowflake performs encoding and compression of data files that ensures interoperability with third-party compute engines. OPTIMIZED: Snowflake performs encoding and compression of data files that ensures the best table performance within Snowflake. Valid values are (case-insensitive): COMPATIBLE | OPTIMIZED. For more information, check STORAGESERIALIZATIONPOLICY docs.
    suspend_task_after_num_failures int
    How many times a task must fail in a row before it is automatically suspended. 0 disables auto-suspending. For more information, check SUSPENDTASKAFTERNUMFAILURES docs.
    task_auto_retry_attempts int
    Maximum automatic retries allowed for a user task. For more information, check TASKAUTORETRY_ATTEMPTS docs.
    trace_level str
    Controls how trace events are ingested into the event table. Valid values are (case-insensitive): ALWAYS | ON_EVENT | PROPAGATE | OFF. For more information, check TRACE_LEVEL docs.
    user_task_managed_initial_warehouse_size str
    The initial size of warehouse to use for managed warehouses in the absence of history. Valid values are (case-insensitive): XSMALL | SMALL | MEDIUM | LARGE | XLARGE | XXLARGE | XXXLARGE | X4LARGE | X5LARGE | X6LARGE. For more information, check USERTASKMANAGEDINITIALWAREHOUSE_SIZE docs.
    user_task_minimum_trigger_interval_in_seconds int
    Minimum amount of time between Triggered Task executions in seconds. For more information, check USERTASKMINIMUMTRIGGERINTERVALINSECONDS docs.
    user_task_timeout_ms int
    User task execution timeout in milliseconds. For more information, check USERTASKTIMEOUT_MS docs.
    with_managed_access str
    (Default: fallback to Snowflake default - uses special value that cannot be set in the configuration manually (default)) Specifies a managed schema. Managed access schemas centralize privilege management with the schema owner. 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.
    database String
    The database in which to create the schema. Due to technical limitations (read more here), avoid using the following characters: |, ., ".
    catalog String
    The parameter that specifies the default catalog to use for Iceberg tables. For more information, check CATALOG docs.
    comment String
    Specifies a comment for the schema.
    dataRetentionTimeInDays Number
    Specifies the number of days for which Time Travel actions (CLONE and UNDROP) can be performed on the database, as well as specifying the default Time Travel retention time for all schemas created in the database. For more details, see Understanding & Using Time Travel. For more information, check DATARETENTIONTIMEINDAYS docs.
    defaultDdlCollation String
    Specifies a default collation specification for all schemas and tables added to the database. It can be overridden on schema or table level. For more information, see collation specification. For more information, check DEFAULTDDLCOLLATION docs.
    defaultNotebookComputePoolCpu String
    Sets the preferred CPU compute pool used for Notebooks on CPU Container Runtime. For more information, check DEFAULTNOTEBOOKCOMPUTEPOOLCPU docs.
    defaultNotebookComputePoolGpu String
    Sets the preferred GPU compute pool used for Notebooks on GPU Container Runtime. For more information, check DEFAULTNOTEBOOKCOMPUTEPOOLGPU docs.
    enableConsoleOutput Boolean
    If true, enables stdout/stderr fast path logging for anonymous stored procedures. For more information, check ENABLECONSOLEOUTPUT docs.
    externalVolume String
    The parameter that specifies the default external volume to use for Iceberg tables. For more information, check EXTERNAL_VOLUME docs.
    isTransient String
    (Default: fallback to Snowflake default - uses special value that cannot be set in the configuration manually (default)) Specifies the schema as transient. Transient schemas do not have a Fail-safe period so they do not incur additional storage costs once they leave Time Travel; however, this means they are also not protected by Fail-safe in the event of a data loss. 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.
    logEventLevel String
    Specifies the severity level of log events (rows with record type EVENT) that should be ingested and made available in the active event table. Log events at the specified level (and at more severe levels) are ingested. Valid values are (case-insensitive): TRACE | DEBUG | INFO | WARN | ERROR | FATAL | OFF. For more information, check LOGEVENTLEVEL docs.
    logLevel String
    Specifies the severity level of messages that should be ingested and made available in the active event table. Messages at the specified level (and at more severe levels) are ingested. Valid values are (case-insensitive): TRACE | DEBUG | INFO | WARN | ERROR | FATAL | OFF. For more information, check LOG_LEVEL docs.
    maxDataExtensionTimeInDays Number
    Object parameter that specifies the maximum number of days for which Snowflake can extend the data retention period for tables in the database to prevent streams on the tables from becoming stale. For more information, check MAXDATAEXTENSIONTIMEIN_DAYS docs.
    name String
    Specifies the identifier for the schema; must be unique for the database in which the schema is created. When the name is PUBLIC, during creation the provider checks if this schema has already been created and, in such case, ALTER is used to match the desired state. Due to technical limitations (read more here), avoid using the following characters: |, ., ".
    pipeExecutionPaused Boolean
    Specifies whether to pause a running pipe, primarily in preparation for transferring ownership of the pipe to a different role. For more information, check PIPEEXECUTIONPAUSED docs.
    quotedIdentifiersIgnoreCase Boolean
    If true, the case of quoted identifiers is ignored. For more information, check QUOTEDIDENTIFIERSIGNORE_CASE docs.
    replaceInvalidCharacters Boolean
    Specifies whether to replace invalid UTF-8 characters with the Unicode replacement character in query results for an Iceberg table. You can only set this parameter for tables that use an external Iceberg catalog. For more information, check REPLACEINVALIDCHARACTERS docs.
    storageSerializationPolicy String
    The storage serialization policy for Iceberg tables that use Snowflake as the catalog. COMPATIBLE: Snowflake performs encoding and compression of data files that ensures interoperability with third-party compute engines. OPTIMIZED: Snowflake performs encoding and compression of data files that ensures the best table performance within Snowflake. Valid values are (case-insensitive): COMPATIBLE | OPTIMIZED. For more information, check STORAGESERIALIZATIONPOLICY docs.
    suspendTaskAfterNumFailures Number
    How many times a task must fail in a row before it is automatically suspended. 0 disables auto-suspending. For more information, check SUSPENDTASKAFTERNUMFAILURES docs.
    taskAutoRetryAttempts Number
    Maximum automatic retries allowed for a user task. For more information, check TASKAUTORETRY_ATTEMPTS docs.
    traceLevel String
    Controls how trace events are ingested into the event table. Valid values are (case-insensitive): ALWAYS | ON_EVENT | PROPAGATE | OFF. For more information, check TRACE_LEVEL docs.
    userTaskManagedInitialWarehouseSize String
    The initial size of warehouse to use for managed warehouses in the absence of history. Valid values are (case-insensitive): XSMALL | SMALL | MEDIUM | LARGE | XLARGE | XXLARGE | XXXLARGE | X4LARGE | X5LARGE | X6LARGE. For more information, check USERTASKMANAGEDINITIALWAREHOUSE_SIZE docs.
    userTaskMinimumTriggerIntervalInSeconds Number
    Minimum amount of time between Triggered Task executions in seconds. For more information, check USERTASKMINIMUMTRIGGERINTERVALINSECONDS docs.
    userTaskTimeoutMs Number
    User task execution timeout in milliseconds. For more information, check USERTASKTIMEOUT_MS docs.
    withManagedAccess String
    (Default: fallback to Snowflake default - uses special value that cannot be set in the configuration manually (default)) Specifies a managed schema. Managed access schemas centralize privilege management with the schema owner. 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.

    Outputs

    All input properties are implicitly available as output properties. Additionally, the Schema resource produces the following output properties:

    DescribeOutputs List<SchemaDescribeOutput>
    Outputs the result of DESCRIBE SCHEMA for the given schema. In order to handle this output, one must grant sufficient privileges, e.g. grantOwnership on all objects in the schema.
    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<SchemaParameter>
    Outputs the result of SHOW PARAMETERS IN SCHEMA for the given schema.
    ShowOutputs List<SchemaShowOutput>
    Outputs the result of SHOW SCHEMAS for the given schema.
    DescribeOutputs []SchemaDescribeOutput
    Outputs the result of DESCRIBE SCHEMA for the given schema. In order to handle this output, one must grant sufficient privileges, e.g. grantOwnership on all objects in the schema.
    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 []SchemaParameter
    Outputs the result of SHOW PARAMETERS IN SCHEMA for the given schema.
    ShowOutputs []SchemaShowOutput
    Outputs the result of SHOW SCHEMAS for the given schema.
    describe_outputs list(object)
    Outputs the result of DESCRIBE SCHEMA for the given schema. In order to handle this output, one must grant sufficient privileges, e.g. grantOwnership on all objects in the schema.
    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 SCHEMA for the given schema.
    show_outputs list(object)
    Outputs the result of SHOW SCHEMAS for the given schema.
    describeOutputs List<SchemaDescribeOutput>
    Outputs the result of DESCRIBE SCHEMA for the given schema. In order to handle this output, one must grant sufficient privileges, e.g. grantOwnership on all objects in the schema.
    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<SchemaParameter>
    Outputs the result of SHOW PARAMETERS IN SCHEMA for the given schema.
    showOutputs List<SchemaShowOutput>
    Outputs the result of SHOW SCHEMAS for the given schema.
    describeOutputs SchemaDescribeOutput[]
    Outputs the result of DESCRIBE SCHEMA for the given schema. In order to handle this output, one must grant sufficient privileges, e.g. grantOwnership on all objects in the schema.
    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 SchemaParameter[]
    Outputs the result of SHOW PARAMETERS IN SCHEMA for the given schema.
    showOutputs SchemaShowOutput[]
    Outputs the result of SHOW SCHEMAS for the given schema.
    describe_outputs Sequence[SchemaDescribeOutput]
    Outputs the result of DESCRIBE SCHEMA for the given schema. In order to handle this output, one must grant sufficient privileges, e.g. grantOwnership on all objects in the schema.
    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[SchemaParameter]
    Outputs the result of SHOW PARAMETERS IN SCHEMA for the given schema.
    show_outputs Sequence[SchemaShowOutput]
    Outputs the result of SHOW SCHEMAS for the given schema.
    describeOutputs List<Property Map>
    Outputs the result of DESCRIBE SCHEMA for the given schema. In order to handle this output, one must grant sufficient privileges, e.g. grantOwnership on all objects in the schema.
    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 SCHEMA for the given schema.
    showOutputs List<Property Map>
    Outputs the result of SHOW SCHEMAS for the given schema.

    Look up Existing Schema Resource

    Get an existing Schema 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?: SchemaState, opts?: CustomResourceOptions): Schema
    @staticmethod
    def get(resource_name: str,
            id: str,
            opts: Optional[ResourceOptions] = None,
            catalog: Optional[str] = None,
            comment: Optional[str] = None,
            data_retention_time_in_days: Optional[int] = None,
            database: Optional[str] = None,
            default_ddl_collation: Optional[str] = None,
            default_notebook_compute_pool_cpu: Optional[str] = None,
            default_notebook_compute_pool_gpu: Optional[str] = None,
            describe_outputs: Optional[Sequence[SchemaDescribeOutputArgs]] = None,
            enable_console_output: Optional[bool] = None,
            external_volume: Optional[str] = None,
            fully_qualified_name: Optional[str] = None,
            is_transient: Optional[str] = None,
            log_event_level: Optional[str] = None,
            log_level: Optional[str] = None,
            max_data_extension_time_in_days: Optional[int] = None,
            name: Optional[str] = None,
            parameters: Optional[Sequence[SchemaParameterArgs]] = None,
            pipe_execution_paused: Optional[bool] = None,
            quoted_identifiers_ignore_case: Optional[bool] = None,
            replace_invalid_characters: Optional[bool] = None,
            show_outputs: Optional[Sequence[SchemaShowOutputArgs]] = None,
            storage_serialization_policy: Optional[str] = None,
            suspend_task_after_num_failures: Optional[int] = None,
            task_auto_retry_attempts: Optional[int] = None,
            trace_level: Optional[str] = None,
            user_task_managed_initial_warehouse_size: Optional[str] = None,
            user_task_minimum_trigger_interval_in_seconds: Optional[int] = None,
            user_task_timeout_ms: Optional[int] = None,
            with_managed_access: Optional[str] = None) -> Schema
    func GetSchema(ctx *Context, name string, id IDInput, state *SchemaState, opts ...ResourceOption) (*Schema, error)
    public static Schema Get(string name, Input<string> id, SchemaState? state, CustomResourceOptions? opts = null)
    public static Schema get(String name, Output<String> id, SchemaState state, CustomResourceOptions options)
    resources:  existingSchema:    type: snowflake:Schema    get:      id: ${id}
    import {
      to = snowflake_schema.example
      id = "${id}"
    }
    
    name string
    The unique name of the resulting resource.
    id Input<ID>
    The unique provider ID of the resource to look up.
    state SchemaState
    Known property values the provider needs, along with the ID, to find the resource. Usually not required.
    opts CustomResourceOptions
    Bag of options to control resource's behavior.
    resource_name str
    The unique name of the resulting resource.
    id str
    The unique provider ID of the resource to look up.
    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 resulting resource.
    id IDInput
    The unique provider ID of the resource to look up.
    state SchemaState
    Known property values the provider needs, along with the ID, to find the resource. Usually not required.
    opts ResourceOption
    Bag of options to control resource's behavior.
    name string
    The unique name of the resulting resource.
    id Input<string>
    The unique provider ID of the resource to look up.
    state SchemaState
    Known property values the provider needs, along with the ID, to find the resource. Usually not required.
    opts CustomResourceOptions
    Bag of options to control resource's behavior.
    name String
    The unique name of the resulting resource.
    id Output<String>
    The unique provider ID of the resource to look up.
    state SchemaState
    Known property values the provider needs, along with the ID, to find the resource. Usually not required.
    options CustomResourceOptions
    Bag of options to control resource's behavior.
    The following state arguments are supported:
    Catalog string
    The parameter that specifies the default catalog to use for Iceberg tables. For more information, check CATALOG docs.
    Comment string
    Specifies a comment for the schema.
    DataRetentionTimeInDays int
    Specifies the number of days for which Time Travel actions (CLONE and UNDROP) can be performed on the database, as well as specifying the default Time Travel retention time for all schemas created in the database. For more details, see Understanding & Using Time Travel. For more information, check DATARETENTIONTIMEINDAYS docs.
    Database string
    The database in which to create the schema. Due to technical limitations (read more here), avoid using the following characters: |, ., ".
    DefaultDdlCollation string
    Specifies a default collation specification for all schemas and tables added to the database. It can be overridden on schema or table level. For more information, see collation specification. For more information, check DEFAULTDDLCOLLATION docs.
    DefaultNotebookComputePoolCpu string
    Sets the preferred CPU compute pool used for Notebooks on CPU Container Runtime. For more information, check DEFAULTNOTEBOOKCOMPUTEPOOLCPU docs.
    DefaultNotebookComputePoolGpu string
    Sets the preferred GPU compute pool used for Notebooks on GPU Container Runtime. For more information, check DEFAULTNOTEBOOKCOMPUTEPOOLGPU docs.
    DescribeOutputs List<SchemaDescribeOutput>
    Outputs the result of DESCRIBE SCHEMA for the given schema. In order to handle this output, one must grant sufficient privileges, e.g. grantOwnership on all objects in the schema.
    EnableConsoleOutput bool
    If true, enables stdout/stderr fast path logging for anonymous stored procedures. For more information, check ENABLECONSOLEOUTPUT docs.
    ExternalVolume string
    The parameter that specifies the default external volume to use for Iceberg tables. For more information, check EXTERNAL_VOLUME docs.
    FullyQualifiedName string
    Fully qualified name of the resource. For more information, see object name resolution.
    IsTransient string
    (Default: fallback to Snowflake default - uses special value that cannot be set in the configuration manually (default)) Specifies the schema as transient. Transient schemas do not have a Fail-safe period so they do not incur additional storage costs once they leave Time Travel; however, this means they are also not protected by Fail-safe in the event of a data loss. 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.
    LogEventLevel string
    Specifies the severity level of log events (rows with record type EVENT) that should be ingested and made available in the active event table. Log events at the specified level (and at more severe levels) are ingested. Valid values are (case-insensitive): TRACE | DEBUG | INFO | WARN | ERROR | FATAL | OFF. For more information, check LOGEVENTLEVEL docs.
    LogLevel string
    Specifies the severity level of messages that should be ingested and made available in the active event table. Messages at the specified level (and at more severe levels) are ingested. Valid values are (case-insensitive): TRACE | DEBUG | INFO | WARN | ERROR | FATAL | OFF. For more information, check LOG_LEVEL docs.
    MaxDataExtensionTimeInDays int
    Object parameter that specifies the maximum number of days for which Snowflake can extend the data retention period for tables in the database to prevent streams on the tables from becoming stale. For more information, check MAXDATAEXTENSIONTIMEIN_DAYS docs.
    Name string
    Specifies the identifier for the schema; must be unique for the database in which the schema is created. When the name is PUBLIC, during creation the provider checks if this schema has already been created and, in such case, ALTER is used to match the desired state. Due to technical limitations (read more here), avoid using the following characters: |, ., ".
    Parameters List<SchemaParameter>
    Outputs the result of SHOW PARAMETERS IN SCHEMA for the given schema.
    PipeExecutionPaused bool
    Specifies whether to pause a running pipe, primarily in preparation for transferring ownership of the pipe to a different role. For more information, check PIPEEXECUTIONPAUSED docs.
    QuotedIdentifiersIgnoreCase bool
    If true, the case of quoted identifiers is ignored. For more information, check QUOTEDIDENTIFIERSIGNORE_CASE docs.
    ReplaceInvalidCharacters bool
    Specifies whether to replace invalid UTF-8 characters with the Unicode replacement character in query results for an Iceberg table. You can only set this parameter for tables that use an external Iceberg catalog. For more information, check REPLACEINVALIDCHARACTERS docs.
    ShowOutputs List<SchemaShowOutput>
    Outputs the result of SHOW SCHEMAS for the given schema.
    StorageSerializationPolicy string
    The storage serialization policy for Iceberg tables that use Snowflake as the catalog. COMPATIBLE: Snowflake performs encoding and compression of data files that ensures interoperability with third-party compute engines. OPTIMIZED: Snowflake performs encoding and compression of data files that ensures the best table performance within Snowflake. Valid values are (case-insensitive): COMPATIBLE | OPTIMIZED. For more information, check STORAGESERIALIZATIONPOLICY docs.
    SuspendTaskAfterNumFailures int
    How many times a task must fail in a row before it is automatically suspended. 0 disables auto-suspending. For more information, check SUSPENDTASKAFTERNUMFAILURES docs.
    TaskAutoRetryAttempts int
    Maximum automatic retries allowed for a user task. For more information, check TASKAUTORETRY_ATTEMPTS docs.
    TraceLevel string
    Controls how trace events are ingested into the event table. Valid values are (case-insensitive): ALWAYS | ON_EVENT | PROPAGATE | OFF. For more information, check TRACE_LEVEL docs.
    UserTaskManagedInitialWarehouseSize string
    The initial size of warehouse to use for managed warehouses in the absence of history. Valid values are (case-insensitive): XSMALL | SMALL | MEDIUM | LARGE | XLARGE | XXLARGE | XXXLARGE | X4LARGE | X5LARGE | X6LARGE. For more information, check USERTASKMANAGEDINITIALWAREHOUSE_SIZE docs.
    UserTaskMinimumTriggerIntervalInSeconds int
    Minimum amount of time between Triggered Task executions in seconds. For more information, check USERTASKMINIMUMTRIGGERINTERVALINSECONDS docs.
    UserTaskTimeoutMs int
    User task execution timeout in milliseconds. For more information, check USERTASKTIMEOUT_MS docs.
    WithManagedAccess string
    (Default: fallback to Snowflake default - uses special value that cannot be set in the configuration manually (default)) Specifies a managed schema. Managed access schemas centralize privilege management with the schema owner. 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.
    Catalog string
    The parameter that specifies the default catalog to use for Iceberg tables. For more information, check CATALOG docs.
    Comment string
    Specifies a comment for the schema.
    DataRetentionTimeInDays int
    Specifies the number of days for which Time Travel actions (CLONE and UNDROP) can be performed on the database, as well as specifying the default Time Travel retention time for all schemas created in the database. For more details, see Understanding & Using Time Travel. For more information, check DATARETENTIONTIMEINDAYS docs.
    Database string
    The database in which to create the schema. Due to technical limitations (read more here), avoid using the following characters: |, ., ".
    DefaultDdlCollation string
    Specifies a default collation specification for all schemas and tables added to the database. It can be overridden on schema or table level. For more information, see collation specification. For more information, check DEFAULTDDLCOLLATION docs.
    DefaultNotebookComputePoolCpu string
    Sets the preferred CPU compute pool used for Notebooks on CPU Container Runtime. For more information, check DEFAULTNOTEBOOKCOMPUTEPOOLCPU docs.
    DefaultNotebookComputePoolGpu string
    Sets the preferred GPU compute pool used for Notebooks on GPU Container Runtime. For more information, check DEFAULTNOTEBOOKCOMPUTEPOOLGPU docs.
    DescribeOutputs []SchemaDescribeOutputArgs
    Outputs the result of DESCRIBE SCHEMA for the given schema. In order to handle this output, one must grant sufficient privileges, e.g. grantOwnership on all objects in the schema.
    EnableConsoleOutput bool
    If true, enables stdout/stderr fast path logging for anonymous stored procedures. For more information, check ENABLECONSOLEOUTPUT docs.
    ExternalVolume string
    The parameter that specifies the default external volume to use for Iceberg tables. For more information, check EXTERNAL_VOLUME docs.
    FullyQualifiedName string
    Fully qualified name of the resource. For more information, see object name resolution.
    IsTransient string
    (Default: fallback to Snowflake default - uses special value that cannot be set in the configuration manually (default)) Specifies the schema as transient. Transient schemas do not have a Fail-safe period so they do not incur additional storage costs once they leave Time Travel; however, this means they are also not protected by Fail-safe in the event of a data loss. 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.
    LogEventLevel string
    Specifies the severity level of log events (rows with record type EVENT) that should be ingested and made available in the active event table. Log events at the specified level (and at more severe levels) are ingested. Valid values are (case-insensitive): TRACE | DEBUG | INFO | WARN | ERROR | FATAL | OFF. For more information, check LOGEVENTLEVEL docs.
    LogLevel string
    Specifies the severity level of messages that should be ingested and made available in the active event table. Messages at the specified level (and at more severe levels) are ingested. Valid values are (case-insensitive): TRACE | DEBUG | INFO | WARN | ERROR | FATAL | OFF. For more information, check LOG_LEVEL docs.
    MaxDataExtensionTimeInDays int
    Object parameter that specifies the maximum number of days for which Snowflake can extend the data retention period for tables in the database to prevent streams on the tables from becoming stale. For more information, check MAXDATAEXTENSIONTIMEIN_DAYS docs.
    Name string
    Specifies the identifier for the schema; must be unique for the database in which the schema is created. When the name is PUBLIC, during creation the provider checks if this schema has already been created and, in such case, ALTER is used to match the desired state. Due to technical limitations (read more here), avoid using the following characters: |, ., ".
    Parameters []SchemaParameterArgs
    Outputs the result of SHOW PARAMETERS IN SCHEMA for the given schema.
    PipeExecutionPaused bool
    Specifies whether to pause a running pipe, primarily in preparation for transferring ownership of the pipe to a different role. For more information, check PIPEEXECUTIONPAUSED docs.
    QuotedIdentifiersIgnoreCase bool
    If true, the case of quoted identifiers is ignored. For more information, check QUOTEDIDENTIFIERSIGNORE_CASE docs.
    ReplaceInvalidCharacters bool
    Specifies whether to replace invalid UTF-8 characters with the Unicode replacement character in query results for an Iceberg table. You can only set this parameter for tables that use an external Iceberg catalog. For more information, check REPLACEINVALIDCHARACTERS docs.
    ShowOutputs []SchemaShowOutputArgs
    Outputs the result of SHOW SCHEMAS for the given schema.
    StorageSerializationPolicy string
    The storage serialization policy for Iceberg tables that use Snowflake as the catalog. COMPATIBLE: Snowflake performs encoding and compression of data files that ensures interoperability with third-party compute engines. OPTIMIZED: Snowflake performs encoding and compression of data files that ensures the best table performance within Snowflake. Valid values are (case-insensitive): COMPATIBLE | OPTIMIZED. For more information, check STORAGESERIALIZATIONPOLICY docs.
    SuspendTaskAfterNumFailures int
    How many times a task must fail in a row before it is automatically suspended. 0 disables auto-suspending. For more information, check SUSPENDTASKAFTERNUMFAILURES docs.
    TaskAutoRetryAttempts int
    Maximum automatic retries allowed for a user task. For more information, check TASKAUTORETRY_ATTEMPTS docs.
    TraceLevel string
    Controls how trace events are ingested into the event table. Valid values are (case-insensitive): ALWAYS | ON_EVENT | PROPAGATE | OFF. For more information, check TRACE_LEVEL docs.
    UserTaskManagedInitialWarehouseSize string
    The initial size of warehouse to use for managed warehouses in the absence of history. Valid values are (case-insensitive): XSMALL | SMALL | MEDIUM | LARGE | XLARGE | XXLARGE | XXXLARGE | X4LARGE | X5LARGE | X6LARGE. For more information, check USERTASKMANAGEDINITIALWAREHOUSE_SIZE docs.
    UserTaskMinimumTriggerIntervalInSeconds int
    Minimum amount of time between Triggered Task executions in seconds. For more information, check USERTASKMINIMUMTRIGGERINTERVALINSECONDS docs.
    UserTaskTimeoutMs int
    User task execution timeout in milliseconds. For more information, check USERTASKTIMEOUT_MS docs.
    WithManagedAccess string
    (Default: fallback to Snowflake default - uses special value that cannot be set in the configuration manually (default)) Specifies a managed schema. Managed access schemas centralize privilege management with the schema owner. 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.
    catalog string
    The parameter that specifies the default catalog to use for Iceberg tables. For more information, check CATALOG docs.
    comment string
    Specifies a comment for the schema.
    data_retention_time_in_days number
    Specifies the number of days for which Time Travel actions (CLONE and UNDROP) can be performed on the database, as well as specifying the default Time Travel retention time for all schemas created in the database. For more details, see Understanding & Using Time Travel. For more information, check DATARETENTIONTIMEINDAYS docs.
    database string
    The database in which to create the schema. Due to technical limitations (read more here), avoid using the following characters: |, ., ".
    default_ddl_collation string
    Specifies a default collation specification for all schemas and tables added to the database. It can be overridden on schema or table level. For more information, see collation specification. For more information, check DEFAULTDDLCOLLATION docs.
    default_notebook_compute_pool_cpu string
    Sets the preferred CPU compute pool used for Notebooks on CPU Container Runtime. For more information, check DEFAULTNOTEBOOKCOMPUTEPOOLCPU docs.
    default_notebook_compute_pool_gpu string
    Sets the preferred GPU compute pool used for Notebooks on GPU Container Runtime. For more information, check DEFAULTNOTEBOOKCOMPUTEPOOLGPU docs.
    describe_outputs list(object)
    Outputs the result of DESCRIBE SCHEMA for the given schema. In order to handle this output, one must grant sufficient privileges, e.g. grantOwnership on all objects in the schema.
    enable_console_output bool
    If true, enables stdout/stderr fast path logging for anonymous stored procedures. For more information, check ENABLECONSOLEOUTPUT docs.
    external_volume string
    The parameter that specifies the default external volume to use for Iceberg tables. For more information, check EXTERNAL_VOLUME docs.
    fully_qualified_name string
    Fully qualified name of the resource. For more information, see object name resolution.
    is_transient string
    (Default: fallback to Snowflake default - uses special value that cannot be set in the configuration manually (default)) Specifies the schema as transient. Transient schemas do not have a Fail-safe period so they do not incur additional storage costs once they leave Time Travel; however, this means they are also not protected by Fail-safe in the event of a data loss. 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.
    log_event_level string
    Specifies the severity level of log events (rows with record type EVENT) that should be ingested and made available in the active event table. Log events at the specified level (and at more severe levels) are ingested. Valid values are (case-insensitive): TRACE | DEBUG | INFO | WARN | ERROR | FATAL | OFF. For more information, check LOGEVENTLEVEL docs.
    log_level string
    Specifies the severity level of messages that should be ingested and made available in the active event table. Messages at the specified level (and at more severe levels) are ingested. Valid values are (case-insensitive): TRACE | DEBUG | INFO | WARN | ERROR | FATAL | OFF. For more information, check LOG_LEVEL docs.
    max_data_extension_time_in_days number
    Object parameter that specifies the maximum number of days for which Snowflake can extend the data retention period for tables in the database to prevent streams on the tables from becoming stale. For more information, check MAXDATAEXTENSIONTIMEIN_DAYS docs.
    name string
    Specifies the identifier for the schema; must be unique for the database in which the schema is created. When the name is PUBLIC, during creation the provider checks if this schema has already been created and, in such case, ALTER is used to match the desired state. Due to technical limitations (read more here), avoid using the following characters: |, ., ".
    parameters list(object)
    Outputs the result of SHOW PARAMETERS IN SCHEMA for the given schema.
    pipe_execution_paused bool
    Specifies whether to pause a running pipe, primarily in preparation for transferring ownership of the pipe to a different role. For more information, check PIPEEXECUTIONPAUSED docs.
    quoted_identifiers_ignore_case bool
    If true, the case of quoted identifiers is ignored. For more information, check QUOTEDIDENTIFIERSIGNORE_CASE docs.
    replace_invalid_characters bool
    Specifies whether to replace invalid UTF-8 characters with the Unicode replacement character in query results for an Iceberg table. You can only set this parameter for tables that use an external Iceberg catalog. For more information, check REPLACEINVALIDCHARACTERS docs.
    show_outputs list(object)
    Outputs the result of SHOW SCHEMAS for the given schema.
    storage_serialization_policy string
    The storage serialization policy for Iceberg tables that use Snowflake as the catalog. COMPATIBLE: Snowflake performs encoding and compression of data files that ensures interoperability with third-party compute engines. OPTIMIZED: Snowflake performs encoding and compression of data files that ensures the best table performance within Snowflake. Valid values are (case-insensitive): COMPATIBLE | OPTIMIZED. For more information, check STORAGESERIALIZATIONPOLICY docs.
    suspend_task_after_num_failures number
    How many times a task must fail in a row before it is automatically suspended. 0 disables auto-suspending. For more information, check SUSPENDTASKAFTERNUMFAILURES docs.
    task_auto_retry_attempts number
    Maximum automatic retries allowed for a user task. For more information, check TASKAUTORETRY_ATTEMPTS docs.
    trace_level string
    Controls how trace events are ingested into the event table. Valid values are (case-insensitive): ALWAYS | ON_EVENT | PROPAGATE | OFF. For more information, check TRACE_LEVEL docs.
    user_task_managed_initial_warehouse_size string
    The initial size of warehouse to use for managed warehouses in the absence of history. Valid values are (case-insensitive): XSMALL | SMALL | MEDIUM | LARGE | XLARGE | XXLARGE | XXXLARGE | X4LARGE | X5LARGE | X6LARGE. For more information, check USERTASKMANAGEDINITIALWAREHOUSE_SIZE docs.
    user_task_minimum_trigger_interval_in_seconds number
    Minimum amount of time between Triggered Task executions in seconds. For more information, check USERTASKMINIMUMTRIGGERINTERVALINSECONDS docs.
    user_task_timeout_ms number
    User task execution timeout in milliseconds. For more information, check USERTASKTIMEOUT_MS docs.
    with_managed_access string
    (Default: fallback to Snowflake default - uses special value that cannot be set in the configuration manually (default)) Specifies a managed schema. Managed access schemas centralize privilege management with the schema owner. 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.
    catalog String
    The parameter that specifies the default catalog to use for Iceberg tables. For more information, check CATALOG docs.
    comment String
    Specifies a comment for the schema.
    dataRetentionTimeInDays Integer
    Specifies the number of days for which Time Travel actions (CLONE and UNDROP) can be performed on the database, as well as specifying the default Time Travel retention time for all schemas created in the database. For more details, see Understanding & Using Time Travel. For more information, check DATARETENTIONTIMEINDAYS docs.
    database String
    The database in which to create the schema. Due to technical limitations (read more here), avoid using the following characters: |, ., ".
    defaultDdlCollation String
    Specifies a default collation specification for all schemas and tables added to the database. It can be overridden on schema or table level. For more information, see collation specification. For more information, check DEFAULTDDLCOLLATION docs.
    defaultNotebookComputePoolCpu String
    Sets the preferred CPU compute pool used for Notebooks on CPU Container Runtime. For more information, check DEFAULTNOTEBOOKCOMPUTEPOOLCPU docs.
    defaultNotebookComputePoolGpu String
    Sets the preferred GPU compute pool used for Notebooks on GPU Container Runtime. For more information, check DEFAULTNOTEBOOKCOMPUTEPOOLGPU docs.
    describeOutputs List<SchemaDescribeOutput>
    Outputs the result of DESCRIBE SCHEMA for the given schema. In order to handle this output, one must grant sufficient privileges, e.g. grantOwnership on all objects in the schema.
    enableConsoleOutput Boolean
    If true, enables stdout/stderr fast path logging for anonymous stored procedures. For more information, check ENABLECONSOLEOUTPUT docs.
    externalVolume String
    The parameter that specifies the default external volume to use for Iceberg tables. For more information, check EXTERNAL_VOLUME docs.
    fullyQualifiedName String
    Fully qualified name of the resource. For more information, see object name resolution.
    isTransient String
    (Default: fallback to Snowflake default - uses special value that cannot be set in the configuration manually (default)) Specifies the schema as transient. Transient schemas do not have a Fail-safe period so they do not incur additional storage costs once they leave Time Travel; however, this means they are also not protected by Fail-safe in the event of a data loss. 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.
    logEventLevel String
    Specifies the severity level of log events (rows with record type EVENT) that should be ingested and made available in the active event table. Log events at the specified level (and at more severe levels) are ingested. Valid values are (case-insensitive): TRACE | DEBUG | INFO | WARN | ERROR | FATAL | OFF. For more information, check LOGEVENTLEVEL docs.
    logLevel String
    Specifies the severity level of messages that should be ingested and made available in the active event table. Messages at the specified level (and at more severe levels) are ingested. Valid values are (case-insensitive): TRACE | DEBUG | INFO | WARN | ERROR | FATAL | OFF. For more information, check LOG_LEVEL docs.
    maxDataExtensionTimeInDays Integer
    Object parameter that specifies the maximum number of days for which Snowflake can extend the data retention period for tables in the database to prevent streams on the tables from becoming stale. For more information, check MAXDATAEXTENSIONTIMEIN_DAYS docs.
    name String
    Specifies the identifier for the schema; must be unique for the database in which the schema is created. When the name is PUBLIC, during creation the provider checks if this schema has already been created and, in such case, ALTER is used to match the desired state. Due to technical limitations (read more here), avoid using the following characters: |, ., ".
    parameters List<SchemaParameter>
    Outputs the result of SHOW PARAMETERS IN SCHEMA for the given schema.
    pipeExecutionPaused Boolean
    Specifies whether to pause a running pipe, primarily in preparation for transferring ownership of the pipe to a different role. For more information, check PIPEEXECUTIONPAUSED docs.
    quotedIdentifiersIgnoreCase Boolean
    If true, the case of quoted identifiers is ignored. For more information, check QUOTEDIDENTIFIERSIGNORE_CASE docs.
    replaceInvalidCharacters Boolean
    Specifies whether to replace invalid UTF-8 characters with the Unicode replacement character in query results for an Iceberg table. You can only set this parameter for tables that use an external Iceberg catalog. For more information, check REPLACEINVALIDCHARACTERS docs.
    showOutputs List<SchemaShowOutput>
    Outputs the result of SHOW SCHEMAS for the given schema.
    storageSerializationPolicy String
    The storage serialization policy for Iceberg tables that use Snowflake as the catalog. COMPATIBLE: Snowflake performs encoding and compression of data files that ensures interoperability with third-party compute engines. OPTIMIZED: Snowflake performs encoding and compression of data files that ensures the best table performance within Snowflake. Valid values are (case-insensitive): COMPATIBLE | OPTIMIZED. For more information, check STORAGESERIALIZATIONPOLICY docs.
    suspendTaskAfterNumFailures Integer
    How many times a task must fail in a row before it is automatically suspended. 0 disables auto-suspending. For more information, check SUSPENDTASKAFTERNUMFAILURES docs.
    taskAutoRetryAttempts Integer
    Maximum automatic retries allowed for a user task. For more information, check TASKAUTORETRY_ATTEMPTS docs.
    traceLevel String
    Controls how trace events are ingested into the event table. Valid values are (case-insensitive): ALWAYS | ON_EVENT | PROPAGATE | OFF. For more information, check TRACE_LEVEL docs.
    userTaskManagedInitialWarehouseSize String
    The initial size of warehouse to use for managed warehouses in the absence of history. Valid values are (case-insensitive): XSMALL | SMALL | MEDIUM | LARGE | XLARGE | XXLARGE | XXXLARGE | X4LARGE | X5LARGE | X6LARGE. For more information, check USERTASKMANAGEDINITIALWAREHOUSE_SIZE docs.
    userTaskMinimumTriggerIntervalInSeconds Integer
    Minimum amount of time between Triggered Task executions in seconds. For more information, check USERTASKMINIMUMTRIGGERINTERVALINSECONDS docs.
    userTaskTimeoutMs Integer
    User task execution timeout in milliseconds. For more information, check USERTASKTIMEOUT_MS docs.
    withManagedAccess String
    (Default: fallback to Snowflake default - uses special value that cannot be set in the configuration manually (default)) Specifies a managed schema. Managed access schemas centralize privilege management with the schema owner. 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.
    catalog string
    The parameter that specifies the default catalog to use for Iceberg tables. For more information, check CATALOG docs.
    comment string
    Specifies a comment for the schema.
    dataRetentionTimeInDays number
    Specifies the number of days for which Time Travel actions (CLONE and UNDROP) can be performed on the database, as well as specifying the default Time Travel retention time for all schemas created in the database. For more details, see Understanding & Using Time Travel. For more information, check DATARETENTIONTIMEINDAYS docs.
    database string
    The database in which to create the schema. Due to technical limitations (read more here), avoid using the following characters: |, ., ".
    defaultDdlCollation string
    Specifies a default collation specification for all schemas and tables added to the database. It can be overridden on schema or table level. For more information, see collation specification. For more information, check DEFAULTDDLCOLLATION docs.
    defaultNotebookComputePoolCpu string
    Sets the preferred CPU compute pool used for Notebooks on CPU Container Runtime. For more information, check DEFAULTNOTEBOOKCOMPUTEPOOLCPU docs.
    defaultNotebookComputePoolGpu string
    Sets the preferred GPU compute pool used for Notebooks on GPU Container Runtime. For more information, check DEFAULTNOTEBOOKCOMPUTEPOOLGPU docs.
    describeOutputs SchemaDescribeOutput[]
    Outputs the result of DESCRIBE SCHEMA for the given schema. In order to handle this output, one must grant sufficient privileges, e.g. grantOwnership on all objects in the schema.
    enableConsoleOutput boolean
    If true, enables stdout/stderr fast path logging for anonymous stored procedures. For more information, check ENABLECONSOLEOUTPUT docs.
    externalVolume string
    The parameter that specifies the default external volume to use for Iceberg tables. For more information, check EXTERNAL_VOLUME docs.
    fullyQualifiedName string
    Fully qualified name of the resource. For more information, see object name resolution.
    isTransient string
    (Default: fallback to Snowflake default - uses special value that cannot be set in the configuration manually (default)) Specifies the schema as transient. Transient schemas do not have a Fail-safe period so they do not incur additional storage costs once they leave Time Travel; however, this means they are also not protected by Fail-safe in the event of a data loss. 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.
    logEventLevel string
    Specifies the severity level of log events (rows with record type EVENT) that should be ingested and made available in the active event table. Log events at the specified level (and at more severe levels) are ingested. Valid values are (case-insensitive): TRACE | DEBUG | INFO | WARN | ERROR | FATAL | OFF. For more information, check LOGEVENTLEVEL docs.
    logLevel string
    Specifies the severity level of messages that should be ingested and made available in the active event table. Messages at the specified level (and at more severe levels) are ingested. Valid values are (case-insensitive): TRACE | DEBUG | INFO | WARN | ERROR | FATAL | OFF. For more information, check LOG_LEVEL docs.
    maxDataExtensionTimeInDays number
    Object parameter that specifies the maximum number of days for which Snowflake can extend the data retention period for tables in the database to prevent streams on the tables from becoming stale. For more information, check MAXDATAEXTENSIONTIMEIN_DAYS docs.
    name string
    Specifies the identifier for the schema; must be unique for the database in which the schema is created. When the name is PUBLIC, during creation the provider checks if this schema has already been created and, in such case, ALTER is used to match the desired state. Due to technical limitations (read more here), avoid using the following characters: |, ., ".
    parameters SchemaParameter[]
    Outputs the result of SHOW PARAMETERS IN SCHEMA for the given schema.
    pipeExecutionPaused boolean
    Specifies whether to pause a running pipe, primarily in preparation for transferring ownership of the pipe to a different role. For more information, check PIPEEXECUTIONPAUSED docs.
    quotedIdentifiersIgnoreCase boolean
    If true, the case of quoted identifiers is ignored. For more information, check QUOTEDIDENTIFIERSIGNORE_CASE docs.
    replaceInvalidCharacters boolean
    Specifies whether to replace invalid UTF-8 characters with the Unicode replacement character in query results for an Iceberg table. You can only set this parameter for tables that use an external Iceberg catalog. For more information, check REPLACEINVALIDCHARACTERS docs.
    showOutputs SchemaShowOutput[]
    Outputs the result of SHOW SCHEMAS for the given schema.
    storageSerializationPolicy string
    The storage serialization policy for Iceberg tables that use Snowflake as the catalog. COMPATIBLE: Snowflake performs encoding and compression of data files that ensures interoperability with third-party compute engines. OPTIMIZED: Snowflake performs encoding and compression of data files that ensures the best table performance within Snowflake. Valid values are (case-insensitive): COMPATIBLE | OPTIMIZED. For more information, check STORAGESERIALIZATIONPOLICY docs.
    suspendTaskAfterNumFailures number
    How many times a task must fail in a row before it is automatically suspended. 0 disables auto-suspending. For more information, check SUSPENDTASKAFTERNUMFAILURES docs.
    taskAutoRetryAttempts number
    Maximum automatic retries allowed for a user task. For more information, check TASKAUTORETRY_ATTEMPTS docs.
    traceLevel string
    Controls how trace events are ingested into the event table. Valid values are (case-insensitive): ALWAYS | ON_EVENT | PROPAGATE | OFF. For more information, check TRACE_LEVEL docs.
    userTaskManagedInitialWarehouseSize string
    The initial size of warehouse to use for managed warehouses in the absence of history. Valid values are (case-insensitive): XSMALL | SMALL | MEDIUM | LARGE | XLARGE | XXLARGE | XXXLARGE | X4LARGE | X5LARGE | X6LARGE. For more information, check USERTASKMANAGEDINITIALWAREHOUSE_SIZE docs.
    userTaskMinimumTriggerIntervalInSeconds number
    Minimum amount of time between Triggered Task executions in seconds. For more information, check USERTASKMINIMUMTRIGGERINTERVALINSECONDS docs.
    userTaskTimeoutMs number
    User task execution timeout in milliseconds. For more information, check USERTASKTIMEOUT_MS docs.
    withManagedAccess string
    (Default: fallback to Snowflake default - uses special value that cannot be set in the configuration manually (default)) Specifies a managed schema. Managed access schemas centralize privilege management with the schema owner. 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.
    catalog str
    The parameter that specifies the default catalog to use for Iceberg tables. For more information, check CATALOG docs.
    comment str
    Specifies a comment for the schema.
    data_retention_time_in_days int
    Specifies the number of days for which Time Travel actions (CLONE and UNDROP) can be performed on the database, as well as specifying the default Time Travel retention time for all schemas created in the database. For more details, see Understanding & Using Time Travel. For more information, check DATARETENTIONTIMEINDAYS docs.
    database str
    The database in which to create the schema. Due to technical limitations (read more here), avoid using the following characters: |, ., ".
    default_ddl_collation str
    Specifies a default collation specification for all schemas and tables added to the database. It can be overridden on schema or table level. For more information, see collation specification. For more information, check DEFAULTDDLCOLLATION docs.
    default_notebook_compute_pool_cpu str
    Sets the preferred CPU compute pool used for Notebooks on CPU Container Runtime. For more information, check DEFAULTNOTEBOOKCOMPUTEPOOLCPU docs.
    default_notebook_compute_pool_gpu str
    Sets the preferred GPU compute pool used for Notebooks on GPU Container Runtime. For more information, check DEFAULTNOTEBOOKCOMPUTEPOOLGPU docs.
    describe_outputs Sequence[SchemaDescribeOutputArgs]
    Outputs the result of DESCRIBE SCHEMA for the given schema. In order to handle this output, one must grant sufficient privileges, e.g. grantOwnership on all objects in the schema.
    enable_console_output bool
    If true, enables stdout/stderr fast path logging for anonymous stored procedures. For more information, check ENABLECONSOLEOUTPUT docs.
    external_volume str
    The parameter that specifies the default external volume to use for Iceberg tables. For more information, check EXTERNAL_VOLUME docs.
    fully_qualified_name str
    Fully qualified name of the resource. For more information, see object name resolution.
    is_transient str
    (Default: fallback to Snowflake default - uses special value that cannot be set in the configuration manually (default)) Specifies the schema as transient. Transient schemas do not have a Fail-safe period so they do not incur additional storage costs once they leave Time Travel; however, this means they are also not protected by Fail-safe in the event of a data loss. 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.
    log_event_level str
    Specifies the severity level of log events (rows with record type EVENT) that should be ingested and made available in the active event table. Log events at the specified level (and at more severe levels) are ingested. Valid values are (case-insensitive): TRACE | DEBUG | INFO | WARN | ERROR | FATAL | OFF. For more information, check LOGEVENTLEVEL docs.
    log_level str
    Specifies the severity level of messages that should be ingested and made available in the active event table. Messages at the specified level (and at more severe levels) are ingested. Valid values are (case-insensitive): TRACE | DEBUG | INFO | WARN | ERROR | FATAL | OFF. For more information, check LOG_LEVEL docs.
    max_data_extension_time_in_days int
    Object parameter that specifies the maximum number of days for which Snowflake can extend the data retention period for tables in the database to prevent streams on the tables from becoming stale. For more information, check MAXDATAEXTENSIONTIMEIN_DAYS docs.
    name str
    Specifies the identifier for the schema; must be unique for the database in which the schema is created. When the name is PUBLIC, during creation the provider checks if this schema has already been created and, in such case, ALTER is used to match the desired state. Due to technical limitations (read more here), avoid using the following characters: |, ., ".
    parameters Sequence[SchemaParameterArgs]
    Outputs the result of SHOW PARAMETERS IN SCHEMA for the given schema.
    pipe_execution_paused bool
    Specifies whether to pause a running pipe, primarily in preparation for transferring ownership of the pipe to a different role. For more information, check PIPEEXECUTIONPAUSED docs.
    quoted_identifiers_ignore_case bool
    If true, the case of quoted identifiers is ignored. For more information, check QUOTEDIDENTIFIERSIGNORE_CASE docs.
    replace_invalid_characters bool
    Specifies whether to replace invalid UTF-8 characters with the Unicode replacement character in query results for an Iceberg table. You can only set this parameter for tables that use an external Iceberg catalog. For more information, check REPLACEINVALIDCHARACTERS docs.
    show_outputs Sequence[SchemaShowOutputArgs]
    Outputs the result of SHOW SCHEMAS for the given schema.
    storage_serialization_policy str
    The storage serialization policy for Iceberg tables that use Snowflake as the catalog. COMPATIBLE: Snowflake performs encoding and compression of data files that ensures interoperability with third-party compute engines. OPTIMIZED: Snowflake performs encoding and compression of data files that ensures the best table performance within Snowflake. Valid values are (case-insensitive): COMPATIBLE | OPTIMIZED. For more information, check STORAGESERIALIZATIONPOLICY docs.
    suspend_task_after_num_failures int
    How many times a task must fail in a row before it is automatically suspended. 0 disables auto-suspending. For more information, check SUSPENDTASKAFTERNUMFAILURES docs.
    task_auto_retry_attempts int
    Maximum automatic retries allowed for a user task. For more information, check TASKAUTORETRY_ATTEMPTS docs.
    trace_level str
    Controls how trace events are ingested into the event table. Valid values are (case-insensitive): ALWAYS | ON_EVENT | PROPAGATE | OFF. For more information, check TRACE_LEVEL docs.
    user_task_managed_initial_warehouse_size str
    The initial size of warehouse to use for managed warehouses in the absence of history. Valid values are (case-insensitive): XSMALL | SMALL | MEDIUM | LARGE | XLARGE | XXLARGE | XXXLARGE | X4LARGE | X5LARGE | X6LARGE. For more information, check USERTASKMANAGEDINITIALWAREHOUSE_SIZE docs.
    user_task_minimum_trigger_interval_in_seconds int
    Minimum amount of time between Triggered Task executions in seconds. For more information, check USERTASKMINIMUMTRIGGERINTERVALINSECONDS docs.
    user_task_timeout_ms int
    User task execution timeout in milliseconds. For more information, check USERTASKTIMEOUT_MS docs.
    with_managed_access str
    (Default: fallback to Snowflake default - uses special value that cannot be set in the configuration manually (default)) Specifies a managed schema. Managed access schemas centralize privilege management with the schema owner. 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.
    catalog String
    The parameter that specifies the default catalog to use for Iceberg tables. For more information, check CATALOG docs.
    comment String
    Specifies a comment for the schema.
    dataRetentionTimeInDays Number
    Specifies the number of days for which Time Travel actions (CLONE and UNDROP) can be performed on the database, as well as specifying the default Time Travel retention time for all schemas created in the database. For more details, see Understanding & Using Time Travel. For more information, check DATARETENTIONTIMEINDAYS docs.
    database String
    The database in which to create the schema. Due to technical limitations (read more here), avoid using the following characters: |, ., ".
    defaultDdlCollation String
    Specifies a default collation specification for all schemas and tables added to the database. It can be overridden on schema or table level. For more information, see collation specification. For more information, check DEFAULTDDLCOLLATION docs.
    defaultNotebookComputePoolCpu String
    Sets the preferred CPU compute pool used for Notebooks on CPU Container Runtime. For more information, check DEFAULTNOTEBOOKCOMPUTEPOOLCPU docs.
    defaultNotebookComputePoolGpu String
    Sets the preferred GPU compute pool used for Notebooks on GPU Container Runtime. For more information, check DEFAULTNOTEBOOKCOMPUTEPOOLGPU docs.
    describeOutputs List<Property Map>
    Outputs the result of DESCRIBE SCHEMA for the given schema. In order to handle this output, one must grant sufficient privileges, e.g. grantOwnership on all objects in the schema.
    enableConsoleOutput Boolean
    If true, enables stdout/stderr fast path logging for anonymous stored procedures. For more information, check ENABLECONSOLEOUTPUT docs.
    externalVolume String
    The parameter that specifies the default external volume to use for Iceberg tables. For more information, check EXTERNAL_VOLUME docs.
    fullyQualifiedName String
    Fully qualified name of the resource. For more information, see object name resolution.
    isTransient String
    (Default: fallback to Snowflake default - uses special value that cannot be set in the configuration manually (default)) Specifies the schema as transient. Transient schemas do not have a Fail-safe period so they do not incur additional storage costs once they leave Time Travel; however, this means they are also not protected by Fail-safe in the event of a data loss. 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.
    logEventLevel String
    Specifies the severity level of log events (rows with record type EVENT) that should be ingested and made available in the active event table. Log events at the specified level (and at more severe levels) are ingested. Valid values are (case-insensitive): TRACE | DEBUG | INFO | WARN | ERROR | FATAL | OFF. For more information, check LOGEVENTLEVEL docs.
    logLevel String
    Specifies the severity level of messages that should be ingested and made available in the active event table. Messages at the specified level (and at more severe levels) are ingested. Valid values are (case-insensitive): TRACE | DEBUG | INFO | WARN | ERROR | FATAL | OFF. For more information, check LOG_LEVEL docs.
    maxDataExtensionTimeInDays Number
    Object parameter that specifies the maximum number of days for which Snowflake can extend the data retention period for tables in the database to prevent streams on the tables from becoming stale. For more information, check MAXDATAEXTENSIONTIMEIN_DAYS docs.
    name String
    Specifies the identifier for the schema; must be unique for the database in which the schema is created. When the name is PUBLIC, during creation the provider checks if this schema has already been created and, in such case, ALTER is used to match the desired state. Due to technical limitations (read more here), avoid using the following characters: |, ., ".
    parameters List<Property Map>
    Outputs the result of SHOW PARAMETERS IN SCHEMA for the given schema.
    pipeExecutionPaused Boolean
    Specifies whether to pause a running pipe, primarily in preparation for transferring ownership of the pipe to a different role. For more information, check PIPEEXECUTIONPAUSED docs.
    quotedIdentifiersIgnoreCase Boolean
    If true, the case of quoted identifiers is ignored. For more information, check QUOTEDIDENTIFIERSIGNORE_CASE docs.
    replaceInvalidCharacters Boolean
    Specifies whether to replace invalid UTF-8 characters with the Unicode replacement character in query results for an Iceberg table. You can only set this parameter for tables that use an external Iceberg catalog. For more information, check REPLACEINVALIDCHARACTERS docs.
    showOutputs List<Property Map>
    Outputs the result of SHOW SCHEMAS for the given schema.
    storageSerializationPolicy String
    The storage serialization policy for Iceberg tables that use Snowflake as the catalog. COMPATIBLE: Snowflake performs encoding and compression of data files that ensures interoperability with third-party compute engines. OPTIMIZED: Snowflake performs encoding and compression of data files that ensures the best table performance within Snowflake. Valid values are (case-insensitive): COMPATIBLE | OPTIMIZED. For more information, check STORAGESERIALIZATIONPOLICY docs.
    suspendTaskAfterNumFailures Number
    How many times a task must fail in a row before it is automatically suspended. 0 disables auto-suspending. For more information, check SUSPENDTASKAFTERNUMFAILURES docs.
    taskAutoRetryAttempts Number
    Maximum automatic retries allowed for a user task. For more information, check TASKAUTORETRY_ATTEMPTS docs.
    traceLevel String
    Controls how trace events are ingested into the event table. Valid values are (case-insensitive): ALWAYS | ON_EVENT | PROPAGATE | OFF. For more information, check TRACE_LEVEL docs.
    userTaskManagedInitialWarehouseSize String
    The initial size of warehouse to use for managed warehouses in the absence of history. Valid values are (case-insensitive): XSMALL | SMALL | MEDIUM | LARGE | XLARGE | XXLARGE | XXXLARGE | X4LARGE | X5LARGE | X6LARGE. For more information, check USERTASKMANAGEDINITIALWAREHOUSE_SIZE docs.
    userTaskMinimumTriggerIntervalInSeconds Number
    Minimum amount of time between Triggered Task executions in seconds. For more information, check USERTASKMINIMUMTRIGGERINTERVALINSECONDS docs.
    userTaskTimeoutMs Number
    User task execution timeout in milliseconds. For more information, check USERTASKTIMEOUT_MS docs.
    withManagedAccess String
    (Default: fallback to Snowflake default - uses special value that cannot be set in the configuration manually (default)) Specifies a managed schema. Managed access schemas centralize privilege management with the schema owner. 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.

    Supporting Types

    SchemaDescribeOutput, SchemaDescribeOutputArgs

    CreatedOn string
    Kind string
    Name string
    CreatedOn string
    Kind string
    Name string
    created_on string
    kind string
    name string
    createdOn String
    kind String
    name String
    createdOn string
    kind string
    name string
    created_on str
    kind str
    name str
    createdOn String
    kind String
    name String

    SchemaParameter, SchemaParameterArgs

    Catalogs List<SchemaParameterCatalog>
    DataRetentionTimeInDays List<SchemaParameterDataRetentionTimeInDay>
    DefaultDdlCollations List<SchemaParameterDefaultDdlCollation>
    DefaultNotebookComputePoolCpus List<SchemaParameterDefaultNotebookComputePoolCpus>
    DefaultNotebookComputePoolGpus List<SchemaParameterDefaultNotebookComputePoolGpus>
    EnableConsoleOutputs List<SchemaParameterEnableConsoleOutput>
    ExternalVolumes List<SchemaParameterExternalVolume>
    LogEventLevels List<SchemaParameterLogEventLevel>
    LogLevels List<SchemaParameterLogLevel>
    MaxDataExtensionTimeInDays List<SchemaParameterMaxDataExtensionTimeInDay>
    PipeExecutionPauseds List<SchemaParameterPipeExecutionPaused>
    QuotedIdentifiersIgnoreCases List<SchemaParameterQuotedIdentifiersIgnoreCase>
    ReplaceInvalidCharacters List<SchemaParameterReplaceInvalidCharacter>
    StorageSerializationPolicies List<SchemaParameterStorageSerializationPolicy>
    SuspendTaskAfterNumFailures List<SchemaParameterSuspendTaskAfterNumFailure>
    TaskAutoRetryAttempts List<SchemaParameterTaskAutoRetryAttempt>
    TraceLevels List<SchemaParameterTraceLevel>
    UserTaskManagedInitialWarehouseSizes List<SchemaParameterUserTaskManagedInitialWarehouseSize>
    UserTaskMinimumTriggerIntervalInSeconds List<SchemaParameterUserTaskMinimumTriggerIntervalInSecond>
    UserTaskTimeoutMs List<SchemaParameterUserTaskTimeoutM>
    Catalogs []SchemaParameterCatalog
    DataRetentionTimeInDays []SchemaParameterDataRetentionTimeInDay
    DefaultDdlCollations []SchemaParameterDefaultDdlCollation
    DefaultNotebookComputePoolCpus []SchemaParameterDefaultNotebookComputePoolCpus
    DefaultNotebookComputePoolGpus []SchemaParameterDefaultNotebookComputePoolGpus
    EnableConsoleOutputs []SchemaParameterEnableConsoleOutput
    ExternalVolumes []SchemaParameterExternalVolume
    LogEventLevels []SchemaParameterLogEventLevel
    LogLevels []SchemaParameterLogLevel
    MaxDataExtensionTimeInDays []SchemaParameterMaxDataExtensionTimeInDay
    PipeExecutionPauseds []SchemaParameterPipeExecutionPaused
    QuotedIdentifiersIgnoreCases []SchemaParameterQuotedIdentifiersIgnoreCase
    ReplaceInvalidCharacters []SchemaParameterReplaceInvalidCharacter
    StorageSerializationPolicies []SchemaParameterStorageSerializationPolicy
    SuspendTaskAfterNumFailures []SchemaParameterSuspendTaskAfterNumFailure
    TaskAutoRetryAttempts []SchemaParameterTaskAutoRetryAttempt
    TraceLevels []SchemaParameterTraceLevel
    UserTaskManagedInitialWarehouseSizes []SchemaParameterUserTaskManagedInitialWarehouseSize
    UserTaskMinimumTriggerIntervalInSeconds []SchemaParameterUserTaskMinimumTriggerIntervalInSecond
    UserTaskTimeoutMs []SchemaParameterUserTaskTimeoutM
    catalogs List<SchemaParameterCatalog>
    dataRetentionTimeInDays List<SchemaParameterDataRetentionTimeInDay>
    defaultDdlCollations List<SchemaParameterDefaultDdlCollation>
    defaultNotebookComputePoolCpus List<SchemaParameterDefaultNotebookComputePoolCpus>
    defaultNotebookComputePoolGpus List<SchemaParameterDefaultNotebookComputePoolGpus>
    enableConsoleOutputs List<SchemaParameterEnableConsoleOutput>
    externalVolumes List<SchemaParameterExternalVolume>
    logEventLevels List<SchemaParameterLogEventLevel>
    logLevels List<SchemaParameterLogLevel>
    maxDataExtensionTimeInDays List<SchemaParameterMaxDataExtensionTimeInDay>
    pipeExecutionPauseds List<SchemaParameterPipeExecutionPaused>
    quotedIdentifiersIgnoreCases List<SchemaParameterQuotedIdentifiersIgnoreCase>
    replaceInvalidCharacters List<SchemaParameterReplaceInvalidCharacter>
    storageSerializationPolicies List<SchemaParameterStorageSerializationPolicy>
    suspendTaskAfterNumFailures List<SchemaParameterSuspendTaskAfterNumFailure>
    taskAutoRetryAttempts List<SchemaParameterTaskAutoRetryAttempt>
    traceLevels List<SchemaParameterTraceLevel>
    userTaskManagedInitialWarehouseSizes List<SchemaParameterUserTaskManagedInitialWarehouseSize>
    userTaskMinimumTriggerIntervalInSeconds List<SchemaParameterUserTaskMinimumTriggerIntervalInSecond>
    userTaskTimeoutMs List<SchemaParameterUserTaskTimeoutM>
    catalogs SchemaParameterCatalog[]
    dataRetentionTimeInDays SchemaParameterDataRetentionTimeInDay[]
    defaultDdlCollations SchemaParameterDefaultDdlCollation[]
    defaultNotebookComputePoolCpus SchemaParameterDefaultNotebookComputePoolCpus[]
    defaultNotebookComputePoolGpus SchemaParameterDefaultNotebookComputePoolGpus[]
    enableConsoleOutputs SchemaParameterEnableConsoleOutput[]
    externalVolumes SchemaParameterExternalVolume[]
    logEventLevels SchemaParameterLogEventLevel[]
    logLevels SchemaParameterLogLevel[]
    maxDataExtensionTimeInDays SchemaParameterMaxDataExtensionTimeInDay[]
    pipeExecutionPauseds SchemaParameterPipeExecutionPaused[]
    quotedIdentifiersIgnoreCases SchemaParameterQuotedIdentifiersIgnoreCase[]
    replaceInvalidCharacters SchemaParameterReplaceInvalidCharacter[]
    storageSerializationPolicies SchemaParameterStorageSerializationPolicy[]
    suspendTaskAfterNumFailures SchemaParameterSuspendTaskAfterNumFailure[]
    taskAutoRetryAttempts SchemaParameterTaskAutoRetryAttempt[]
    traceLevels SchemaParameterTraceLevel[]
    userTaskManagedInitialWarehouseSizes SchemaParameterUserTaskManagedInitialWarehouseSize[]
    userTaskMinimumTriggerIntervalInSeconds SchemaParameterUserTaskMinimumTriggerIntervalInSecond[]
    userTaskTimeoutMs SchemaParameterUserTaskTimeoutM[]
    catalogs Sequence[SchemaParameterCatalog]
    data_retention_time_in_days Sequence[SchemaParameterDataRetentionTimeInDay]
    default_ddl_collations Sequence[SchemaParameterDefaultDdlCollation]
    default_notebook_compute_pool_cpus Sequence[SchemaParameterDefaultNotebookComputePoolCpus]
    default_notebook_compute_pool_gpus Sequence[SchemaParameterDefaultNotebookComputePoolGpus]
    enable_console_outputs Sequence[SchemaParameterEnableConsoleOutput]
    external_volumes Sequence[SchemaParameterExternalVolume]
    log_event_levels Sequence[SchemaParameterLogEventLevel]
    log_levels Sequence[SchemaParameterLogLevel]
    max_data_extension_time_in_days Sequence[SchemaParameterMaxDataExtensionTimeInDay]
    pipe_execution_pauseds Sequence[SchemaParameterPipeExecutionPaused]
    quoted_identifiers_ignore_cases Sequence[SchemaParameterQuotedIdentifiersIgnoreCase]
    replace_invalid_characters Sequence[SchemaParameterReplaceInvalidCharacter]
    storage_serialization_policies Sequence[SchemaParameterStorageSerializationPolicy]
    suspend_task_after_num_failures Sequence[SchemaParameterSuspendTaskAfterNumFailure]
    task_auto_retry_attempts Sequence[SchemaParameterTaskAutoRetryAttempt]
    trace_levels Sequence[SchemaParameterTraceLevel]
    user_task_managed_initial_warehouse_sizes Sequence[SchemaParameterUserTaskManagedInitialWarehouseSize]
    user_task_minimum_trigger_interval_in_seconds Sequence[SchemaParameterUserTaskMinimumTriggerIntervalInSecond]
    user_task_timeout_ms Sequence[SchemaParameterUserTaskTimeoutM]
    catalogs List<Property Map>
    dataRetentionTimeInDays List<Property Map>
    defaultDdlCollations List<Property Map>
    defaultNotebookComputePoolCpus List<Property Map>
    defaultNotebookComputePoolGpus List<Property Map>
    enableConsoleOutputs List<Property Map>
    externalVolumes List<Property Map>
    logEventLevels List<Property Map>
    logLevels List<Property Map>
    maxDataExtensionTimeInDays List<Property Map>
    pipeExecutionPauseds List<Property Map>
    quotedIdentifiersIgnoreCases List<Property Map>
    replaceInvalidCharacters List<Property Map>
    storageSerializationPolicies List<Property Map>
    suspendTaskAfterNumFailures List<Property Map>
    taskAutoRetryAttempts List<Property Map>
    traceLevels List<Property Map>
    userTaskManagedInitialWarehouseSizes List<Property Map>
    userTaskMinimumTriggerIntervalInSeconds List<Property Map>
    userTaskTimeoutMs List<Property Map>

    SchemaParameterCatalog, SchemaParameterCatalogArgs

    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

    SchemaParameterDataRetentionTimeInDay, SchemaParameterDataRetentionTimeInDayArgs

    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

    SchemaParameterDefaultDdlCollation, SchemaParameterDefaultDdlCollationArgs

    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

    SchemaParameterDefaultNotebookComputePoolCpus, SchemaParameterDefaultNotebookComputePoolCpusArgs

    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

    SchemaParameterDefaultNotebookComputePoolGpus, SchemaParameterDefaultNotebookComputePoolGpusArgs

    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

    SchemaParameterEnableConsoleOutput, SchemaParameterEnableConsoleOutputArgs

    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

    SchemaParameterExternalVolume, SchemaParameterExternalVolumeArgs

    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

    SchemaParameterLogEventLevel, SchemaParameterLogEventLevelArgs

    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

    SchemaParameterLogLevel, SchemaParameterLogLevelArgs

    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

    SchemaParameterMaxDataExtensionTimeInDay, SchemaParameterMaxDataExtensionTimeInDayArgs

    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

    SchemaParameterPipeExecutionPaused, SchemaParameterPipeExecutionPausedArgs

    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

    SchemaParameterQuotedIdentifiersIgnoreCase, SchemaParameterQuotedIdentifiersIgnoreCaseArgs

    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

    SchemaParameterReplaceInvalidCharacter, SchemaParameterReplaceInvalidCharacterArgs

    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

    SchemaParameterStorageSerializationPolicy, SchemaParameterStorageSerializationPolicyArgs

    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

    SchemaParameterSuspendTaskAfterNumFailure, SchemaParameterSuspendTaskAfterNumFailureArgs

    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

    SchemaParameterTaskAutoRetryAttempt, SchemaParameterTaskAutoRetryAttemptArgs

    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

    SchemaParameterTraceLevel, SchemaParameterTraceLevelArgs

    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

    SchemaParameterUserTaskManagedInitialWarehouseSize, SchemaParameterUserTaskManagedInitialWarehouseSizeArgs

    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

    SchemaParameterUserTaskMinimumTriggerIntervalInSecond, SchemaParameterUserTaskMinimumTriggerIntervalInSecondArgs

    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

    SchemaParameterUserTaskTimeoutM, SchemaParameterUserTaskTimeoutMArgs

    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

    SchemaShowOutput, SchemaShowOutputArgs

    Comment string
    CreatedOn string
    DatabaseName string
    DroppedOn string
    IsCurrent bool
    IsDefault bool
    Name string
    Options string
    Owner string
    OwnerRoleType string
    RetentionTime string
    Comment string
    CreatedOn string
    DatabaseName string
    DroppedOn string
    IsCurrent bool
    IsDefault bool
    Name string
    Options string
    Owner string
    OwnerRoleType string
    RetentionTime string
    comment string
    created_on string
    database_name string
    dropped_on string
    is_current bool
    is_default bool
    name string
    options string
    owner string
    owner_role_type string
    retention_time string
    comment String
    createdOn String
    databaseName String
    droppedOn String
    isCurrent Boolean
    isDefault Boolean
    name String
    options String
    owner String
    ownerRoleType String
    retentionTime String
    comment string
    createdOn string
    databaseName string
    droppedOn string
    isCurrent boolean
    isDefault boolean
    name string
    options string
    owner string
    ownerRoleType string
    retentionTime string
    comment String
    createdOn String
    databaseName String
    droppedOn String
    isCurrent Boolean
    isDefault Boolean
    name String
    options String
    owner String
    ownerRoleType String
    retentionTime String

    Import

    Make sure that isTransient and withManagedAccess are set in your config explicitly before import to avoid diff and recreation (reasons are presented in this migration guide entry).

    $ pulumi import snowflake:index/schema:Schema example '"<database_name>"."<schema_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.23.0
    published on Friday, Nov 6, 2026 by Pulumi

      Try Pulumi Cloud free.
      Your team will thank you.

      Start free trial