Sign in Dashboard Get started
  1. Registry
  2. Packages
  3. Snowflake Provider
  4. API Docs
  5. Database
Viewing docs for Snowflake v2.23.0
published on Friday, Nov 6, 2026 by Pulumi
Schema (JSON)
pulumi/pulumi-snowflake

snowflake.Database

snowflake logo
Viewing docs for Snowflake v2.23.0
published on Friday, Nov 6, 2026 by Pulumi
Schema (JSON)
pulumi/pulumi-snowflake

    Note The provider does not detect external changes on database type. In this case, remove the database of wrong type manually with terraform destroy and recreate the resource. It will be addressed in the future.

    Note A database cannot be dropped successfully if it contains network rule-network policy associations. The error looks like 098507 (2BP01): Cannot drop database DATABASE 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.

    Represents a standard database. If replication configuration is specified, the database is promoted to serve as a primary database for replication.

    Create Database Resource

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

    Constructor syntax

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

@overload
def Database(resource_name: str,
             opts: Optional[ResourceOptions] = None,
             catalog: Optional[str] = None,
             comment: Optional[str] = None,
             data_retention_time_in_days: Optional[int] = None,
             default_ddl_collation: Optional[str] = None,
             default_notebook_compute_pool_cpu: Optional[str] = None,
             default_notebook_compute_pool_gpu: Optional[str] = None,
             drop_public_schema_on_creation: Optional[bool] = None,
             enable_console_output: Optional[bool] = None,
             external_volume: Optional[str] = None,
             is_transient: Optional[bool] = 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,
             quoted_identifiers_ignore_case: Optional[bool] = None,
             replace_invalid_characters: Optional[bool] = None,
             replication: Optional[DatabaseReplicationArgs] = 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)
    func NewDatabase(ctx *Context, name string, args *DatabaseArgs, opts ...ResourceOption) (*Database, error)
    public Database(string name, DatabaseArgs? args = null, CustomResourceOptions? opts = null)
    public Database(String name, DatabaseArgs args)
public Database(String name, DatabaseArgs args, CustomResourceOptions options)

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


    resource "snowflake_database" "name" {
    # resource properties
}

    Parameters

    name string
    The unique name of the resource.
    args DatabaseArgs
    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 DatabaseArgs
    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 DatabaseArgs
    The arguments to resource properties.
    opts ResourceOption
    Bag of options to control resource's behavior.
    name string
    The unique name of the resource.
    args DatabaseArgs
    The arguments to resource properties.
    opts CustomResourceOptions
    Bag of options to control resource's behavior.
    name String
    The unique name of the resource.
    args DatabaseArgs
    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 databaseResource = new Snowflake.Database("databaseResource", new()
{
    Catalog = "string",
    Comment = "string",
    DataRetentionTimeInDays = 0,
    DefaultDdlCollation = "string",
    DefaultNotebookComputePoolCpu = "string",
    DefaultNotebookComputePoolGpu = "string",
    DropPublicSchemaOnCreation = false,
    EnableConsoleOutput = false,
    ExternalVolume = "string",
    IsTransient = false,
    LogEventLevel = "string",
    LogLevel = "string",
    MaxDataExtensionTimeInDays = 0,
    Name = "string",
    QuotedIdentifiersIgnoreCase = false,
    ReplaceInvalidCharacters = false,
    Replication = new Snowflake.Inputs.DatabaseReplicationArgs
    {
        EnableToAccounts = new[]
        {
            new Snowflake.Inputs.DatabaseReplicationEnableToAccountArgs
            {
                AccountIdentifier = "string",
                WithFailover = false,
            },
        },
        IgnoreEditionCheck = false,
    },
    StorageSerializationPolicy = "string",
    SuspendTaskAfterNumFailures = 0,
    TaskAutoRetryAttempts = 0,
    TraceLevel = "string",
    UserTaskManagedInitialWarehouseSize = "string",
    UserTaskMinimumTriggerIntervalInSeconds = 0,
    UserTaskTimeoutMs = 0,
});

    example, err := snowflake.NewDatabase(ctx, "databaseResource", &snowflake.DatabaseArgs{
	Catalog:                       pulumi.String("string"),
	Comment:                       pulumi.String("string"),
	DataRetentionTimeInDays:       pulumi.Int(0),
	DefaultDdlCollation:           pulumi.String("string"),
	DefaultNotebookComputePoolCpu: pulumi.String("string"),
	DefaultNotebookComputePoolGpu: pulumi.String("string"),
	DropPublicSchemaOnCreation:    pulumi.Bool(false),
	EnableConsoleOutput:           pulumi.Bool(false),
	ExternalVolume:                pulumi.String("string"),
	IsTransient:                   pulumi.Bool(false),
	LogEventLevel:                 pulumi.String("string"),
	LogLevel:                      pulumi.String("string"),
	MaxDataExtensionTimeInDays:    pulumi.Int(0),
	Name:                          pulumi.String("string"),
	QuotedIdentifiersIgnoreCase:   pulumi.Bool(false),
	ReplaceInvalidCharacters:      pulumi.Bool(false),
	Replication: &snowflake.DatabaseReplicationArgs{
		EnableToAccounts: snowflake.DatabaseReplicationEnableToAccountArray{
			&snowflake.DatabaseReplicationEnableToAccountArgs{
				AccountIdentifier: pulumi.String("string"),
				WithFailover:      pulumi.Bool(false),
			},
		},
		IgnoreEditionCheck: pulumi.Bool(false),
	},
	StorageSerializationPolicy:              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),
})

    resource "snowflake_database" "databaseResource" {
  lifecycle {
    create_before_destroy = true
  }
  catalog                           = "string"
  comment                           = "string"
  data_retention_time_in_days       = 0
  default_ddl_collation             = "string"
  default_notebook_compute_pool_cpu = "string"
  default_notebook_compute_pool_gpu = "string"
  drop_public_schema_on_creation    = false
  enable_console_output             = false
  external_volume                   = "string"
  is_transient                      = false
  log_event_level                   = "string"
  log_level                         = "string"
  max_data_extension_time_in_days   = 0
  name                              = "string"
  quoted_identifiers_ignore_case    = false
  replace_invalid_characters        = false
  replication = {
    enable_to_accounts = [{
      account_identifier = "string"
      with_failover      = false
    }]
    ignore_edition_check = false
  }
  storage_serialization_policy                  = "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
}

    var databaseResource = new Database("databaseResource", DatabaseArgs.builder()
    .catalog("string")
    .comment("string")
    .dataRetentionTimeInDays(0)
    .defaultDdlCollation("string")
    .defaultNotebookComputePoolCpu("string")
    .defaultNotebookComputePoolGpu("string")
    .dropPublicSchemaOnCreation(false)
    .enableConsoleOutput(false)
    .externalVolume("string")
    .isTransient(false)
    .logEventLevel("string")
    .logLevel("string")
    .maxDataExtensionTimeInDays(0)
    .name("string")
    .quotedIdentifiersIgnoreCase(false)
    .replaceInvalidCharacters(false)
    .replication(DatabaseReplicationArgs.builder()
        .enableToAccounts(DatabaseReplicationEnableToAccountArgs.builder()
            .accountIdentifier("string")
            .withFailover(false)
            .build())
        .ignoreEditionCheck(false)
        .build())
    .storageSerializationPolicy("string")
    .suspendTaskAfterNumFailures(0)
    .taskAutoRetryAttempts(0)
    .traceLevel("string")
    .userTaskManagedInitialWarehouseSize("string")
    .userTaskMinimumTriggerIntervalInSeconds(0)
    .userTaskTimeoutMs(0)
    .build());

    database_resource = snowflake.Database("databaseResource",
    catalog="string",
    comment="string",
    data_retention_time_in_days=0,
    default_ddl_collation="string",
    default_notebook_compute_pool_cpu="string",
    default_notebook_compute_pool_gpu="string",
    drop_public_schema_on_creation=False,
    enable_console_output=False,
    external_volume="string",
    is_transient=False,
    log_event_level="string",
    log_level="string",
    max_data_extension_time_in_days=0,
    name="string",
    quoted_identifiers_ignore_case=False,
    replace_invalid_characters=False,
    replication={
        "enable_to_accounts": [{
            "account_identifier": "string",
            "with_failover": False,
        }],
        "ignore_edition_check": False,
    },
    storage_serialization_policy="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)

    const databaseResource = new snowflake.Database("databaseResource", {
    catalog: "string",
    comment: "string",
    dataRetentionTimeInDays: 0,
    defaultDdlCollation: "string",
    defaultNotebookComputePoolCpu: "string",
    defaultNotebookComputePoolGpu: "string",
    dropPublicSchemaOnCreation: false,
    enableConsoleOutput: false,
    externalVolume: "string",
    isTransient: false,
    logEventLevel: "string",
    logLevel: "string",
    maxDataExtensionTimeInDays: 0,
    name: "string",
    quotedIdentifiersIgnoreCase: false,
    replaceInvalidCharacters: false,
    replication: {
        enableToAccounts: [{
            accountIdentifier: "string",
            withFailover: false,
        }],
        ignoreEditionCheck: false,
    },
    storageSerializationPolicy: "string",
    suspendTaskAfterNumFailures: 0,
    taskAutoRetryAttempts: 0,
    traceLevel: "string",
    userTaskManagedInitialWarehouseSize: "string",
    userTaskMinimumTriggerIntervalInSeconds: 0,
    userTaskTimeoutMs: 0,
});

    type: snowflake:Database
properties:
    catalog: string
    comment: string
    dataRetentionTimeInDays: 0
    defaultDdlCollation: string
    defaultNotebookComputePoolCpu: string
    defaultNotebookComputePoolGpu: string
    dropPublicSchemaOnCreation: false
    enableConsoleOutput: false
    externalVolume: string
    isTransient: false
    logEventLevel: string
    logLevel: string
    maxDataExtensionTimeInDays: 0
    name: string
    quotedIdentifiersIgnoreCase: false
    replaceInvalidCharacters: false
    replication:
        enableToAccounts:
            - accountIdentifier: string
              withFailover: false
        ignoreEditionCheck: false
    storageSerializationPolicy: string
    suspendTaskAfterNumFailures: 0
    taskAutoRetryAttempts: 0
    traceLevel: string
    userTaskManagedInitialWarehouseSize: string
    userTaskMinimumTriggerIntervalInSeconds: 0
    userTaskTimeoutMs: 0

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

    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 database.
    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.
    DropPublicSchemaOnCreation bool
    Specifies whether to drop public schema on creation or not. Modifying the parameter after database is already created won't have any effect.
    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 bool
    Specifies the database as transient. Transient databases 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.
    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 database; must be unique for your account. As a best practice for Database Replication and Failover, it is recommended to give each secondary database the same name as its primary database. This practice supports referencing fully-qualified objects (i.e. '\n\n.\n\n.\n\n') by other objects in the same database, such as querying a fully-qualified table name in a view. If a secondary database has a different name from the primary database, then these object references would break in the secondary database. Due to technical limitations (read more here), avoid using the following characters: |, ., ".
    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.
    Replication DatabaseReplication
    Configures replication for a given database. When specified, this database will be promoted to serve as a primary database for replication. A primary database can be replicated in one or more accounts, allowing users in those accounts to query objects in each secondary (i.e. replica) database.
    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.
    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 database.
    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.
    DropPublicSchemaOnCreation bool
    Specifies whether to drop public schema on creation or not. Modifying the parameter after database is already created won't have any effect.
    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 bool
    Specifies the database as transient. Transient databases 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.
    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 database; must be unique for your account. As a best practice for Database Replication and Failover, it is recommended to give each secondary database the same name as its primary database. This practice supports referencing fully-qualified objects (i.e. '\n\n.\n\n.\n\n') by other objects in the same database, such as querying a fully-qualified table name in a view. If a secondary database has a different name from the primary database, then these object references would break in the secondary database. Due to technical limitations (read more here), avoid using the following characters: |, ., ".
    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.
    Replication DatabaseReplicationArgs
    Configures replication for a given database. When specified, this database will be promoted to serve as a primary database for replication. A primary database can be replicated in one or more accounts, allowing users in those accounts to query objects in each secondary (i.e. replica) database.
    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.
    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 database.
    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.
    drop_public_schema_on_creation bool
    Specifies whether to drop public schema on creation or not. Modifying the parameter after database is already created won't have any effect.
    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 bool
    Specifies the database as transient. Transient databases 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.
    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 database; must be unique for your account. As a best practice for Database Replication and Failover, it is recommended to give each secondary database the same name as its primary database. This practice supports referencing fully-qualified objects (i.e. '\n\n.\n\n.\n\n') by other objects in the same database, such as querying a fully-qualified table name in a view. If a secondary database has a different name from the primary database, then these object references would break in the secondary database. Due to technical limitations (read more here), avoid using the following characters: |, ., ".
    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.
    replication object
    Configures replication for a given database. When specified, this database will be promoted to serve as a primary database for replication. A primary database can be replicated in one or more accounts, allowing users in those accounts to query objects in each secondary (i.e. replica) database.
    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.
    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 database.
    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.
    dropPublicSchemaOnCreation Boolean
    Specifies whether to drop public schema on creation or not. Modifying the parameter after database is already created won't have any effect.
    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 Boolean
    Specifies the database as transient. Transient databases 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.
    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 database; must be unique for your account. As a best practice for Database Replication and Failover, it is recommended to give each secondary database the same name as its primary database. This practice supports referencing fully-qualified objects (i.e. '\n\n.\n\n.\n\n') by other objects in the same database, such as querying a fully-qualified table name in a view. If a secondary database has a different name from the primary database, then these object references would break in the secondary database. Due to technical limitations (read more here), avoid using the following characters: |, ., ".
    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.
    replication DatabaseReplication
    Configures replication for a given database. When specified, this database will be promoted to serve as a primary database for replication. A primary database can be replicated in one or more accounts, allowing users in those accounts to query objects in each secondary (i.e. replica) database.
    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.
    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 database.
    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.
    dropPublicSchemaOnCreation boolean
    Specifies whether to drop public schema on creation or not. Modifying the parameter after database is already created won't have any effect.
    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 boolean
    Specifies the database as transient. Transient databases 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.
    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 database; must be unique for your account. As a best practice for Database Replication and Failover, it is recommended to give each secondary database the same name as its primary database. This practice supports referencing fully-qualified objects (i.e. '\n\n.\n\n.\n\n') by other objects in the same database, such as querying a fully-qualified table name in a view. If a secondary database has a different name from the primary database, then these object references would break in the secondary database. Due to technical limitations (read more here), avoid using the following characters: |, ., ".
    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.
    replication DatabaseReplication
    Configures replication for a given database. When specified, this database will be promoted to serve as a primary database for replication. A primary database can be replicated in one or more accounts, allowing users in those accounts to query objects in each secondary (i.e. replica) database.
    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.
    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 database.
    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.
    drop_public_schema_on_creation bool
    Specifies whether to drop public schema on creation or not. Modifying the parameter after database is already created won't have any effect.
    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 bool
    Specifies the database as transient. Transient databases 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.
    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 database; must be unique for your account. As a best practice for Database Replication and Failover, it is recommended to give each secondary database the same name as its primary database. This practice supports referencing fully-qualified objects (i.e. '\n\n.\n\n.\n\n') by other objects in the same database, such as querying a fully-qualified table name in a view. If a secondary database has a different name from the primary database, then these object references would break in the secondary database. Due to technical limitations (read more here), avoid using the following characters: |, ., ".
    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.
    replication DatabaseReplicationArgs
    Configures replication for a given database. When specified, this database will be promoted to serve as a primary database for replication. A primary database can be replicated in one or more accounts, allowing users in those accounts to query objects in each secondary (i.e. replica) database.
    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.
    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 database.
    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.
    dropPublicSchemaOnCreation Boolean
    Specifies whether to drop public schema on creation or not. Modifying the parameter after database is already created won't have any effect.
    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 Boolean
    Specifies the database as transient. Transient databases 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.
    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 database; must be unique for your account. As a best practice for Database Replication and Failover, it is recommended to give each secondary database the same name as its primary database. This practice supports referencing fully-qualified objects (i.e. '\n\n.\n\n.\n\n') by other objects in the same database, such as querying a fully-qualified table name in a view. If a secondary database has a different name from the primary database, then these object references would break in the secondary database. Due to technical limitations (read more here), avoid using the following characters: |, ., ".
    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.
    replication Property Map
    Configures replication for a given database. When specified, this database will be promoted to serve as a primary database for replication. A primary database can be replicated in one or more accounts, allowing users in those accounts to query objects in each secondary (i.e. replica) database.
    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.

    Outputs

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

    FullyQualifiedName string
    Fully qualified name of the resource. For more information, see object name resolution.
    Id string
    The provider-assigned unique ID for this managed resource.
    Parameters List<DatabaseParameter>
    Outputs the result of SHOW PARAMETERS IN DATABASE for the given object.
    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 []DatabaseParameter
    Outputs the result of SHOW PARAMETERS IN DATABASE for the given object.
    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 DATABASE for the given object.
    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<DatabaseParameter>
    Outputs the result of SHOW PARAMETERS IN DATABASE for the given object.
    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 DatabaseParameter[]
    Outputs the result of SHOW PARAMETERS IN DATABASE for the given object.
    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[DatabaseParameter]
    Outputs the result of SHOW PARAMETERS IN DATABASE for the given object.
    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 DATABASE for the given object.

    Look up Existing Database Resource

    Get an existing Database 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?: DatabaseState, opts?: CustomResourceOptions): Database
    @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,
        default_ddl_collation: Optional[str] = None,
        default_notebook_compute_pool_cpu: Optional[str] = None,
        default_notebook_compute_pool_gpu: Optional[str] = None,
        drop_public_schema_on_creation: Optional[bool] = None,
        enable_console_output: Optional[bool] = None,
        external_volume: Optional[str] = None,
        fully_qualified_name: Optional[str] = None,
        is_transient: Optional[bool] = 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[DatabaseParameterArgs]] = None,
        quoted_identifiers_ignore_case: Optional[bool] = None,
        replace_invalid_characters: Optional[bool] = None,
        replication: Optional[DatabaseReplicationArgs] = 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) -> Database
    func GetDatabase(ctx *Context, name string, id IDInput, state *DatabaseState, opts ...ResourceOption) (*Database, error)
    public static Database Get(string name, Input<string> id, DatabaseState? state, CustomResourceOptions? opts = null)
    public static Database get(String name, Output<String> id, DatabaseState state, CustomResourceOptions options)
    resources:  _:    type: snowflake:Database    get:      id: ${id}
    import {
  to = snowflake_database.example
  id = "${id}"
}
    name
    The unique name of the resulting resource.
    id
    The unique provider ID of the resource to lookup.
    state
    Any extra arguments used during the lookup.
    opts
    A bag of options that control this resource's behavior.
    resource_name
    The unique name of the resulting resource.
    id
    The unique provider ID of the resource to lookup.
    name
    The unique name of the resulting resource.
    id
    The unique provider ID of the resource to lookup.
    state
    Any extra arguments used during the lookup.
    opts
    A bag of options that control this resource's behavior.
    name
    The unique name of the resulting resource.
    id
    The unique provider ID of the resource to lookup.
    state
    Any extra arguments used during the lookup.
    opts
    A bag of options that control this resource's behavior.
    name
    The unique name of the resulting resource.
    id
    The unique provider ID of the resource to lookup.
    state
    Any extra arguments used during the lookup.
    opts
    A bag of options that control this resource's behavior.
    The following state arguments are supported:
    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 database.
    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.
    DropPublicSchemaOnCreation bool
    Specifies whether to drop public schema on creation or not. Modifying the parameter after database is already created won't have any effect.
    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 bool
    Specifies the database as transient. Transient databases 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.
    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 database; must be unique for your account. As a best practice for Database Replication and Failover, it is recommended to give each secondary database the same name as its primary database. This practice supports referencing fully-qualified objects (i.e. '\n\n.\n\n.\n\n') by other objects in the same database, such as querying a fully-qualified table name in a view. If a secondary database has a different name from the primary database, then these object references would break in the secondary database. Due to technical limitations (read more here), avoid using the following characters: |, ., ".
    Parameters List<DatabaseParameter>
    Outputs the result of SHOW PARAMETERS IN DATABASE for the given object.
    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.
    Replication DatabaseReplication
    Configures replication for a given database. When specified, this database will be promoted to serve as a primary database for replication. A primary database can be replicated in one or more accounts, allowing users in those accounts to query objects in each secondary (i.e. replica) database.
    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.
    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 database.
    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.
    DropPublicSchemaOnCreation bool
    Specifies whether to drop public schema on creation or not. Modifying the parameter after database is already created won't have any effect.
    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 bool
    Specifies the database as transient. Transient databases 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.
    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 database; must be unique for your account. As a best practice for Database Replication and Failover, it is recommended to give each secondary database the same name as its primary database. This practice supports referencing fully-qualified objects (i.e. '\n\n.\n\n.\n\n') by other objects in the same database, such as querying a fully-qualified table name in a view. If a secondary database has a different name from the primary database, then these object references would break in the secondary database. Due to technical limitations (read more here), avoid using the following characters: |, ., ".
    Parameters []DatabaseParameterArgs
    Outputs the result of SHOW PARAMETERS IN DATABASE for the given object.
    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.
    Replication DatabaseReplicationArgs
    Configures replication for a given database. When specified, this database will be promoted to serve as a primary database for replication. A primary database can be replicated in one or more accounts, allowing users in those accounts to query objects in each secondary (i.e. replica) database.
    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.
    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 database.
    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.
    drop_public_schema_on_creation bool
    Specifies whether to drop public schema on creation or not. Modifying the parameter after database is already created won't have any effect.
    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 bool
    Specifies the database as transient. Transient databases 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.
    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 database; must be unique for your account. As a best practice for Database Replication and Failover, it is recommended to give each secondary database the same name as its primary database. This practice supports referencing fully-qualified objects (i.e. '\n\n.\n\n.\n\n') by other objects in the same database, such as querying a fully-qualified table name in a view. If a secondary database has a different name from the primary database, then these object references would break in the secondary database. Due to technical limitations (read more here), avoid using the following characters: |, ., ".
    parameters list(object)
    Outputs the result of SHOW PARAMETERS IN DATABASE for the given object.
    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.
    replication object
    Configures replication for a given database. When specified, this database will be promoted to serve as a primary database for replication. A primary database can be replicated in one or more accounts, allowing users in those accounts to query objects in each secondary (i.e. replica) database.
    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.
    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 database.
    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.
    dropPublicSchemaOnCreation Boolean
    Specifies whether to drop public schema on creation or not. Modifying the parameter after database is already created won't have any effect.
    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 Boolean
    Specifies the database as transient. Transient databases 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.
    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 database; must be unique for your account. As a best practice for Database Replication and Failover, it is recommended to give each secondary database the same name as its primary database. This practice supports referencing fully-qualified objects (i.e. '\n\n.\n\n.\n\n') by other objects in the same database, such as querying a fully-qualified table name in a view. If a secondary database has a different name from the primary database, then these object references would break in the secondary database. Due to technical limitations (read more here), avoid using the following characters: |, ., ".
    parameters List<DatabaseParameter>
    Outputs the result of SHOW PARAMETERS IN DATABASE for the given object.
    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.
    replication DatabaseReplication
    Configures replication for a given database. When specified, this database will be promoted to serve as a primary database for replication. A primary database can be replicated in one or more accounts, allowing users in those accounts to query objects in each secondary (i.e. replica) database.
    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.
    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 database.
    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.
    dropPublicSchemaOnCreation boolean
    Specifies whether to drop public schema on creation or not. Modifying the parameter after database is already created won't have any effect.
    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 boolean
    Specifies the database as transient. Transient databases 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.
    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 database; must be unique for your account. As a best practice for Database Replication and Failover, it is recommended to give each secondary database the same name as its primary database. This practice supports referencing fully-qualified objects (i.e. '\n\n.\n\n.\n\n') by other objects in the same database, such as querying a fully-qualified table name in a view. If a secondary database has a different name from the primary database, then these object references would break in the secondary database. Due to technical limitations (read more here), avoid using the following characters: |, ., ".
    parameters DatabaseParameter[]
    Outputs the result of SHOW PARAMETERS IN DATABASE for the given object.
    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.
    replication DatabaseReplication
    Configures replication for a given database. When specified, this database will be promoted to serve as a primary database for replication. A primary database can be replicated in one or more accounts, allowing users in those accounts to query objects in each secondary (i.e. replica) database.
    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.
    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 database.
    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.
    drop_public_schema_on_creation bool
    Specifies whether to drop public schema on creation or not. Modifying the parameter after database is already created won't have any effect.
    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 bool
    Specifies the database as transient. Transient databases 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.
    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 database; must be unique for your account. As a best practice for Database Replication and Failover, it is recommended to give each secondary database the same name as its primary database. This practice supports referencing fully-qualified objects (i.e. '\n\n.\n\n.\n\n') by other objects in the same database, such as querying a fully-qualified table name in a view. If a secondary database has a different name from the primary database, then these object references would break in the secondary database. Due to technical limitations (read more here), avoid using the following characters: |, ., ".
    parameters Sequence[DatabaseParameterArgs]
    Outputs the result of SHOW PARAMETERS IN DATABASE for the given object.
    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.
    replication DatabaseReplicationArgs
    Configures replication for a given database. When specified, this database will be promoted to serve as a primary database for replication. A primary database can be replicated in one or more accounts, allowing users in those accounts to query objects in each secondary (i.e. replica) database.
    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.
    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 database.
    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.
    dropPublicSchemaOnCreation Boolean
    Specifies whether to drop public schema on creation or not. Modifying the parameter after database is already created won't have any effect.
    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 Boolean
    Specifies the database as transient. Transient databases 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.
    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 database; must be unique for your account. As a best practice for Database Replication and Failover, it is recommended to give each secondary database the same name as its primary database. This practice supports referencing fully-qualified objects (i.e. '\n\n.\n\n.\n\n') by other objects in the same database, such as querying a fully-qualified table name in a view. If a secondary database has a different name from the primary database, then these object references would break in the secondary database. Due to technical limitations (read more here), avoid using the following characters: |, ., ".
    parameters List<Property Map>
    Outputs the result of SHOW PARAMETERS IN DATABASE for the given object.
    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.
    replication Property Map
    Configures replication for a given database. When specified, this database will be promoted to serve as a primary database for replication. A primary database can be replicated in one or more accounts, allowing users in those accounts to query objects in each secondary (i.e. replica) database.
    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.

    Supporting Types

    DatabaseParameter, DatabaseParameterArgs

    Catalogs List<DatabaseParameterCatalog>
    DataRetentionTimeInDays List<DatabaseParameterDataRetentionTimeInDay>
    DefaultDdlCollations List<DatabaseParameterDefaultDdlCollation>
    DefaultNotebookComputePoolCpus List<DatabaseParameterDefaultNotebookComputePoolCpus>
    DefaultNotebookComputePoolGpus List<DatabaseParameterDefaultNotebookComputePoolGpus>
    EnableConsoleOutputs List<DatabaseParameterEnableConsoleOutput>
    ExternalVolumes List<DatabaseParameterExternalVolume>
    LogEventLevels List<DatabaseParameterLogEventLevel>
    LogLevels List<DatabaseParameterLogLevel>
    MaxDataExtensionTimeInDays List<DatabaseParameterMaxDataExtensionTimeInDay>
    QuotedIdentifiersIgnoreCases List<DatabaseParameterQuotedIdentifiersIgnoreCase>
    ReplaceInvalidCharacters List<DatabaseParameterReplaceInvalidCharacter>
    StorageSerializationPolicies List<DatabaseParameterStorageSerializationPolicy>
    SuspendTaskAfterNumFailures List<DatabaseParameterSuspendTaskAfterNumFailure>
    TaskAutoRetryAttempts List<DatabaseParameterTaskAutoRetryAttempt>
    TraceLevels List<DatabaseParameterTraceLevel>
    UserTaskManagedInitialWarehouseSizes List<DatabaseParameterUserTaskManagedInitialWarehouseSize>
    UserTaskMinimumTriggerIntervalInSeconds List<DatabaseParameterUserTaskMinimumTriggerIntervalInSecond>
    UserTaskTimeoutMs List<DatabaseParameterUserTaskTimeoutM>
    Catalogs []DatabaseParameterCatalog
    DataRetentionTimeInDays []DatabaseParameterDataRetentionTimeInDay
    DefaultDdlCollations []DatabaseParameterDefaultDdlCollation
    DefaultNotebookComputePoolCpus []DatabaseParameterDefaultNotebookComputePoolCpus
    DefaultNotebookComputePoolGpus []DatabaseParameterDefaultNotebookComputePoolGpus
    EnableConsoleOutputs []DatabaseParameterEnableConsoleOutput
    ExternalVolumes []DatabaseParameterExternalVolume
    LogEventLevels []DatabaseParameterLogEventLevel
    LogLevels []DatabaseParameterLogLevel
    MaxDataExtensionTimeInDays []DatabaseParameterMaxDataExtensionTimeInDay
    QuotedIdentifiersIgnoreCases []DatabaseParameterQuotedIdentifiersIgnoreCase
    ReplaceInvalidCharacters []DatabaseParameterReplaceInvalidCharacter
    StorageSerializationPolicies []DatabaseParameterStorageSerializationPolicy
    SuspendTaskAfterNumFailures []DatabaseParameterSuspendTaskAfterNumFailure
    TaskAutoRetryAttempts []DatabaseParameterTaskAutoRetryAttempt
    TraceLevels []DatabaseParameterTraceLevel
    UserTaskManagedInitialWarehouseSizes []DatabaseParameterUserTaskManagedInitialWarehouseSize
    UserTaskMinimumTriggerIntervalInSeconds []DatabaseParameterUserTaskMinimumTriggerIntervalInSecond
    UserTaskTimeoutMs []DatabaseParameterUserTaskTimeoutM
    catalogs List<DatabaseParameterCatalog>
    dataRetentionTimeInDays List<DatabaseParameterDataRetentionTimeInDay>
    defaultDdlCollations List<DatabaseParameterDefaultDdlCollation>
    defaultNotebookComputePoolCpus List<DatabaseParameterDefaultNotebookComputePoolCpus>
    defaultNotebookComputePoolGpus List<DatabaseParameterDefaultNotebookComputePoolGpus>
    enableConsoleOutputs List<DatabaseParameterEnableConsoleOutput>
    externalVolumes List<DatabaseParameterExternalVolume>
    logEventLevels List<DatabaseParameterLogEventLevel>
    logLevels List<DatabaseParameterLogLevel>
    maxDataExtensionTimeInDays List<DatabaseParameterMaxDataExtensionTimeInDay>
    quotedIdentifiersIgnoreCases List<DatabaseParameterQuotedIdentifiersIgnoreCase>
    replaceInvalidCharacters List<DatabaseParameterReplaceInvalidCharacter>
    storageSerializationPolicies List<DatabaseParameterStorageSerializationPolicy>
    suspendTaskAfterNumFailures List<DatabaseParameterSuspendTaskAfterNumFailure>
    taskAutoRetryAttempts List<DatabaseParameterTaskAutoRetryAttempt>
    traceLevels List<DatabaseParameterTraceLevel>
    userTaskManagedInitialWarehouseSizes List<DatabaseParameterUserTaskManagedInitialWarehouseSize>
    userTaskMinimumTriggerIntervalInSeconds List<DatabaseParameterUserTaskMinimumTriggerIntervalInSecond>
    userTaskTimeoutMs List<DatabaseParameterUserTaskTimeoutM>
    catalogs DatabaseParameterCatalog[]
    dataRetentionTimeInDays DatabaseParameterDataRetentionTimeInDay[]
    defaultDdlCollations DatabaseParameterDefaultDdlCollation[]
    defaultNotebookComputePoolCpus DatabaseParameterDefaultNotebookComputePoolCpus[]
    defaultNotebookComputePoolGpus DatabaseParameterDefaultNotebookComputePoolGpus[]
    enableConsoleOutputs DatabaseParameterEnableConsoleOutput[]
    externalVolumes DatabaseParameterExternalVolume[]
    logEventLevels DatabaseParameterLogEventLevel[]
    logLevels DatabaseParameterLogLevel[]
    maxDataExtensionTimeInDays DatabaseParameterMaxDataExtensionTimeInDay[]
    quotedIdentifiersIgnoreCases DatabaseParameterQuotedIdentifiersIgnoreCase[]
    replaceInvalidCharacters DatabaseParameterReplaceInvalidCharacter[]
    storageSerializationPolicies DatabaseParameterStorageSerializationPolicy[]
    suspendTaskAfterNumFailures DatabaseParameterSuspendTaskAfterNumFailure[]
    taskAutoRetryAttempts DatabaseParameterTaskAutoRetryAttempt[]
    traceLevels DatabaseParameterTraceLevel[]
    userTaskManagedInitialWarehouseSizes DatabaseParameterUserTaskManagedInitialWarehouseSize[]
    userTaskMinimumTriggerIntervalInSeconds DatabaseParameterUserTaskMinimumTriggerIntervalInSecond[]
    userTaskTimeoutMs DatabaseParameterUserTaskTimeoutM[]
    catalogs Sequence[DatabaseParameterCatalog]
    data_retention_time_in_days Sequence[DatabaseParameterDataRetentionTimeInDay]
    default_ddl_collations Sequence[DatabaseParameterDefaultDdlCollation]
    default_notebook_compute_pool_cpus Sequence[DatabaseParameterDefaultNotebookComputePoolCpus]
    default_notebook_compute_pool_gpus Sequence[DatabaseParameterDefaultNotebookComputePoolGpus]
    enable_console_outputs Sequence[DatabaseParameterEnableConsoleOutput]
    external_volumes Sequence[DatabaseParameterExternalVolume]
    log_event_levels Sequence[DatabaseParameterLogEventLevel]
    log_levels Sequence[DatabaseParameterLogLevel]
    max_data_extension_time_in_days Sequence[DatabaseParameterMaxDataExtensionTimeInDay]
    quoted_identifiers_ignore_cases Sequence[DatabaseParameterQuotedIdentifiersIgnoreCase]
    replace_invalid_characters Sequence[DatabaseParameterReplaceInvalidCharacter]
    storage_serialization_policies Sequence[DatabaseParameterStorageSerializationPolicy]
    suspend_task_after_num_failures Sequence[DatabaseParameterSuspendTaskAfterNumFailure]
    task_auto_retry_attempts Sequence[DatabaseParameterTaskAutoRetryAttempt]
    trace_levels Sequence[DatabaseParameterTraceLevel]
    user_task_managed_initial_warehouse_sizes Sequence[DatabaseParameterUserTaskManagedInitialWarehouseSize]
    user_task_minimum_trigger_interval_in_seconds Sequence[DatabaseParameterUserTaskMinimumTriggerIntervalInSecond]
    user_task_timeout_ms Sequence[DatabaseParameterUserTaskTimeoutM]

    DatabaseParameterCatalog, DatabaseParameterCatalogArgs

    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

    DatabaseParameterDataRetentionTimeInDay, DatabaseParameterDataRetentionTimeInDayArgs

    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

    DatabaseParameterDefaultDdlCollation, DatabaseParameterDefaultDdlCollationArgs

    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

    DatabaseParameterDefaultNotebookComputePoolCpus, DatabaseParameterDefaultNotebookComputePoolCpusArgs

    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

    DatabaseParameterDefaultNotebookComputePoolGpus, DatabaseParameterDefaultNotebookComputePoolGpusArgs

    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

    DatabaseParameterEnableConsoleOutput, DatabaseParameterEnableConsoleOutputArgs

    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

    DatabaseParameterExternalVolume, DatabaseParameterExternalVolumeArgs

    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

    DatabaseParameterLogEventLevel, DatabaseParameterLogEventLevelArgs

    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

    DatabaseParameterLogLevel, DatabaseParameterLogLevelArgs

    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

    DatabaseParameterMaxDataExtensionTimeInDay, DatabaseParameterMaxDataExtensionTimeInDayArgs

    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

    DatabaseParameterQuotedIdentifiersIgnoreCase, DatabaseParameterQuotedIdentifiersIgnoreCaseArgs

    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

    DatabaseParameterReplaceInvalidCharacter, DatabaseParameterReplaceInvalidCharacterArgs

    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

    DatabaseParameterStorageSerializationPolicy, DatabaseParameterStorageSerializationPolicyArgs

    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

    DatabaseParameterSuspendTaskAfterNumFailure, DatabaseParameterSuspendTaskAfterNumFailureArgs

    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

    DatabaseParameterTaskAutoRetryAttempt, DatabaseParameterTaskAutoRetryAttemptArgs

    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

    DatabaseParameterTraceLevel, DatabaseParameterTraceLevelArgs

    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

    DatabaseParameterUserTaskManagedInitialWarehouseSize, DatabaseParameterUserTaskManagedInitialWarehouseSizeArgs

    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

    DatabaseParameterUserTaskMinimumTriggerIntervalInSecond, DatabaseParameterUserTaskMinimumTriggerIntervalInSecondArgs

    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

    DatabaseParameterUserTaskTimeoutM, DatabaseParameterUserTaskTimeoutMArgs

    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

    DatabaseReplication, DatabaseReplicationArgs

    EnableToAccounts List<DatabaseReplicationEnableToAccount>
    Entry to enable replication and optionally failover for a given account identifier.
    IgnoreEditionCheck bool
    Allows replicating data to accounts on lower editions in either of the following scenarios: 1. The primary database is in a Business Critical (or higher) account but one or more of the accounts approved for replication are on lower editions. Business Critical Edition is intended for Snowflake accounts with extremely sensitive data. 2. The primary database is in a Business Critical (or higher) account and a signed business associate agreement is in place to store PHI data in the account per HIPAA and HITRUST regulations, but no such agreement is in place for one or more of the accounts approved for replication, regardless if they are Business Critical (or higher) accounts. Both scenarios are prohibited by default in an effort to help prevent account administrators for Business Critical (or higher) accounts from inadvertently replicating sensitive data to accounts on lower editions.
    EnableToAccounts []DatabaseReplicationEnableToAccount
    Entry to enable replication and optionally failover for a given account identifier.
    IgnoreEditionCheck bool
    Allows replicating data to accounts on lower editions in either of the following scenarios: 1. The primary database is in a Business Critical (or higher) account but one or more of the accounts approved for replication are on lower editions. Business Critical Edition is intended for Snowflake accounts with extremely sensitive data. 2. The primary database is in a Business Critical (or higher) account and a signed business associate agreement is in place to store PHI data in the account per HIPAA and HITRUST regulations, but no such agreement is in place for one or more of the accounts approved for replication, regardless if they are Business Critical (or higher) accounts. Both scenarios are prohibited by default in an effort to help prevent account administrators for Business Critical (or higher) accounts from inadvertently replicating sensitive data to accounts on lower editions.
    enable_to_accounts list(object)
    Entry to enable replication and optionally failover for a given account identifier.
    ignore_edition_check bool
    Allows replicating data to accounts on lower editions in either of the following scenarios: 1. The primary database is in a Business Critical (or higher) account but one or more of the accounts approved for replication are on lower editions. Business Critical Edition is intended for Snowflake accounts with extremely sensitive data. 2. The primary database is in a Business Critical (or higher) account and a signed business associate agreement is in place to store PHI data in the account per HIPAA and HITRUST regulations, but no such agreement is in place for one or more of the accounts approved for replication, regardless if they are Business Critical (or higher) accounts. Both scenarios are prohibited by default in an effort to help prevent account administrators for Business Critical (or higher) accounts from inadvertently replicating sensitive data to accounts on lower editions.
    enableToAccounts List<DatabaseReplicationEnableToAccount>
    Entry to enable replication and optionally failover for a given account identifier.
    ignoreEditionCheck Boolean
    Allows replicating data to accounts on lower editions in either of the following scenarios: 1. The primary database is in a Business Critical (or higher) account but one or more of the accounts approved for replication are on lower editions. Business Critical Edition is intended for Snowflake accounts with extremely sensitive data. 2. The primary database is in a Business Critical (or higher) account and a signed business associate agreement is in place to store PHI data in the account per HIPAA and HITRUST regulations, but no such agreement is in place for one or more of the accounts approved for replication, regardless if they are Business Critical (or higher) accounts. Both scenarios are prohibited by default in an effort to help prevent account administrators for Business Critical (or higher) accounts from inadvertently replicating sensitive data to accounts on lower editions.
    enableToAccounts DatabaseReplicationEnableToAccount[]
    Entry to enable replication and optionally failover for a given account identifier.
    ignoreEditionCheck boolean
    Allows replicating data to accounts on lower editions in either of the following scenarios: 1. The primary database is in a Business Critical (or higher) account but one or more of the accounts approved for replication are on lower editions. Business Critical Edition is intended for Snowflake accounts with extremely sensitive data. 2. The primary database is in a Business Critical (or higher) account and a signed business associate agreement is in place to store PHI data in the account per HIPAA and HITRUST regulations, but no such agreement is in place for one or more of the accounts approved for replication, regardless if they are Business Critical (or higher) accounts. Both scenarios are prohibited by default in an effort to help prevent account administrators for Business Critical (or higher) accounts from inadvertently replicating sensitive data to accounts on lower editions.
    enable_to_accounts Sequence[DatabaseReplicationEnableToAccount]
    Entry to enable replication and optionally failover for a given account identifier.
    ignore_edition_check bool
    Allows replicating data to accounts on lower editions in either of the following scenarios: 1. The primary database is in a Business Critical (or higher) account but one or more of the accounts approved for replication are on lower editions. Business Critical Edition is intended for Snowflake accounts with extremely sensitive data. 2. The primary database is in a Business Critical (or higher) account and a signed business associate agreement is in place to store PHI data in the account per HIPAA and HITRUST regulations, but no such agreement is in place for one or more of the accounts approved for replication, regardless if they are Business Critical (or higher) accounts. Both scenarios are prohibited by default in an effort to help prevent account administrators for Business Critical (or higher) accounts from inadvertently replicating sensitive data to accounts on lower editions.
    enableToAccounts List<Property Map>
    Entry to enable replication and optionally failover for a given account identifier.
    ignoreEditionCheck Boolean
    Allows replicating data to accounts on lower editions in either of the following scenarios: 1. The primary database is in a Business Critical (or higher) account but one or more of the accounts approved for replication are on lower editions. Business Critical Edition is intended for Snowflake accounts with extremely sensitive data. 2. The primary database is in a Business Critical (or higher) account and a signed business associate agreement is in place to store PHI data in the account per HIPAA and HITRUST regulations, but no such agreement is in place for one or more of the accounts approved for replication, regardless if they are Business Critical (or higher) accounts. Both scenarios are prohibited by default in an effort to help prevent account administrators for Business Critical (or higher) accounts from inadvertently replicating sensitive data to accounts on lower editions.

    DatabaseReplicationEnableToAccount, DatabaseReplicationEnableToAccountArgs

    AccountIdentifier string
    Specifies account identifier for which replication should be enabled. The account identifiers should be in the form of "<organization_name>"."<account_name>". For more information about this resource, see docs.
    WithFailover bool
    Specifies if failover should be enabled for the specified account identifier
    AccountIdentifier string
    Specifies account identifier for which replication should be enabled. The account identifiers should be in the form of "<organization_name>"."<account_name>". For more information about this resource, see docs.
    WithFailover bool
    Specifies if failover should be enabled for the specified account identifier
    account_identifier string
    Specifies account identifier for which replication should be enabled. The account identifiers should be in the form of "<organization_name>"."<account_name>". For more information about this resource, see docs.
    with_failover bool
    Specifies if failover should be enabled for the specified account identifier
    accountIdentifier String
    Specifies account identifier for which replication should be enabled. The account identifiers should be in the form of "<organization_name>"."<account_name>". For more information about this resource, see docs.
    withFailover Boolean
    Specifies if failover should be enabled for the specified account identifier
    accountIdentifier string
    Specifies account identifier for which replication should be enabled. The account identifiers should be in the form of "<organization_name>"."<account_name>". For more information about this resource, see docs.
    withFailover boolean
    Specifies if failover should be enabled for the specified account identifier
    account_identifier str
    Specifies account identifier for which replication should be enabled. The account identifiers should be in the form of "<organization_name>"."<account_name>". For more information about this resource, see docs.
    with_failover bool
    Specifies if failover should be enabled for the specified account identifier
    accountIdentifier String
    Specifies account identifier for which replication should be enabled. The account identifiers should be in the form of "<organization_name>"."<account_name>". For more information about this resource, see docs.
    withFailover Boolean
    Specifies if failover should be enabled for the specified account identifier

    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/database:Database example '"<database_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
    Schema (JSON)
    pulumi/pulumi-snowflake

      Try Pulumi Cloud free.
      Your team will thank you.

      Start free trial