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

snowflake.SecondaryDatabase

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.

    Note The snowflake.SecondaryDatabase resource doesn’t refresh itself, as the best practice is to use tasks scheduled for a certain interval. Check out the examples to see how to set up the refresh task. For SQL-based replication guide, see the official documentation.

    A secondary database creates a replica of an existing primary database (i.e. a secondary database). For more information about database replication, see Introduction to database replication across multiple accounts.

    Create SecondaryDatabase Resource

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

    Constructor syntax

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

@overload
def SecondaryDatabase(resource_name: str,
                      opts: Optional[ResourceOptions] = None,
                      as_replica_of: Optional[str] = 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,
                      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,
                      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 NewSecondaryDatabase(ctx *Context, name string, args SecondaryDatabaseArgs, opts ...ResourceOption) (*SecondaryDatabase, error)
    public SecondaryDatabase(string name, SecondaryDatabaseArgs args, CustomResourceOptions? opts = null)
    public SecondaryDatabase(String name, SecondaryDatabaseArgs args)
public SecondaryDatabase(String name, SecondaryDatabaseArgs args, CustomResourceOptions options)

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


    resource "snowflake_secondary_database" "name" {
    # resource properties
}

    Parameters

    name string
    The unique name of the resource.
    args SecondaryDatabaseArgs
    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 SecondaryDatabaseArgs
    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 SecondaryDatabaseArgs
    The arguments to resource properties.
    opts ResourceOption
    Bag of options to control resource's behavior.
    name string
    The unique name of the resource.
    args SecondaryDatabaseArgs
    The arguments to resource properties.
    opts CustomResourceOptions
    Bag of options to control resource's behavior.
    name String
    The unique name of the resource.
    args SecondaryDatabaseArgs
    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 secondaryDatabaseResource = new Snowflake.SecondaryDatabase("secondaryDatabaseResource", new()
{
    AsReplicaOf = "string",
    Catalog = "string",
    Comment = "string",
    DataRetentionTimeInDays = 0,
    DefaultDdlCollation = "string",
    DefaultNotebookComputePoolCpu = "string",
    DefaultNotebookComputePoolGpu = "string",
    EnableConsoleOutput = false,
    ExternalVolume = "string",
    IsTransient = false,
    LogEventLevel = "string",
    LogLevel = "string",
    MaxDataExtensionTimeInDays = 0,
    Name = "string",
    QuotedIdentifiersIgnoreCase = false,
    ReplaceInvalidCharacters = false,
    StorageSerializationPolicy = "string",
    SuspendTaskAfterNumFailures = 0,
    TaskAutoRetryAttempts = 0,
    TraceLevel = "string",
    UserTaskManagedInitialWarehouseSize = "string",
    UserTaskMinimumTriggerIntervalInSeconds = 0,
    UserTaskTimeoutMs = 0,
});

    example, err := snowflake.NewSecondaryDatabase(ctx, "secondaryDatabaseResource", &snowflake.SecondaryDatabaseArgs{
	AsReplicaOf:                             pulumi.String("string"),
	Catalog:                                 pulumi.String("string"),
	Comment:                                 pulumi.String("string"),
	DataRetentionTimeInDays:                 pulumi.Int(0),
	DefaultDdlCollation:                     pulumi.String("string"),
	DefaultNotebookComputePoolCpu:           pulumi.String("string"),
	DefaultNotebookComputePoolGpu:           pulumi.String("string"),
	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),
	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_secondary_database" "secondaryDatabaseResource" {
  lifecycle {
    create_before_destroy = true
  }
  as_replica_of                                 = "string"
  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"
  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
  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 secondaryDatabaseResource = new SecondaryDatabase("secondaryDatabaseResource", SecondaryDatabaseArgs.builder()
    .asReplicaOf("string")
    .catalog("string")
    .comment("string")
    .dataRetentionTimeInDays(0)
    .defaultDdlCollation("string")
    .defaultNotebookComputePoolCpu("string")
    .defaultNotebookComputePoolGpu("string")
    .enableConsoleOutput(false)
    .externalVolume("string")
    .isTransient(false)
    .logEventLevel("string")
    .logLevel("string")
    .maxDataExtensionTimeInDays(0)
    .name("string")
    .quotedIdentifiersIgnoreCase(false)
    .replaceInvalidCharacters(false)
    .storageSerializationPolicy("string")
    .suspendTaskAfterNumFailures(0)
    .taskAutoRetryAttempts(0)
    .traceLevel("string")
    .userTaskManagedInitialWarehouseSize("string")
    .userTaskMinimumTriggerIntervalInSeconds(0)
    .userTaskTimeoutMs(0)
    .build());

    secondary_database_resource = snowflake.SecondaryDatabase("secondaryDatabaseResource",
    as_replica_of="string",
    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",
    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,
    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 secondaryDatabaseResource = new snowflake.SecondaryDatabase("secondaryDatabaseResource", {
    asReplicaOf: "string",
    catalog: "string",
    comment: "string",
    dataRetentionTimeInDays: 0,
    defaultDdlCollation: "string",
    defaultNotebookComputePoolCpu: "string",
    defaultNotebookComputePoolGpu: "string",
    enableConsoleOutput: false,
    externalVolume: "string",
    isTransient: false,
    logEventLevel: "string",
    logLevel: "string",
    maxDataExtensionTimeInDays: 0,
    name: "string",
    quotedIdentifiersIgnoreCase: false,
    replaceInvalidCharacters: false,
    storageSerializationPolicy: "string",
    suspendTaskAfterNumFailures: 0,
    taskAutoRetryAttempts: 0,
    traceLevel: "string",
    userTaskManagedInitialWarehouseSize: "string",
    userTaskMinimumTriggerIntervalInSeconds: 0,
    userTaskTimeoutMs: 0,
});

    type: snowflake:SecondaryDatabase
properties:
    asReplicaOf: string
    catalog: string
    comment: string
    dataRetentionTimeInDays: 0
    defaultDdlCollation: string
    defaultNotebookComputePoolCpu: string
    defaultNotebookComputePoolGpu: string
    enableConsoleOutput: false
    externalVolume: string
    isTransient: false
    logEventLevel: string
    logLevel: string
    maxDataExtensionTimeInDays: 0
    name: string
    quotedIdentifiersIgnoreCase: false
    replaceInvalidCharacters: false
    storageSerializationPolicy: string
    suspendTaskAfterNumFailures: 0
    taskAutoRetryAttempts: 0
    traceLevel: string
    userTaskManagedInitialWarehouseSize: string
    userTaskMinimumTriggerIntervalInSeconds: 0
    userTaskTimeoutMs: 0

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

    AsReplicaOf string
    A fully qualified path to a database to create a replica from. A fully qualified path follows the format of "<organization_name>"."<account_name>"."<database_name>". For more information about this resource, see 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.
    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.
    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.
    AsReplicaOf string
    A fully qualified path to a database to create a replica from. A fully qualified path follows the format of "<organization_name>"."<account_name>"."<database_name>". For more information about this resource, see 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.
    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.
    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.
    as_replica_of string
    A fully qualified path to a database to create a replica from. A fully qualified path follows the format of "<organization_name>"."<account_name>"."<database_name>". For more information about this resource, see 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.
    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.
    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.
    asReplicaOf String
    A fully qualified path to a database to create a replica from. A fully qualified path follows the format of "<organization_name>"."<account_name>"."<database_name>". For more information about this resource, see 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.
    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.
    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.
    asReplicaOf string
    A fully qualified path to a database to create a replica from. A fully qualified path follows the format of "<organization_name>"."<account_name>"."<database_name>". For more information about this resource, see 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.
    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.
    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.
    as_replica_of str
    A fully qualified path to a database to create a replica from. A fully qualified path follows the format of "<organization_name>"."<account_name>"."<database_name>". For more information about this resource, see 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.
    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.
    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.
    asReplicaOf String
    A fully qualified path to a database to create a replica from. A fully qualified path follows the format of "<organization_name>"."<account_name>"."<database_name>". For more information about this resource, see 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.
    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.
    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 SecondaryDatabase 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.
    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.
    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.
    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.
    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.
    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.
    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.

    Look up Existing SecondaryDatabase Resource

    Get an existing SecondaryDatabase 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?: SecondaryDatabaseState, opts?: CustomResourceOptions): SecondaryDatabase
    @staticmethod
def get(resource_name: str,
        id: str,
        opts: Optional[ResourceOptions] = None,
        as_replica_of: Optional[str] = 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,
        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,
        quoted_identifiers_ignore_case: Optional[bool] = None,
        replace_invalid_characters: Optional[bool] = 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) -> SecondaryDatabase
    func GetSecondaryDatabase(ctx *Context, name string, id IDInput, state *SecondaryDatabaseState, opts ...ResourceOption) (*SecondaryDatabase, error)
    public static SecondaryDatabase Get(string name, Input<string> id, SecondaryDatabaseState? state, CustomResourceOptions? opts = null)
    public static SecondaryDatabase get(String name, Output<String> id, SecondaryDatabaseState state, CustomResourceOptions options)
    resources:  _:    type: snowflake:SecondaryDatabase    get:      id: ${id}
    import {
  to = snowflake_secondary_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:
    AsReplicaOf string
    A fully qualified path to a database to create a replica from. A fully qualified path follows the format of "<organization_name>"."<account_name>"."<database_name>". For more information about this resource, see 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.
    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: |, ., ".
    QuotedIdentifiersIgnoreCase bool
    If true, the case of quoted identifiers is ignored. For more information, check QUOTEDIDENTIFIERSIGNORE_CASE docs.
    ReplaceInvalidCharacters bool
    Specifies whether to replace invalid UTF-8 characters with the Unicode replacement character in query results for an Iceberg table. You can only set this parameter for tables that use an external Iceberg catalog. For more information, check REPLACEINVALIDCHARACTERS docs.
    StorageSerializationPolicy string
    The storage serialization policy for Iceberg tables that use Snowflake as the catalog. COMPATIBLE: Snowflake performs encoding and compression of data files that ensures interoperability with third-party compute engines. OPTIMIZED: Snowflake performs encoding and compression of data files that ensures the best table performance within Snowflake. Valid values are (case-insensitive): COMPATIBLE | OPTIMIZED. For more information, check STORAGESERIALIZATIONPOLICY docs.
    SuspendTaskAfterNumFailures int
    How many times a task must fail in a row before it is automatically suspended. 0 disables auto-suspending. For more information, check SUSPENDTASKAFTERNUMFAILURES docs.
    TaskAutoRetryAttempts int
    Maximum automatic retries allowed for a user task. For more information, check TASKAUTORETRY_ATTEMPTS docs.
    TraceLevel string
    Controls how trace events are ingested into the event table. Valid values are (case-insensitive): ALWAYS | ON_EVENT | PROPAGATE | OFF. For more information, check TRACE_LEVEL docs.
    UserTaskManagedInitialWarehouseSize string
    The initial size of warehouse to use for managed warehouses in the absence of history. Valid values are (case-insensitive): XSMALL | SMALL | MEDIUM | LARGE | XLARGE | XXLARGE | XXXLARGE | X4LARGE | X5LARGE | X6LARGE. For more information, check USERTASKMANAGEDINITIALWAREHOUSE_SIZE docs.
    UserTaskMinimumTriggerIntervalInSeconds int
    Minimum amount of time between Triggered Task executions in seconds. For more information, check USERTASKMINIMUMTRIGGERINTERVALINSECONDS docs.
    UserTaskTimeoutMs int
    User task execution timeout in milliseconds. For more information, check USERTASKTIMEOUT_MS docs.
    AsReplicaOf string
    A fully qualified path to a database to create a replica from. A fully qualified path follows the format of "<organization_name>"."<account_name>"."<database_name>". For more information about this resource, see 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.
    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: |, ., ".
    QuotedIdentifiersIgnoreCase bool
    If true, the case of quoted identifiers is ignored. For more information, check QUOTEDIDENTIFIERSIGNORE_CASE docs.
    ReplaceInvalidCharacters bool
    Specifies whether to replace invalid UTF-8 characters with the Unicode replacement character in query results for an Iceberg table. You can only set this parameter for tables that use an external Iceberg catalog. For more information, check REPLACEINVALIDCHARACTERS docs.
    StorageSerializationPolicy string
    The storage serialization policy for Iceberg tables that use Snowflake as the catalog. COMPATIBLE: Snowflake performs encoding and compression of data files that ensures interoperability with third-party compute engines. OPTIMIZED: Snowflake performs encoding and compression of data files that ensures the best table performance within Snowflake. Valid values are (case-insensitive): COMPATIBLE | OPTIMIZED. For more information, check STORAGESERIALIZATIONPOLICY docs.
    SuspendTaskAfterNumFailures int
    How many times a task must fail in a row before it is automatically suspended. 0 disables auto-suspending. For more information, check SUSPENDTASKAFTERNUMFAILURES docs.
    TaskAutoRetryAttempts int
    Maximum automatic retries allowed for a user task. For more information, check TASKAUTORETRY_ATTEMPTS docs.
    TraceLevel string
    Controls how trace events are ingested into the event table. Valid values are (case-insensitive): ALWAYS | ON_EVENT | PROPAGATE | OFF. For more information, check TRACE_LEVEL docs.
    UserTaskManagedInitialWarehouseSize string
    The initial size of warehouse to use for managed warehouses in the absence of history. Valid values are (case-insensitive): XSMALL | SMALL | MEDIUM | LARGE | XLARGE | XXLARGE | XXXLARGE | X4LARGE | X5LARGE | X6LARGE. For more information, check USERTASKMANAGEDINITIALWAREHOUSE_SIZE docs.
    UserTaskMinimumTriggerIntervalInSeconds int
    Minimum amount of time between Triggered Task executions in seconds. For more information, check USERTASKMINIMUMTRIGGERINTERVALINSECONDS docs.
    UserTaskTimeoutMs int
    User task execution timeout in milliseconds. For more information, check USERTASKTIMEOUT_MS docs.
    as_replica_of string
    A fully qualified path to a database to create a replica from. A fully qualified path follows the format of "<organization_name>"."<account_name>"."<database_name>". For more information about this resource, see 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.
    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: |, ., ".
    quoted_identifiers_ignore_case bool
    If true, the case of quoted identifiers is ignored. For more information, check QUOTEDIDENTIFIERSIGNORE_CASE docs.
    replace_invalid_characters bool
    Specifies whether to replace invalid UTF-8 characters with the Unicode replacement character in query results for an Iceberg table. You can only set this parameter for tables that use an external Iceberg catalog. For more information, check REPLACEINVALIDCHARACTERS docs.
    storage_serialization_policy string
    The storage serialization policy for Iceberg tables that use Snowflake as the catalog. COMPATIBLE: Snowflake performs encoding and compression of data files that ensures interoperability with third-party compute engines. OPTIMIZED: Snowflake performs encoding and compression of data files that ensures the best table performance within Snowflake. Valid values are (case-insensitive): COMPATIBLE | OPTIMIZED. For more information, check STORAGESERIALIZATIONPOLICY docs.
    suspend_task_after_num_failures number
    How many times a task must fail in a row before it is automatically suspended. 0 disables auto-suspending. For more information, check SUSPENDTASKAFTERNUMFAILURES docs.
    task_auto_retry_attempts number
    Maximum automatic retries allowed for a user task. For more information, check TASKAUTORETRY_ATTEMPTS docs.
    trace_level string
    Controls how trace events are ingested into the event table. Valid values are (case-insensitive): ALWAYS | ON_EVENT | PROPAGATE | OFF. For more information, check TRACE_LEVEL docs.
    user_task_managed_initial_warehouse_size string
    The initial size of warehouse to use for managed warehouses in the absence of history. Valid values are (case-insensitive): XSMALL | SMALL | MEDIUM | LARGE | XLARGE | XXLARGE | XXXLARGE | X4LARGE | X5LARGE | X6LARGE. For more information, check USERTASKMANAGEDINITIALWAREHOUSE_SIZE docs.
    user_task_minimum_trigger_interval_in_seconds number
    Minimum amount of time between Triggered Task executions in seconds. For more information, check USERTASKMINIMUMTRIGGERINTERVALINSECONDS docs.
    user_task_timeout_ms number
    User task execution timeout in milliseconds. For more information, check USERTASKTIMEOUT_MS docs.
    asReplicaOf String
    A fully qualified path to a database to create a replica from. A fully qualified path follows the format of "<organization_name>"."<account_name>"."<database_name>". For more information about this resource, see 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.
    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: |, ., ".
    quotedIdentifiersIgnoreCase Boolean
    If true, the case of quoted identifiers is ignored. For more information, check QUOTEDIDENTIFIERSIGNORE_CASE docs.
    replaceInvalidCharacters Boolean
    Specifies whether to replace invalid UTF-8 characters with the Unicode replacement character in query results for an Iceberg table. You can only set this parameter for tables that use an external Iceberg catalog. For more information, check REPLACEINVALIDCHARACTERS docs.
    storageSerializationPolicy String
    The storage serialization policy for Iceberg tables that use Snowflake as the catalog. COMPATIBLE: Snowflake performs encoding and compression of data files that ensures interoperability with third-party compute engines. OPTIMIZED: Snowflake performs encoding and compression of data files that ensures the best table performance within Snowflake. Valid values are (case-insensitive): COMPATIBLE | OPTIMIZED. For more information, check STORAGESERIALIZATIONPOLICY docs.
    suspendTaskAfterNumFailures Integer
    How many times a task must fail in a row before it is automatically suspended. 0 disables auto-suspending. For more information, check SUSPENDTASKAFTERNUMFAILURES docs.
    taskAutoRetryAttempts Integer
    Maximum automatic retries allowed for a user task. For more information, check TASKAUTORETRY_ATTEMPTS docs.
    traceLevel String
    Controls how trace events are ingested into the event table. Valid values are (case-insensitive): ALWAYS | ON_EVENT | PROPAGATE | OFF. For more information, check TRACE_LEVEL docs.
    userTaskManagedInitialWarehouseSize String
    The initial size of warehouse to use for managed warehouses in the absence of history. Valid values are (case-insensitive): XSMALL | SMALL | MEDIUM | LARGE | XLARGE | XXLARGE | XXXLARGE | X4LARGE | X5LARGE | X6LARGE. For more information, check USERTASKMANAGEDINITIALWAREHOUSE_SIZE docs.
    userTaskMinimumTriggerIntervalInSeconds Integer
    Minimum amount of time between Triggered Task executions in seconds. For more information, check USERTASKMINIMUMTRIGGERINTERVALINSECONDS docs.
    userTaskTimeoutMs Integer
    User task execution timeout in milliseconds. For more information, check USERTASKTIMEOUT_MS docs.
    asReplicaOf string
    A fully qualified path to a database to create a replica from. A fully qualified path follows the format of "<organization_name>"."<account_name>"."<database_name>". For more information about this resource, see 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.
    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: |, ., ".
    quotedIdentifiersIgnoreCase boolean
    If true, the case of quoted identifiers is ignored. For more information, check QUOTEDIDENTIFIERSIGNORE_CASE docs.
    replaceInvalidCharacters boolean
    Specifies whether to replace invalid UTF-8 characters with the Unicode replacement character in query results for an Iceberg table. You can only set this parameter for tables that use an external Iceberg catalog. For more information, check REPLACEINVALIDCHARACTERS docs.
    storageSerializationPolicy string
    The storage serialization policy for Iceberg tables that use Snowflake as the catalog. COMPATIBLE: Snowflake performs encoding and compression of data files that ensures interoperability with third-party compute engines. OPTIMIZED: Snowflake performs encoding and compression of data files that ensures the best table performance within Snowflake. Valid values are (case-insensitive): COMPATIBLE | OPTIMIZED. For more information, check STORAGESERIALIZATIONPOLICY docs.
    suspendTaskAfterNumFailures number
    How many times a task must fail in a row before it is automatically suspended. 0 disables auto-suspending. For more information, check SUSPENDTASKAFTERNUMFAILURES docs.
    taskAutoRetryAttempts number
    Maximum automatic retries allowed for a user task. For more information, check TASKAUTORETRY_ATTEMPTS docs.
    traceLevel string
    Controls how trace events are ingested into the event table. Valid values are (case-insensitive): ALWAYS | ON_EVENT | PROPAGATE | OFF. For more information, check TRACE_LEVEL docs.
    userTaskManagedInitialWarehouseSize string
    The initial size of warehouse to use for managed warehouses in the absence of history. Valid values are (case-insensitive): XSMALL | SMALL | MEDIUM | LARGE | XLARGE | XXLARGE | XXXLARGE | X4LARGE | X5LARGE | X6LARGE. For more information, check USERTASKMANAGEDINITIALWAREHOUSE_SIZE docs.
    userTaskMinimumTriggerIntervalInSeconds number
    Minimum amount of time between Triggered Task executions in seconds. For more information, check USERTASKMINIMUMTRIGGERINTERVALINSECONDS docs.
    userTaskTimeoutMs number
    User task execution timeout in milliseconds. For more information, check USERTASKTIMEOUT_MS docs.
    as_replica_of str
    A fully qualified path to a database to create a replica from. A fully qualified path follows the format of "<organization_name>"."<account_name>"."<database_name>". For more information about this resource, see 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.
    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: |, ., ".
    quoted_identifiers_ignore_case bool
    If true, the case of quoted identifiers is ignored. For more information, check QUOTEDIDENTIFIERSIGNORE_CASE docs.
    replace_invalid_characters bool
    Specifies whether to replace invalid UTF-8 characters with the Unicode replacement character in query results for an Iceberg table. You can only set this parameter for tables that use an external Iceberg catalog. For more information, check REPLACEINVALIDCHARACTERS docs.
    storage_serialization_policy str
    The storage serialization policy for Iceberg tables that use Snowflake as the catalog. COMPATIBLE: Snowflake performs encoding and compression of data files that ensures interoperability with third-party compute engines. OPTIMIZED: Snowflake performs encoding and compression of data files that ensures the best table performance within Snowflake. Valid values are (case-insensitive): COMPATIBLE | OPTIMIZED. For more information, check STORAGESERIALIZATIONPOLICY docs.
    suspend_task_after_num_failures int
    How many times a task must fail in a row before it is automatically suspended. 0 disables auto-suspending. For more information, check SUSPENDTASKAFTERNUMFAILURES docs.
    task_auto_retry_attempts int
    Maximum automatic retries allowed for a user task. For more information, check TASKAUTORETRY_ATTEMPTS docs.
    trace_level str
    Controls how trace events are ingested into the event table. Valid values are (case-insensitive): ALWAYS | ON_EVENT | PROPAGATE | OFF. For more information, check TRACE_LEVEL docs.
    user_task_managed_initial_warehouse_size str
    The initial size of warehouse to use for managed warehouses in the absence of history. Valid values are (case-insensitive): XSMALL | SMALL | MEDIUM | LARGE | XLARGE | XXLARGE | XXXLARGE | X4LARGE | X5LARGE | X6LARGE. For more information, check USERTASKMANAGEDINITIALWAREHOUSE_SIZE docs.
    user_task_minimum_trigger_interval_in_seconds int
    Minimum amount of time between Triggered Task executions in seconds. For more information, check USERTASKMINIMUMTRIGGERINTERVALINSECONDS docs.
    user_task_timeout_ms int
    User task execution timeout in milliseconds. For more information, check USERTASKTIMEOUT_MS docs.
    asReplicaOf String
    A fully qualified path to a database to create a replica from. A fully qualified path follows the format of "<organization_name>"."<account_name>"."<database_name>". For more information about this resource, see 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.
    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: |, ., ".
    quotedIdentifiersIgnoreCase Boolean
    If true, the case of quoted identifiers is ignored. For more information, check QUOTEDIDENTIFIERSIGNORE_CASE docs.
    replaceInvalidCharacters Boolean
    Specifies whether to replace invalid UTF-8 characters with the Unicode replacement character in query results for an Iceberg table. You can only set this parameter for tables that use an external Iceberg catalog. For more information, check REPLACEINVALIDCHARACTERS docs.
    storageSerializationPolicy String
    The storage serialization policy for Iceberg tables that use Snowflake as the catalog. COMPATIBLE: Snowflake performs encoding and compression of data files that ensures interoperability with third-party compute engines. OPTIMIZED: Snowflake performs encoding and compression of data files that ensures the best table performance within Snowflake. Valid values are (case-insensitive): COMPATIBLE | OPTIMIZED. For more information, check STORAGESERIALIZATIONPOLICY docs.
    suspendTaskAfterNumFailures Number
    How many times a task must fail in a row before it is automatically suspended. 0 disables auto-suspending. For more information, check SUSPENDTASKAFTERNUMFAILURES docs.
    taskAutoRetryAttempts Number
    Maximum automatic retries allowed for a user task. For more information, check TASKAUTORETRY_ATTEMPTS docs.
    traceLevel String
    Controls how trace events are ingested into the event table. Valid values are (case-insensitive): ALWAYS | ON_EVENT | PROPAGATE | OFF. For more information, check TRACE_LEVEL docs.
    userTaskManagedInitialWarehouseSize String
    The initial size of warehouse to use for managed warehouses in the absence of history. Valid values are (case-insensitive): XSMALL | SMALL | MEDIUM | LARGE | XLARGE | XXLARGE | XXXLARGE | X4LARGE | X5LARGE | X6LARGE. For more information, check USERTASKMANAGEDINITIALWAREHOUSE_SIZE docs.
    userTaskMinimumTriggerIntervalInSeconds Number
    Minimum amount of time between Triggered Task executions in seconds. For more information, check USERTASKMINIMUMTRIGGERINTERVALINSECONDS docs.
    userTaskTimeoutMs Number
    User task execution timeout in milliseconds. For more information, check USERTASKTIMEOUT_MS docs.

    Import

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

    $ pulumi import snowflake:index/secondaryDatabase:SecondaryDatabase example '"<secondary_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