1. Packages
  2. Snowflake Provider
  3. API Docs
  4. Schema
Snowflake v1.2.0 published on Monday, Apr 14, 2025 by Pulumi

snowflake.Schema

Explore with Pulumi AI

Import

$ pulumi import snowflake:index/schema:Schema example '"<database_name>"."<schema_name>"'
Copy

Create Schema Resource

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

Constructor syntax

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

@overload
def Schema(resource_name: str,
           opts: Optional[ResourceOptions] = None,
           database: Optional[str] = None,
           name: Optional[str] = None,
           quoted_identifiers_ignore_case: Optional[bool] = None,
           comment: Optional[str] = None,
           default_ddl_collation: Optional[str] = None,
           enable_console_output: Optional[bool] = None,
           external_volume: Optional[str] = None,
           is_transient: Optional[str] = None,
           log_level: Optional[str] = None,
           max_data_extension_time_in_days: Optional[int] = None,
           catalog: Optional[str] = None,
           data_retention_time_in_days: Optional[int] = None,
           replace_invalid_characters: Optional[bool] = None,
           pipe_execution_paused: 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,
           with_managed_access: Optional[str] = None)
func NewSchema(ctx *Context, name string, args SchemaArgs, opts ...ResourceOption) (*Schema, error)
public Schema(string name, SchemaArgs args, CustomResourceOptions? opts = null)
public Schema(String name, SchemaArgs args)
public Schema(String name, SchemaArgs args, CustomResourceOptions options)
type: snowflake:Schema
properties: # The arguments to resource properties.
options: # Bag of options to control resource's behavior.

Parameters

name This property is required. string
The unique name of the resource.
args This property is required. SchemaArgs
The arguments to resource properties.
opts CustomResourceOptions
Bag of options to control resource's behavior.
resource_name This property is required. str
The unique name of the resource.
args This property is required. SchemaArgs
The arguments to resource properties.
opts ResourceOptions
Bag of options to control resource's behavior.
ctx Context
Context object for the current deployment.
name This property is required. string
The unique name of the resource.
args This property is required. SchemaArgs
The arguments to resource properties.
opts ResourceOption
Bag of options to control resource's behavior.
name This property is required. string
The unique name of the resource.
args This property is required. SchemaArgs
The arguments to resource properties.
opts CustomResourceOptions
Bag of options to control resource's behavior.
name This property is required. String
The unique name of the resource.
args This property is required. SchemaArgs
The arguments to resource properties.
options CustomResourceOptions
Bag of options to control resource's behavior.

Constructor example

The following reference example uses placeholder values for all input properties.

var schemaResource = new Snowflake.Schema("schemaResource", new()
{
    Database = "string",
    Name = "string",
    QuotedIdentifiersIgnoreCase = false,
    Comment = "string",
    DefaultDdlCollation = "string",
    EnableConsoleOutput = false,
    ExternalVolume = "string",
    IsTransient = "string",
    LogLevel = "string",
    MaxDataExtensionTimeInDays = 0,
    Catalog = "string",
    DataRetentionTimeInDays = 0,
    ReplaceInvalidCharacters = false,
    PipeExecutionPaused = false,
    StorageSerializationPolicy = "string",
    SuspendTaskAfterNumFailures = 0,
    TaskAutoRetryAttempts = 0,
    TraceLevel = "string",
    UserTaskManagedInitialWarehouseSize = "string",
    UserTaskMinimumTriggerIntervalInSeconds = 0,
    UserTaskTimeoutMs = 0,
    WithManagedAccess = "string",
});
Copy
example, err := snowflake.NewSchema(ctx, "schemaResource", &snowflake.SchemaArgs{
	Database:                                pulumi.String("string"),
	Name:                                    pulumi.String("string"),
	QuotedIdentifiersIgnoreCase:             pulumi.Bool(false),
	Comment:                                 pulumi.String("string"),
	DefaultDdlCollation:                     pulumi.String("string"),
	EnableConsoleOutput:                     pulumi.Bool(false),
	ExternalVolume:                          pulumi.String("string"),
	IsTransient:                             pulumi.String("string"),
	LogLevel:                                pulumi.String("string"),
	MaxDataExtensionTimeInDays:              pulumi.Int(0),
	Catalog:                                 pulumi.String("string"),
	DataRetentionTimeInDays:                 pulumi.Int(0),
	ReplaceInvalidCharacters:                pulumi.Bool(false),
	PipeExecutionPaused:                     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),
	WithManagedAccess:                       pulumi.String("string"),
})
Copy
var schemaResource = new Schema("schemaResource", SchemaArgs.builder()
    .database("string")
    .name("string")
    .quotedIdentifiersIgnoreCase(false)
    .comment("string")
    .defaultDdlCollation("string")
    .enableConsoleOutput(false)
    .externalVolume("string")
    .isTransient("string")
    .logLevel("string")
    .maxDataExtensionTimeInDays(0)
    .catalog("string")
    .dataRetentionTimeInDays(0)
    .replaceInvalidCharacters(false)
    .pipeExecutionPaused(false)
    .storageSerializationPolicy("string")
    .suspendTaskAfterNumFailures(0)
    .taskAutoRetryAttempts(0)
    .traceLevel("string")
    .userTaskManagedInitialWarehouseSize("string")
    .userTaskMinimumTriggerIntervalInSeconds(0)
    .userTaskTimeoutMs(0)
    .withManagedAccess("string")
    .build());
Copy
schema_resource = snowflake.Schema("schemaResource",
    database="string",
    name="string",
    quoted_identifiers_ignore_case=False,
    comment="string",
    default_ddl_collation="string",
    enable_console_output=False,
    external_volume="string",
    is_transient="string",
    log_level="string",
    max_data_extension_time_in_days=0,
    catalog="string",
    data_retention_time_in_days=0,
    replace_invalid_characters=False,
    pipe_execution_paused=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,
    with_managed_access="string")
Copy
const schemaResource = new snowflake.Schema("schemaResource", {
    database: "string",
    name: "string",
    quotedIdentifiersIgnoreCase: false,
    comment: "string",
    defaultDdlCollation: "string",
    enableConsoleOutput: false,
    externalVolume: "string",
    isTransient: "string",
    logLevel: "string",
    maxDataExtensionTimeInDays: 0,
    catalog: "string",
    dataRetentionTimeInDays: 0,
    replaceInvalidCharacters: false,
    pipeExecutionPaused: false,
    storageSerializationPolicy: "string",
    suspendTaskAfterNumFailures: 0,
    taskAutoRetryAttempts: 0,
    traceLevel: "string",
    userTaskManagedInitialWarehouseSize: "string",
    userTaskMinimumTriggerIntervalInSeconds: 0,
    userTaskTimeoutMs: 0,
    withManagedAccess: "string",
});
Copy
type: snowflake:Schema
properties:
    catalog: string
    comment: string
    dataRetentionTimeInDays: 0
    database: string
    defaultDdlCollation: string
    enableConsoleOutput: false
    externalVolume: string
    isTransient: string
    logLevel: string
    maxDataExtensionTimeInDays: 0
    name: string
    pipeExecutionPaused: false
    quotedIdentifiersIgnoreCase: false
    replaceInvalidCharacters: false
    storageSerializationPolicy: string
    suspendTaskAfterNumFailures: 0
    taskAutoRetryAttempts: 0
    traceLevel: string
    userTaskManagedInitialWarehouseSize: string
    userTaskMinimumTriggerIntervalInSeconds: 0
    userTaskTimeoutMs: 0
    withManagedAccess: string
Copy

Schema Resource Properties

To learn more about resource properties and how to use them, see Inputs and Outputs in the Architecture and Concepts docs.

Inputs

In Python, inputs that are objects can be passed either as argument classes or as dictionary literals.

The Schema resource accepts the following input properties:

Database
This property is required.
Changes to this property will trigger replacement.
string
The database in which to create the schema. Due to technical limitations (read more here), avoid using the following characters: |, ., ".
Catalog string
The database parameter that specifies the default catalog to use for Iceberg tables. For more information, see CATALOG.
Comment string
Specifies a comment for the schema.
DataRetentionTimeInDays int
Specifies the number of days for which Time Travel actions (CLONE and UNDROP) can be performed on the database, as well as specifying the default Time Travel retention time for all schemas created in the database. For more details, see Understanding & Using Time Travel.
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.
EnableConsoleOutput bool
If true, enables stdout/stderr fast path logging for anonymous stored procedures.
ExternalVolume string
The database parameter that specifies the default external volume to use for Iceberg tables. For more information, see EXTERNAL_VOLUME.
IsTransient Changes to this property will trigger replacement. string
(Default: fallback to Snowflake default - uses special value that cannot be set in the configuration manually (default)) Specifies the schema as transient. Transient schemas do not have a Fail-safe period so they do not incur additional storage costs once they leave Time Travel; however, this means they are also not protected by Fail-safe in the event of a data loss. Available options are: "true" or "false". When the value is not set in the configuration the provider will put "default" there which means to use the Snowflake default for this value.
LogLevel string
Specifies the severity level of messages that should be ingested and made available in the active event table. Valid options are: [TRACE DEBUG INFO WARN ERROR FATAL OFF]. Messages at the specified level (and at more severe levels) are ingested. For more information, see LOG_LEVEL.
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 a detailed description of this parameter, see MAXDATAEXTENSIONTIMEIN_DAYS.
Name string
Specifies the identifier for the schema; must be unique for the database in which the schema is created. When the name is PUBLIC, during creation the provider checks if this schema has already been created and, in such case, ALTER is used to match the desired state. Due to technical limitations (read more here), avoid using the following characters: |, ., ".
PipeExecutionPaused bool
Specifies whether to pause a running pipe, primarily in preparation for transferring ownership of the pipe to a different role. For more information, check PIPEEXECUTIONPAUSED docs.
QuotedIdentifiersIgnoreCase bool
If true, the case of quoted identifiers is ignored. For more information, see QUOTEDIDENTIFIERSIGNORE_CASE.
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, see REPLACEINVALIDCHARACTERS.
StorageSerializationPolicy string
The storage serialization policy for Iceberg tables that use Snowflake as the catalog. Valid options are: [COMPATIBLE OPTIMIZED]. 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. For more information, see STORAGESERIALIZATIONPOLICY.
SuspendTaskAfterNumFailures int
How many times a task must fail in a row before it is automatically suspended. 0 disables auto-suspending. For more information, see SUSPENDTASKAFTERNUMFAILURES.
TaskAutoRetryAttempts int
Maximum automatic retries allowed for a user task. For more information, see TASKAUTORETRY_ATTEMPTS.
TraceLevel string
Controls how trace events are ingested into the event table. Valid options are: [ALWAYS ON*EVENT OFF]. For information about levels, see TRACE*LEVEL.
UserTaskManagedInitialWarehouseSize string
The initial size of warehouse to use for managed warehouses in the absence of history. For more information, see USERTASKMANAGEDINITIALWAREHOUSE_SIZE.
UserTaskMinimumTriggerIntervalInSeconds int
Minimum amount of time between Triggered Task executions in seconds.
UserTaskTimeoutMs int
User task execution timeout in milliseconds. For more information, see USERTASKTIMEOUT_MS.
WithManagedAccess string
(Default: fallback to Snowflake default - uses special value that cannot be set in the configuration manually (default)) Specifies a managed schema. Managed access schemas centralize privilege management with the schema owner. Available options are: "true" or "false". When the value is not set in the configuration the provider will put "default" there which means to use the Snowflake default for this value.
Database
This property is required.
Changes to this property will trigger replacement.
string
The database in which to create the schema. Due to technical limitations (read more here), avoid using the following characters: |, ., ".
Catalog string
The database parameter that specifies the default catalog to use for Iceberg tables. For more information, see CATALOG.
Comment string
Specifies a comment for the schema.
DataRetentionTimeInDays int
Specifies the number of days for which Time Travel actions (CLONE and UNDROP) can be performed on the database, as well as specifying the default Time Travel retention time for all schemas created in the database. For more details, see Understanding & Using Time Travel.
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.
EnableConsoleOutput bool
If true, enables stdout/stderr fast path logging for anonymous stored procedures.
ExternalVolume string
The database parameter that specifies the default external volume to use for Iceberg tables. For more information, see EXTERNAL_VOLUME.
IsTransient Changes to this property will trigger replacement. string
(Default: fallback to Snowflake default - uses special value that cannot be set in the configuration manually (default)) Specifies the schema as transient. Transient schemas do not have a Fail-safe period so they do not incur additional storage costs once they leave Time Travel; however, this means they are also not protected by Fail-safe in the event of a data loss. Available options are: "true" or "false". When the value is not set in the configuration the provider will put "default" there which means to use the Snowflake default for this value.
LogLevel string
Specifies the severity level of messages that should be ingested and made available in the active event table. Valid options are: [TRACE DEBUG INFO WARN ERROR FATAL OFF]. Messages at the specified level (and at more severe levels) are ingested. For more information, see LOG_LEVEL.
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 a detailed description of this parameter, see MAXDATAEXTENSIONTIMEIN_DAYS.
Name string
Specifies the identifier for the schema; must be unique for the database in which the schema is created. When the name is PUBLIC, during creation the provider checks if this schema has already been created and, in such case, ALTER is used to match the desired state. Due to technical limitations (read more here), avoid using the following characters: |, ., ".
PipeExecutionPaused bool
Specifies whether to pause a running pipe, primarily in preparation for transferring ownership of the pipe to a different role. For more information, check PIPEEXECUTIONPAUSED docs.
QuotedIdentifiersIgnoreCase bool
If true, the case of quoted identifiers is ignored. For more information, see QUOTEDIDENTIFIERSIGNORE_CASE.
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, see REPLACEINVALIDCHARACTERS.
StorageSerializationPolicy string
The storage serialization policy for Iceberg tables that use Snowflake as the catalog. Valid options are: [COMPATIBLE OPTIMIZED]. 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. For more information, see STORAGESERIALIZATIONPOLICY.
SuspendTaskAfterNumFailures int
How many times a task must fail in a row before it is automatically suspended. 0 disables auto-suspending. For more information, see SUSPENDTASKAFTERNUMFAILURES.
TaskAutoRetryAttempts int
Maximum automatic retries allowed for a user task. For more information, see TASKAUTORETRY_ATTEMPTS.
TraceLevel string
Controls how trace events are ingested into the event table. Valid options are: [ALWAYS ON*EVENT OFF]. For information about levels, see TRACE*LEVEL.
UserTaskManagedInitialWarehouseSize string
The initial size of warehouse to use for managed warehouses in the absence of history. For more information, see USERTASKMANAGEDINITIALWAREHOUSE_SIZE.
UserTaskMinimumTriggerIntervalInSeconds int
Minimum amount of time between Triggered Task executions in seconds.
UserTaskTimeoutMs int
User task execution timeout in milliseconds. For more information, see USERTASKTIMEOUT_MS.
WithManagedAccess string
(Default: fallback to Snowflake default - uses special value that cannot be set in the configuration manually (default)) Specifies a managed schema. Managed access schemas centralize privilege management with the schema owner. Available options are: "true" or "false". When the value is not set in the configuration the provider will put "default" there which means to use the Snowflake default for this value.
database
This property is required.
Changes to this property will trigger replacement.
String
The database in which to create the schema. Due to technical limitations (read more here), avoid using the following characters: |, ., ".
catalog String
The database parameter that specifies the default catalog to use for Iceberg tables. For more information, see CATALOG.
comment String
Specifies a comment for the schema.
dataRetentionTimeInDays Integer
Specifies the number of days for which Time Travel actions (CLONE and UNDROP) can be performed on the database, as well as specifying the default Time Travel retention time for all schemas created in the database. For more details, see Understanding & Using Time Travel.
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.
enableConsoleOutput Boolean
If true, enables stdout/stderr fast path logging for anonymous stored procedures.
externalVolume String
The database parameter that specifies the default external volume to use for Iceberg tables. For more information, see EXTERNAL_VOLUME.
isTransient Changes to this property will trigger replacement. String
(Default: fallback to Snowflake default - uses special value that cannot be set in the configuration manually (default)) Specifies the schema as transient. Transient schemas do not have a Fail-safe period so they do not incur additional storage costs once they leave Time Travel; however, this means they are also not protected by Fail-safe in the event of a data loss. Available options are: "true" or "false". When the value is not set in the configuration the provider will put "default" there which means to use the Snowflake default for this value.
logLevel String
Specifies the severity level of messages that should be ingested and made available in the active event table. Valid options are: [TRACE DEBUG INFO WARN ERROR FATAL OFF]. Messages at the specified level (and at more severe levels) are ingested. For more information, see LOG_LEVEL.
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 a detailed description of this parameter, see MAXDATAEXTENSIONTIMEIN_DAYS.
name String
Specifies the identifier for the schema; must be unique for the database in which the schema is created. When the name is PUBLIC, during creation the provider checks if this schema has already been created and, in such case, ALTER is used to match the desired state. Due to technical limitations (read more here), avoid using the following characters: |, ., ".
pipeExecutionPaused Boolean
Specifies whether to pause a running pipe, primarily in preparation for transferring ownership of the pipe to a different role. For more information, check PIPEEXECUTIONPAUSED docs.
quotedIdentifiersIgnoreCase Boolean
If true, the case of quoted identifiers is ignored. For more information, see QUOTEDIDENTIFIERSIGNORE_CASE.
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, see REPLACEINVALIDCHARACTERS.
storageSerializationPolicy String
The storage serialization policy for Iceberg tables that use Snowflake as the catalog. Valid options are: [COMPATIBLE OPTIMIZED]. 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. For more information, see STORAGESERIALIZATIONPOLICY.
suspendTaskAfterNumFailures Integer
How many times a task must fail in a row before it is automatically suspended. 0 disables auto-suspending. For more information, see SUSPENDTASKAFTERNUMFAILURES.
taskAutoRetryAttempts Integer
Maximum automatic retries allowed for a user task. For more information, see TASKAUTORETRY_ATTEMPTS.
traceLevel String
Controls how trace events are ingested into the event table. Valid options are: [ALWAYS ON*EVENT OFF]. For information about levels, see TRACE*LEVEL.
userTaskManagedInitialWarehouseSize String
The initial size of warehouse to use for managed warehouses in the absence of history. For more information, see USERTASKMANAGEDINITIALWAREHOUSE_SIZE.
userTaskMinimumTriggerIntervalInSeconds Integer
Minimum amount of time between Triggered Task executions in seconds.
userTaskTimeoutMs Integer
User task execution timeout in milliseconds. For more information, see USERTASKTIMEOUT_MS.
withManagedAccess String
(Default: fallback to Snowflake default - uses special value that cannot be set in the configuration manually (default)) Specifies a managed schema. Managed access schemas centralize privilege management with the schema owner. Available options are: "true" or "false". When the value is not set in the configuration the provider will put "default" there which means to use the Snowflake default for this value.
database
This property is required.
Changes to this property will trigger replacement.
string
The database in which to create the schema. Due to technical limitations (read more here), avoid using the following characters: |, ., ".
catalog string
The database parameter that specifies the default catalog to use for Iceberg tables. For more information, see CATALOG.
comment string
Specifies a comment for the schema.
dataRetentionTimeInDays number
Specifies the number of days for which Time Travel actions (CLONE and UNDROP) can be performed on the database, as well as specifying the default Time Travel retention time for all schemas created in the database. For more details, see Understanding & Using Time Travel.
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.
enableConsoleOutput boolean
If true, enables stdout/stderr fast path logging for anonymous stored procedures.
externalVolume string
The database parameter that specifies the default external volume to use for Iceberg tables. For more information, see EXTERNAL_VOLUME.
isTransient Changes to this property will trigger replacement. string
(Default: fallback to Snowflake default - uses special value that cannot be set in the configuration manually (default)) Specifies the schema as transient. Transient schemas do not have a Fail-safe period so they do not incur additional storage costs once they leave Time Travel; however, this means they are also not protected by Fail-safe in the event of a data loss. Available options are: "true" or "false". When the value is not set in the configuration the provider will put "default" there which means to use the Snowflake default for this value.
logLevel string
Specifies the severity level of messages that should be ingested and made available in the active event table. Valid options are: [TRACE DEBUG INFO WARN ERROR FATAL OFF]. Messages at the specified level (and at more severe levels) are ingested. For more information, see LOG_LEVEL.
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 a detailed description of this parameter, see MAXDATAEXTENSIONTIMEIN_DAYS.
name string
Specifies the identifier for the schema; must be unique for the database in which the schema is created. When the name is PUBLIC, during creation the provider checks if this schema has already been created and, in such case, ALTER is used to match the desired state. Due to technical limitations (read more here), avoid using the following characters: |, ., ".
pipeExecutionPaused boolean
Specifies whether to pause a running pipe, primarily in preparation for transferring ownership of the pipe to a different role. For more information, check PIPEEXECUTIONPAUSED docs.
quotedIdentifiersIgnoreCase boolean
If true, the case of quoted identifiers is ignored. For more information, see QUOTEDIDENTIFIERSIGNORE_CASE.
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, see REPLACEINVALIDCHARACTERS.
storageSerializationPolicy string
The storage serialization policy for Iceberg tables that use Snowflake as the catalog. Valid options are: [COMPATIBLE OPTIMIZED]. 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. For more information, see STORAGESERIALIZATIONPOLICY.
suspendTaskAfterNumFailures number
How many times a task must fail in a row before it is automatically suspended. 0 disables auto-suspending. For more information, see SUSPENDTASKAFTERNUMFAILURES.
taskAutoRetryAttempts number
Maximum automatic retries allowed for a user task. For more information, see TASKAUTORETRY_ATTEMPTS.
traceLevel string
Controls how trace events are ingested into the event table. Valid options are: [ALWAYS ON*EVENT OFF]. For information about levels, see TRACE*LEVEL.
userTaskManagedInitialWarehouseSize string
The initial size of warehouse to use for managed warehouses in the absence of history. For more information, see USERTASKMANAGEDINITIALWAREHOUSE_SIZE.
userTaskMinimumTriggerIntervalInSeconds number
Minimum amount of time between Triggered Task executions in seconds.
userTaskTimeoutMs number
User task execution timeout in milliseconds. For more information, see USERTASKTIMEOUT_MS.
withManagedAccess string
(Default: fallback to Snowflake default - uses special value that cannot be set in the configuration manually (default)) Specifies a managed schema. Managed access schemas centralize privilege management with the schema owner. Available options are: "true" or "false". When the value is not set in the configuration the provider will put "default" there which means to use the Snowflake default for this value.
database
This property is required.
Changes to this property will trigger replacement.
str
The database in which to create the schema. Due to technical limitations (read more here), avoid using the following characters: |, ., ".
catalog str
The database parameter that specifies the default catalog to use for Iceberg tables. For more information, see CATALOG.
comment str
Specifies a comment for the schema.
data_retention_time_in_days int
Specifies the number of days for which Time Travel actions (CLONE and UNDROP) can be performed on the database, as well as specifying the default Time Travel retention time for all schemas created in the database. For more details, see Understanding & Using Time Travel.
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.
enable_console_output bool
If true, enables stdout/stderr fast path logging for anonymous stored procedures.
external_volume str
The database parameter that specifies the default external volume to use for Iceberg tables. For more information, see EXTERNAL_VOLUME.
is_transient Changes to this property will trigger replacement. str
(Default: fallback to Snowflake default - uses special value that cannot be set in the configuration manually (default)) Specifies the schema as transient. Transient schemas do not have a Fail-safe period so they do not incur additional storage costs once they leave Time Travel; however, this means they are also not protected by Fail-safe in the event of a data loss. Available options are: "true" or "false". When the value is not set in the configuration the provider will put "default" there which means to use the Snowflake default for this value.
log_level str
Specifies the severity level of messages that should be ingested and made available in the active event table. Valid options are: [TRACE DEBUG INFO WARN ERROR FATAL OFF]. Messages at the specified level (and at more severe levels) are ingested. For more information, see LOG_LEVEL.
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 a detailed description of this parameter, see MAXDATAEXTENSIONTIMEIN_DAYS.
name str
Specifies the identifier for the schema; must be unique for the database in which the schema is created. When the name is PUBLIC, during creation the provider checks if this schema has already been created and, in such case, ALTER is used to match the desired state. Due to technical limitations (read more here), avoid using the following characters: |, ., ".
pipe_execution_paused bool
Specifies whether to pause a running pipe, primarily in preparation for transferring ownership of the pipe to a different role. For more information, check PIPEEXECUTIONPAUSED docs.
quoted_identifiers_ignore_case bool
If true, the case of quoted identifiers is ignored. For more information, see QUOTEDIDENTIFIERSIGNORE_CASE.
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, see REPLACEINVALIDCHARACTERS.
storage_serialization_policy str
The storage serialization policy for Iceberg tables that use Snowflake as the catalog. Valid options are: [COMPATIBLE OPTIMIZED]. 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. For more information, see STORAGESERIALIZATIONPOLICY.
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, see SUSPENDTASKAFTERNUMFAILURES.
task_auto_retry_attempts int
Maximum automatic retries allowed for a user task. For more information, see TASKAUTORETRY_ATTEMPTS.
trace_level str
Controls how trace events are ingested into the event table. Valid options are: [ALWAYS ON*EVENT OFF]. For information about levels, see TRACE*LEVEL.
user_task_managed_initial_warehouse_size str
The initial size of warehouse to use for managed warehouses in the absence of history. For more information, see USERTASKMANAGEDINITIALWAREHOUSE_SIZE.
user_task_minimum_trigger_interval_in_seconds int
Minimum amount of time between Triggered Task executions in seconds.
user_task_timeout_ms int
User task execution timeout in milliseconds. For more information, see USERTASKTIMEOUT_MS.
with_managed_access str
(Default: fallback to Snowflake default - uses special value that cannot be set in the configuration manually (default)) Specifies a managed schema. Managed access schemas centralize privilege management with the schema owner. Available options are: "true" or "false". When the value is not set in the configuration the provider will put "default" there which means to use the Snowflake default for this value.
database
This property is required.
Changes to this property will trigger replacement.
String
The database in which to create the schema. Due to technical limitations (read more here), avoid using the following characters: |, ., ".
catalog String
The database parameter that specifies the default catalog to use for Iceberg tables. For more information, see CATALOG.
comment String
Specifies a comment for the schema.
dataRetentionTimeInDays Number
Specifies the number of days for which Time Travel actions (CLONE and UNDROP) can be performed on the database, as well as specifying the default Time Travel retention time for all schemas created in the database. For more details, see Understanding & Using Time Travel.
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.
enableConsoleOutput Boolean
If true, enables stdout/stderr fast path logging for anonymous stored procedures.
externalVolume String
The database parameter that specifies the default external volume to use for Iceberg tables. For more information, see EXTERNAL_VOLUME.
isTransient Changes to this property will trigger replacement. String
(Default: fallback to Snowflake default - uses special value that cannot be set in the configuration manually (default)) Specifies the schema as transient. Transient schemas do not have a Fail-safe period so they do not incur additional storage costs once they leave Time Travel; however, this means they are also not protected by Fail-safe in the event of a data loss. Available options are: "true" or "false". When the value is not set in the configuration the provider will put "default" there which means to use the Snowflake default for this value.
logLevel String
Specifies the severity level of messages that should be ingested and made available in the active event table. Valid options are: [TRACE DEBUG INFO WARN ERROR FATAL OFF]. Messages at the specified level (and at more severe levels) are ingested. For more information, see LOG_LEVEL.
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 a detailed description of this parameter, see MAXDATAEXTENSIONTIMEIN_DAYS.
name String
Specifies the identifier for the schema; must be unique for the database in which the schema is created. When the name is PUBLIC, during creation the provider checks if this schema has already been created and, in such case, ALTER is used to match the desired state. Due to technical limitations (read more here), avoid using the following characters: |, ., ".
pipeExecutionPaused Boolean
Specifies whether to pause a running pipe, primarily in preparation for transferring ownership of the pipe to a different role. For more information, check PIPEEXECUTIONPAUSED docs.
quotedIdentifiersIgnoreCase Boolean
If true, the case of quoted identifiers is ignored. For more information, see QUOTEDIDENTIFIERSIGNORE_CASE.
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, see REPLACEINVALIDCHARACTERS.
storageSerializationPolicy String
The storage serialization policy for Iceberg tables that use Snowflake as the catalog. Valid options are: [COMPATIBLE OPTIMIZED]. 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. For more information, see STORAGESERIALIZATIONPOLICY.
suspendTaskAfterNumFailures Number
How many times a task must fail in a row before it is automatically suspended. 0 disables auto-suspending. For more information, see SUSPENDTASKAFTERNUMFAILURES.
taskAutoRetryAttempts Number
Maximum automatic retries allowed for a user task. For more information, see TASKAUTORETRY_ATTEMPTS.
traceLevel String
Controls how trace events are ingested into the event table. Valid options are: [ALWAYS ON*EVENT OFF]. For information about levels, see TRACE*LEVEL.
userTaskManagedInitialWarehouseSize String
The initial size of warehouse to use for managed warehouses in the absence of history. For more information, see USERTASKMANAGEDINITIALWAREHOUSE_SIZE.
userTaskMinimumTriggerIntervalInSeconds Number
Minimum amount of time between Triggered Task executions in seconds.
userTaskTimeoutMs Number
User task execution timeout in milliseconds. For more information, see USERTASKTIMEOUT_MS.
withManagedAccess String
(Default: fallback to Snowflake default - uses special value that cannot be set in the configuration manually (default)) Specifies a managed schema. Managed access schemas centralize privilege management with the schema owner. Available options are: "true" or "false". When the value is not set in the configuration the provider will put "default" there which means to use the Snowflake default for this value.

Outputs

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

DescribeOutputs List<SchemaDescribeOutput>
Outputs the result of DESCRIBE SCHEMA for the given object. In order to handle this output, one must grant sufficient privileges, e.g. grant_ownership on all objects in the schema.
FullyQualifiedName string
Fully qualified name of the resource. For more information, see object name resolution.
Id string
The provider-assigned unique ID for this managed resource.
Parameters List<SchemaParameter>
Outputs the result of SHOW PARAMETERS IN SCHEMA for the given object.
ShowOutputs List<SchemaShowOutput>
Outputs the result of SHOW SCHEMA for the given object.
DescribeOutputs []SchemaDescribeOutput
Outputs the result of DESCRIBE SCHEMA for the given object. In order to handle this output, one must grant sufficient privileges, e.g. grant_ownership on all objects in the schema.
FullyQualifiedName string
Fully qualified name of the resource. For more information, see object name resolution.
Id string
The provider-assigned unique ID for this managed resource.
Parameters []SchemaParameter
Outputs the result of SHOW PARAMETERS IN SCHEMA for the given object.
ShowOutputs []SchemaShowOutput
Outputs the result of SHOW SCHEMA for the given object.
describeOutputs List<SchemaDescribeOutput>
Outputs the result of DESCRIBE SCHEMA for the given object. In order to handle this output, one must grant sufficient privileges, e.g. grant_ownership on all objects in the schema.
fullyQualifiedName String
Fully qualified name of the resource. For more information, see object name resolution.
id String
The provider-assigned unique ID for this managed resource.
parameters List<SchemaParameter>
Outputs the result of SHOW PARAMETERS IN SCHEMA for the given object.
showOutputs List<SchemaShowOutput>
Outputs the result of SHOW SCHEMA for the given object.
describeOutputs SchemaDescribeOutput[]
Outputs the result of DESCRIBE SCHEMA for the given object. In order to handle this output, one must grant sufficient privileges, e.g. grant_ownership on all objects in the schema.
fullyQualifiedName string
Fully qualified name of the resource. For more information, see object name resolution.
id string
The provider-assigned unique ID for this managed resource.
parameters SchemaParameter[]
Outputs the result of SHOW PARAMETERS IN SCHEMA for the given object.
showOutputs SchemaShowOutput[]
Outputs the result of SHOW SCHEMA for the given object.
describe_outputs Sequence[SchemaDescribeOutput]
Outputs the result of DESCRIBE SCHEMA for the given object. In order to handle this output, one must grant sufficient privileges, e.g. grant_ownership on all objects in the schema.
fully_qualified_name str
Fully qualified name of the resource. For more information, see object name resolution.
id str
The provider-assigned unique ID for this managed resource.
parameters Sequence[SchemaParameter]
Outputs the result of SHOW PARAMETERS IN SCHEMA for the given object.
show_outputs Sequence[SchemaShowOutput]
Outputs the result of SHOW SCHEMA for the given object.
describeOutputs List<Property Map>
Outputs the result of DESCRIBE SCHEMA for the given object. In order to handle this output, one must grant sufficient privileges, e.g. grant_ownership on all objects in the schema.
fullyQualifiedName String
Fully qualified name of the resource. For more information, see object name resolution.
id String
The provider-assigned unique ID for this managed resource.
parameters List<Property Map>
Outputs the result of SHOW PARAMETERS IN SCHEMA for the given object.
showOutputs List<Property Map>
Outputs the result of SHOW SCHEMA for the given object.

Look up Existing Schema Resource

Get an existing Schema resource’s state with the given name, ID, and optional extra properties used to qualify the lookup.

public static get(name: string, id: Input<ID>, state?: SchemaState, opts?: CustomResourceOptions): Schema
@staticmethod
def get(resource_name: str,
        id: str,
        opts: Optional[ResourceOptions] = None,
        catalog: Optional[str] = None,
        comment: Optional[str] = None,
        data_retention_time_in_days: Optional[int] = None,
        database: Optional[str] = None,
        default_ddl_collation: Optional[str] = None,
        describe_outputs: Optional[Sequence[SchemaDescribeOutputArgs]] = None,
        enable_console_output: Optional[bool] = None,
        external_volume: Optional[str] = None,
        fully_qualified_name: Optional[str] = None,
        is_transient: Optional[str] = None,
        log_level: Optional[str] = None,
        max_data_extension_time_in_days: Optional[int] = None,
        name: Optional[str] = None,
        parameters: Optional[Sequence[SchemaParameterArgs]] = None,
        pipe_execution_paused: Optional[bool] = None,
        quoted_identifiers_ignore_case: Optional[bool] = None,
        replace_invalid_characters: Optional[bool] = None,
        show_outputs: Optional[Sequence[SchemaShowOutputArgs]] = None,
        storage_serialization_policy: Optional[str] = None,
        suspend_task_after_num_failures: Optional[int] = None,
        task_auto_retry_attempts: Optional[int] = None,
        trace_level: Optional[str] = None,
        user_task_managed_initial_warehouse_size: Optional[str] = None,
        user_task_minimum_trigger_interval_in_seconds: Optional[int] = None,
        user_task_timeout_ms: Optional[int] = None,
        with_managed_access: Optional[str] = None) -> Schema
func GetSchema(ctx *Context, name string, id IDInput, state *SchemaState, opts ...ResourceOption) (*Schema, error)
public static Schema Get(string name, Input<string> id, SchemaState? state, CustomResourceOptions? opts = null)
public static Schema get(String name, Output<String> id, SchemaState state, CustomResourceOptions options)
resources:  _:    type: snowflake:Schema    get:      id: ${id}
name This property is required.
The unique name of the resulting resource.
id This property is required.
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 This property is required.
The unique name of the resulting resource.
id This property is required.
The unique provider ID of the resource to lookup.
name This property is required.
The unique name of the resulting resource.
id This property is required.
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 This property is required.
The unique name of the resulting resource.
id This property is required.
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 This property is required.
The unique name of the resulting resource.
id This property is required.
The unique provider ID of the resource to lookup.
state
Any extra arguments used during the lookup.
opts
A bag of options that control this resource's behavior.
The following state arguments are supported:
Catalog string
The database parameter that specifies the default catalog to use for Iceberg tables. For more information, see CATALOG.
Comment string
Specifies a comment for the schema.
DataRetentionTimeInDays int
Specifies the number of days for which Time Travel actions (CLONE and UNDROP) can be performed on the database, as well as specifying the default Time Travel retention time for all schemas created in the database. For more details, see Understanding & Using Time Travel.
Database Changes to this property will trigger replacement. string
The database in which to create the schema. Due to technical limitations (read more here), avoid using the following characters: |, ., ".
DefaultDdlCollation string
Specifies a default collation specification for all schemas and tables added to the database. It can be overridden on schema or table level. For more information, see collation specification.
DescribeOutputs List<SchemaDescribeOutput>
Outputs the result of DESCRIBE SCHEMA for the given object. In order to handle this output, one must grant sufficient privileges, e.g. grant_ownership on all objects in the schema.
EnableConsoleOutput bool
If true, enables stdout/stderr fast path logging for anonymous stored procedures.
ExternalVolume string
The database parameter that specifies the default external volume to use for Iceberg tables. For more information, see EXTERNAL_VOLUME.
FullyQualifiedName string
Fully qualified name of the resource. For more information, see object name resolution.
IsTransient Changes to this property will trigger replacement. string
(Default: fallback to Snowflake default - uses special value that cannot be set in the configuration manually (default)) Specifies the schema as transient. Transient schemas do not have a Fail-safe period so they do not incur additional storage costs once they leave Time Travel; however, this means they are also not protected by Fail-safe in the event of a data loss. Available options are: "true" or "false". When the value is not set in the configuration the provider will put "default" there which means to use the Snowflake default for this value.
LogLevel string
Specifies the severity level of messages that should be ingested and made available in the active event table. Valid options are: [TRACE DEBUG INFO WARN ERROR FATAL OFF]. Messages at the specified level (and at more severe levels) are ingested. For more information, see LOG_LEVEL.
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 a detailed description of this parameter, see MAXDATAEXTENSIONTIMEIN_DAYS.
Name string
Specifies the identifier for the schema; must be unique for the database in which the schema is created. When the name is PUBLIC, during creation the provider checks if this schema has already been created and, in such case, ALTER is used to match the desired state. Due to technical limitations (read more here), avoid using the following characters: |, ., ".
Parameters List<SchemaParameter>
Outputs the result of SHOW PARAMETERS IN SCHEMA for the given object.
PipeExecutionPaused bool
Specifies whether to pause a running pipe, primarily in preparation for transferring ownership of the pipe to a different role. For more information, check PIPEEXECUTIONPAUSED docs.
QuotedIdentifiersIgnoreCase bool
If true, the case of quoted identifiers is ignored. For more information, see QUOTEDIDENTIFIERSIGNORE_CASE.
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, see REPLACEINVALIDCHARACTERS.
ShowOutputs List<SchemaShowOutput>
Outputs the result of SHOW SCHEMA for the given object.
StorageSerializationPolicy string
The storage serialization policy for Iceberg tables that use Snowflake as the catalog. Valid options are: [COMPATIBLE OPTIMIZED]. 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. For more information, see STORAGESERIALIZATIONPOLICY.
SuspendTaskAfterNumFailures int
How many times a task must fail in a row before it is automatically suspended. 0 disables auto-suspending. For more information, see SUSPENDTASKAFTERNUMFAILURES.
TaskAutoRetryAttempts int
Maximum automatic retries allowed for a user task. For more information, see TASKAUTORETRY_ATTEMPTS.
TraceLevel string
Controls how trace events are ingested into the event table. Valid options are: [ALWAYS ON*EVENT OFF]. For information about levels, see TRACE*LEVEL.
UserTaskManagedInitialWarehouseSize string
The initial size of warehouse to use for managed warehouses in the absence of history. For more information, see USERTASKMANAGEDINITIALWAREHOUSE_SIZE.
UserTaskMinimumTriggerIntervalInSeconds int
Minimum amount of time between Triggered Task executions in seconds.
UserTaskTimeoutMs int
User task execution timeout in milliseconds. For more information, see USERTASKTIMEOUT_MS.
WithManagedAccess string
(Default: fallback to Snowflake default - uses special value that cannot be set in the configuration manually (default)) Specifies a managed schema. Managed access schemas centralize privilege management with the schema owner. Available options are: "true" or "false". When the value is not set in the configuration the provider will put "default" there which means to use the Snowflake default for this value.
Catalog string
The database parameter that specifies the default catalog to use for Iceberg tables. For more information, see CATALOG.
Comment string
Specifies a comment for the schema.
DataRetentionTimeInDays int
Specifies the number of days for which Time Travel actions (CLONE and UNDROP) can be performed on the database, as well as specifying the default Time Travel retention time for all schemas created in the database. For more details, see Understanding & Using Time Travel.
Database Changes to this property will trigger replacement. string
The database in which to create the schema. Due to technical limitations (read more here), avoid using the following characters: |, ., ".
DefaultDdlCollation string
Specifies a default collation specification for all schemas and tables added to the database. It can be overridden on schema or table level. For more information, see collation specification.
DescribeOutputs []SchemaDescribeOutputArgs
Outputs the result of DESCRIBE SCHEMA for the given object. In order to handle this output, one must grant sufficient privileges, e.g. grant_ownership on all objects in the schema.
EnableConsoleOutput bool
If true, enables stdout/stderr fast path logging for anonymous stored procedures.
ExternalVolume string
The database parameter that specifies the default external volume to use for Iceberg tables. For more information, see EXTERNAL_VOLUME.
FullyQualifiedName string
Fully qualified name of the resource. For more information, see object name resolution.
IsTransient Changes to this property will trigger replacement. string
(Default: fallback to Snowflake default - uses special value that cannot be set in the configuration manually (default)) Specifies the schema as transient. Transient schemas do not have a Fail-safe period so they do not incur additional storage costs once they leave Time Travel; however, this means they are also not protected by Fail-safe in the event of a data loss. Available options are: "true" or "false". When the value is not set in the configuration the provider will put "default" there which means to use the Snowflake default for this value.
LogLevel string
Specifies the severity level of messages that should be ingested and made available in the active event table. Valid options are: [TRACE DEBUG INFO WARN ERROR FATAL OFF]. Messages at the specified level (and at more severe levels) are ingested. For more information, see LOG_LEVEL.
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 a detailed description of this parameter, see MAXDATAEXTENSIONTIMEIN_DAYS.
Name string
Specifies the identifier for the schema; must be unique for the database in which the schema is created. When the name is PUBLIC, during creation the provider checks if this schema has already been created and, in such case, ALTER is used to match the desired state. Due to technical limitations (read more here), avoid using the following characters: |, ., ".
Parameters []SchemaParameterArgs
Outputs the result of SHOW PARAMETERS IN SCHEMA for the given object.
PipeExecutionPaused bool
Specifies whether to pause a running pipe, primarily in preparation for transferring ownership of the pipe to a different role. For more information, check PIPEEXECUTIONPAUSED docs.
QuotedIdentifiersIgnoreCase bool
If true, the case of quoted identifiers is ignored. For more information, see QUOTEDIDENTIFIERSIGNORE_CASE.
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, see REPLACEINVALIDCHARACTERS.
ShowOutputs []SchemaShowOutputArgs
Outputs the result of SHOW SCHEMA for the given object.
StorageSerializationPolicy string
The storage serialization policy for Iceberg tables that use Snowflake as the catalog. Valid options are: [COMPATIBLE OPTIMIZED]. 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. For more information, see STORAGESERIALIZATIONPOLICY.
SuspendTaskAfterNumFailures int
How many times a task must fail in a row before it is automatically suspended. 0 disables auto-suspending. For more information, see SUSPENDTASKAFTERNUMFAILURES.
TaskAutoRetryAttempts int
Maximum automatic retries allowed for a user task. For more information, see TASKAUTORETRY_ATTEMPTS.
TraceLevel string
Controls how trace events are ingested into the event table. Valid options are: [ALWAYS ON*EVENT OFF]. For information about levels, see TRACE*LEVEL.
UserTaskManagedInitialWarehouseSize string
The initial size of warehouse to use for managed warehouses in the absence of history. For more information, see USERTASKMANAGEDINITIALWAREHOUSE_SIZE.
UserTaskMinimumTriggerIntervalInSeconds int
Minimum amount of time between Triggered Task executions in seconds.
UserTaskTimeoutMs int
User task execution timeout in milliseconds. For more information, see USERTASKTIMEOUT_MS.
WithManagedAccess string
(Default: fallback to Snowflake default - uses special value that cannot be set in the configuration manually (default)) Specifies a managed schema. Managed access schemas centralize privilege management with the schema owner. Available options are: "true" or "false". When the value is not set in the configuration the provider will put "default" there which means to use the Snowflake default for this value.
catalog String
The database parameter that specifies the default catalog to use for Iceberg tables. For more information, see CATALOG.
comment String
Specifies a comment for the schema.
dataRetentionTimeInDays Integer
Specifies the number of days for which Time Travel actions (CLONE and UNDROP) can be performed on the database, as well as specifying the default Time Travel retention time for all schemas created in the database. For more details, see Understanding & Using Time Travel.
database Changes to this property will trigger replacement. String
The database in which to create the schema. Due to technical limitations (read more here), avoid using the following characters: |, ., ".
defaultDdlCollation String
Specifies a default collation specification for all schemas and tables added to the database. It can be overridden on schema or table level. For more information, see collation specification.
describeOutputs List<SchemaDescribeOutput>
Outputs the result of DESCRIBE SCHEMA for the given object. In order to handle this output, one must grant sufficient privileges, e.g. grant_ownership on all objects in the schema.
enableConsoleOutput Boolean
If true, enables stdout/stderr fast path logging for anonymous stored procedures.
externalVolume String
The database parameter that specifies the default external volume to use for Iceberg tables. For more information, see EXTERNAL_VOLUME.
fullyQualifiedName String
Fully qualified name of the resource. For more information, see object name resolution.
isTransient Changes to this property will trigger replacement. String
(Default: fallback to Snowflake default - uses special value that cannot be set in the configuration manually (default)) Specifies the schema as transient. Transient schemas do not have a Fail-safe period so they do not incur additional storage costs once they leave Time Travel; however, this means they are also not protected by Fail-safe in the event of a data loss. Available options are: "true" or "false". When the value is not set in the configuration the provider will put "default" there which means to use the Snowflake default for this value.
logLevel String
Specifies the severity level of messages that should be ingested and made available in the active event table. Valid options are: [TRACE DEBUG INFO WARN ERROR FATAL OFF]. Messages at the specified level (and at more severe levels) are ingested. For more information, see LOG_LEVEL.
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 a detailed description of this parameter, see MAXDATAEXTENSIONTIMEIN_DAYS.
name String
Specifies the identifier for the schema; must be unique for the database in which the schema is created. When the name is PUBLIC, during creation the provider checks if this schema has already been created and, in such case, ALTER is used to match the desired state. Due to technical limitations (read more here), avoid using the following characters: |, ., ".
parameters List<SchemaParameter>
Outputs the result of SHOW PARAMETERS IN SCHEMA for the given object.
pipeExecutionPaused Boolean
Specifies whether to pause a running pipe, primarily in preparation for transferring ownership of the pipe to a different role. For more information, check PIPEEXECUTIONPAUSED docs.
quotedIdentifiersIgnoreCase Boolean
If true, the case of quoted identifiers is ignored. For more information, see QUOTEDIDENTIFIERSIGNORE_CASE.
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, see REPLACEINVALIDCHARACTERS.
showOutputs List<SchemaShowOutput>
Outputs the result of SHOW SCHEMA for the given object.
storageSerializationPolicy String
The storage serialization policy for Iceberg tables that use Snowflake as the catalog. Valid options are: [COMPATIBLE OPTIMIZED]. 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. For more information, see STORAGESERIALIZATIONPOLICY.
suspendTaskAfterNumFailures Integer
How many times a task must fail in a row before it is automatically suspended. 0 disables auto-suspending. For more information, see SUSPENDTASKAFTERNUMFAILURES.
taskAutoRetryAttempts Integer
Maximum automatic retries allowed for a user task. For more information, see TASKAUTORETRY_ATTEMPTS.
traceLevel String
Controls how trace events are ingested into the event table. Valid options are: [ALWAYS ON*EVENT OFF]. For information about levels, see TRACE*LEVEL.
userTaskManagedInitialWarehouseSize String
The initial size of warehouse to use for managed warehouses in the absence of history. For more information, see USERTASKMANAGEDINITIALWAREHOUSE_SIZE.
userTaskMinimumTriggerIntervalInSeconds Integer
Minimum amount of time between Triggered Task executions in seconds.
userTaskTimeoutMs Integer
User task execution timeout in milliseconds. For more information, see USERTASKTIMEOUT_MS.
withManagedAccess String
(Default: fallback to Snowflake default - uses special value that cannot be set in the configuration manually (default)) Specifies a managed schema. Managed access schemas centralize privilege management with the schema owner. Available options are: "true" or "false". When the value is not set in the configuration the provider will put "default" there which means to use the Snowflake default for this value.
catalog string
The database parameter that specifies the default catalog to use for Iceberg tables. For more information, see CATALOG.
comment string
Specifies a comment for the schema.
dataRetentionTimeInDays number
Specifies the number of days for which Time Travel actions (CLONE and UNDROP) can be performed on the database, as well as specifying the default Time Travel retention time for all schemas created in the database. For more details, see Understanding & Using Time Travel.
database Changes to this property will trigger replacement. string
The database in which to create the schema. Due to technical limitations (read more here), avoid using the following characters: |, ., ".
defaultDdlCollation string
Specifies a default collation specification for all schemas and tables added to the database. It can be overridden on schema or table level. For more information, see collation specification.
describeOutputs SchemaDescribeOutput[]
Outputs the result of DESCRIBE SCHEMA for the given object. In order to handle this output, one must grant sufficient privileges, e.g. grant_ownership on all objects in the schema.
enableConsoleOutput boolean
If true, enables stdout/stderr fast path logging for anonymous stored procedures.
externalVolume string
The database parameter that specifies the default external volume to use for Iceberg tables. For more information, see EXTERNAL_VOLUME.
fullyQualifiedName string
Fully qualified name of the resource. For more information, see object name resolution.
isTransient Changes to this property will trigger replacement. string
(Default: fallback to Snowflake default - uses special value that cannot be set in the configuration manually (default)) Specifies the schema as transient. Transient schemas do not have a Fail-safe period so they do not incur additional storage costs once they leave Time Travel; however, this means they are also not protected by Fail-safe in the event of a data loss. Available options are: "true" or "false". When the value is not set in the configuration the provider will put "default" there which means to use the Snowflake default for this value.
logLevel string
Specifies the severity level of messages that should be ingested and made available in the active event table. Valid options are: [TRACE DEBUG INFO WARN ERROR FATAL OFF]. Messages at the specified level (and at more severe levels) are ingested. For more information, see LOG_LEVEL.
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 a detailed description of this parameter, see MAXDATAEXTENSIONTIMEIN_DAYS.
name string
Specifies the identifier for the schema; must be unique for the database in which the schema is created. When the name is PUBLIC, during creation the provider checks if this schema has already been created and, in such case, ALTER is used to match the desired state. Due to technical limitations (read more here), avoid using the following characters: |, ., ".
parameters SchemaParameter[]
Outputs the result of SHOW PARAMETERS IN SCHEMA for the given object.
pipeExecutionPaused boolean
Specifies whether to pause a running pipe, primarily in preparation for transferring ownership of the pipe to a different role. For more information, check PIPEEXECUTIONPAUSED docs.
quotedIdentifiersIgnoreCase boolean
If true, the case of quoted identifiers is ignored. For more information, see QUOTEDIDENTIFIERSIGNORE_CASE.
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, see REPLACEINVALIDCHARACTERS.
showOutputs SchemaShowOutput[]
Outputs the result of SHOW SCHEMA for the given object.
storageSerializationPolicy string
The storage serialization policy for Iceberg tables that use Snowflake as the catalog. Valid options are: [COMPATIBLE OPTIMIZED]. 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. For more information, see STORAGESERIALIZATIONPOLICY.
suspendTaskAfterNumFailures number
How many times a task must fail in a row before it is automatically suspended. 0 disables auto-suspending. For more information, see SUSPENDTASKAFTERNUMFAILURES.
taskAutoRetryAttempts number
Maximum automatic retries allowed for a user task. For more information, see TASKAUTORETRY_ATTEMPTS.
traceLevel string
Controls how trace events are ingested into the event table. Valid options are: [ALWAYS ON*EVENT OFF]. For information about levels, see TRACE*LEVEL.
userTaskManagedInitialWarehouseSize string
The initial size of warehouse to use for managed warehouses in the absence of history. For more information, see USERTASKMANAGEDINITIALWAREHOUSE_SIZE.
userTaskMinimumTriggerIntervalInSeconds number
Minimum amount of time between Triggered Task executions in seconds.
userTaskTimeoutMs number
User task execution timeout in milliseconds. For more information, see USERTASKTIMEOUT_MS.
withManagedAccess string
(Default: fallback to Snowflake default - uses special value that cannot be set in the configuration manually (default)) Specifies a managed schema. Managed access schemas centralize privilege management with the schema owner. Available options are: "true" or "false". When the value is not set in the configuration the provider will put "default" there which means to use the Snowflake default for this value.
catalog str
The database parameter that specifies the default catalog to use for Iceberg tables. For more information, see CATALOG.
comment str
Specifies a comment for the schema.
data_retention_time_in_days int
Specifies the number of days for which Time Travel actions (CLONE and UNDROP) can be performed on the database, as well as specifying the default Time Travel retention time for all schemas created in the database. For more details, see Understanding & Using Time Travel.
database Changes to this property will trigger replacement. str
The database in which to create the schema. Due to technical limitations (read more here), avoid using the following characters: |, ., ".
default_ddl_collation str
Specifies a default collation specification for all schemas and tables added to the database. It can be overridden on schema or table level. For more information, see collation specification.
describe_outputs Sequence[SchemaDescribeOutputArgs]
Outputs the result of DESCRIBE SCHEMA for the given object. In order to handle this output, one must grant sufficient privileges, e.g. grant_ownership on all objects in the schema.
enable_console_output bool
If true, enables stdout/stderr fast path logging for anonymous stored procedures.
external_volume str
The database parameter that specifies the default external volume to use for Iceberg tables. For more information, see EXTERNAL_VOLUME.
fully_qualified_name str
Fully qualified name of the resource. For more information, see object name resolution.
is_transient Changes to this property will trigger replacement. str
(Default: fallback to Snowflake default - uses special value that cannot be set in the configuration manually (default)) Specifies the schema as transient. Transient schemas do not have a Fail-safe period so they do not incur additional storage costs once they leave Time Travel; however, this means they are also not protected by Fail-safe in the event of a data loss. Available options are: "true" or "false". When the value is not set in the configuration the provider will put "default" there which means to use the Snowflake default for this value.
log_level str
Specifies the severity level of messages that should be ingested and made available in the active event table. Valid options are: [TRACE DEBUG INFO WARN ERROR FATAL OFF]. Messages at the specified level (and at more severe levels) are ingested. For more information, see LOG_LEVEL.
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 a detailed description of this parameter, see MAXDATAEXTENSIONTIMEIN_DAYS.
name str
Specifies the identifier for the schema; must be unique for the database in which the schema is created. When the name is PUBLIC, during creation the provider checks if this schema has already been created and, in such case, ALTER is used to match the desired state. Due to technical limitations (read more here), avoid using the following characters: |, ., ".
parameters Sequence[SchemaParameterArgs]
Outputs the result of SHOW PARAMETERS IN SCHEMA for the given object.
pipe_execution_paused bool
Specifies whether to pause a running pipe, primarily in preparation for transferring ownership of the pipe to a different role. For more information, check PIPEEXECUTIONPAUSED docs.
quoted_identifiers_ignore_case bool
If true, the case of quoted identifiers is ignored. For more information, see QUOTEDIDENTIFIERSIGNORE_CASE.
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, see REPLACEINVALIDCHARACTERS.
show_outputs Sequence[SchemaShowOutputArgs]
Outputs the result of SHOW SCHEMA for the given object.
storage_serialization_policy str
The storage serialization policy for Iceberg tables that use Snowflake as the catalog. Valid options are: [COMPATIBLE OPTIMIZED]. 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. For more information, see STORAGESERIALIZATIONPOLICY.
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, see SUSPENDTASKAFTERNUMFAILURES.
task_auto_retry_attempts int
Maximum automatic retries allowed for a user task. For more information, see TASKAUTORETRY_ATTEMPTS.
trace_level str
Controls how trace events are ingested into the event table. Valid options are: [ALWAYS ON*EVENT OFF]. For information about levels, see TRACE*LEVEL.
user_task_managed_initial_warehouse_size str
The initial size of warehouse to use for managed warehouses in the absence of history. For more information, see USERTASKMANAGEDINITIALWAREHOUSE_SIZE.
user_task_minimum_trigger_interval_in_seconds int
Minimum amount of time between Triggered Task executions in seconds.
user_task_timeout_ms int
User task execution timeout in milliseconds. For more information, see USERTASKTIMEOUT_MS.
with_managed_access str
(Default: fallback to Snowflake default - uses special value that cannot be set in the configuration manually (default)) Specifies a managed schema. Managed access schemas centralize privilege management with the schema owner. Available options are: "true" or "false". When the value is not set in the configuration the provider will put "default" there which means to use the Snowflake default for this value.
catalog String
The database parameter that specifies the default catalog to use for Iceberg tables. For more information, see CATALOG.
comment String
Specifies a comment for the schema.
dataRetentionTimeInDays Number
Specifies the number of days for which Time Travel actions (CLONE and UNDROP) can be performed on the database, as well as specifying the default Time Travel retention time for all schemas created in the database. For more details, see Understanding & Using Time Travel.
database Changes to this property will trigger replacement. String
The database in which to create the schema. Due to technical limitations (read more here), avoid using the following characters: |, ., ".
defaultDdlCollation String
Specifies a default collation specification for all schemas and tables added to the database. It can be overridden on schema or table level. For more information, see collation specification.
describeOutputs List<Property Map>
Outputs the result of DESCRIBE SCHEMA for the given object. In order to handle this output, one must grant sufficient privileges, e.g. grant_ownership on all objects in the schema.
enableConsoleOutput Boolean
If true, enables stdout/stderr fast path logging for anonymous stored procedures.
externalVolume String
The database parameter that specifies the default external volume to use for Iceberg tables. For more information, see EXTERNAL_VOLUME.
fullyQualifiedName String
Fully qualified name of the resource. For more information, see object name resolution.
isTransient Changes to this property will trigger replacement. String
(Default: fallback to Snowflake default - uses special value that cannot be set in the configuration manually (default)) Specifies the schema as transient. Transient schemas do not have a Fail-safe period so they do not incur additional storage costs once they leave Time Travel; however, this means they are also not protected by Fail-safe in the event of a data loss. Available options are: "true" or "false". When the value is not set in the configuration the provider will put "default" there which means to use the Snowflake default for this value.
logLevel String
Specifies the severity level of messages that should be ingested and made available in the active event table. Valid options are: [TRACE DEBUG INFO WARN ERROR FATAL OFF]. Messages at the specified level (and at more severe levels) are ingested. For more information, see LOG_LEVEL.
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 a detailed description of this parameter, see MAXDATAEXTENSIONTIMEIN_DAYS.
name String
Specifies the identifier for the schema; must be unique for the database in which the schema is created. When the name is PUBLIC, during creation the provider checks if this schema has already been created and, in such case, ALTER is used to match the desired state. Due to technical limitations (read more here), avoid using the following characters: |, ., ".
parameters List<Property Map>
Outputs the result of SHOW PARAMETERS IN SCHEMA for the given object.
pipeExecutionPaused Boolean
Specifies whether to pause a running pipe, primarily in preparation for transferring ownership of the pipe to a different role. For more information, check PIPEEXECUTIONPAUSED docs.
quotedIdentifiersIgnoreCase Boolean
If true, the case of quoted identifiers is ignored. For more information, see QUOTEDIDENTIFIERSIGNORE_CASE.
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, see REPLACEINVALIDCHARACTERS.
showOutputs List<Property Map>
Outputs the result of SHOW SCHEMA for the given object.
storageSerializationPolicy String
The storage serialization policy for Iceberg tables that use Snowflake as the catalog. Valid options are: [COMPATIBLE OPTIMIZED]. 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. For more information, see STORAGESERIALIZATIONPOLICY.
suspendTaskAfterNumFailures Number
How many times a task must fail in a row before it is automatically suspended. 0 disables auto-suspending. For more information, see SUSPENDTASKAFTERNUMFAILURES.
taskAutoRetryAttempts Number
Maximum automatic retries allowed for a user task. For more information, see TASKAUTORETRY_ATTEMPTS.
traceLevel String
Controls how trace events are ingested into the event table. Valid options are: [ALWAYS ON*EVENT OFF]. For information about levels, see TRACE*LEVEL.
userTaskManagedInitialWarehouseSize String
The initial size of warehouse to use for managed warehouses in the absence of history. For more information, see USERTASKMANAGEDINITIALWAREHOUSE_SIZE.
userTaskMinimumTriggerIntervalInSeconds Number
Minimum amount of time between Triggered Task executions in seconds.
userTaskTimeoutMs Number
User task execution timeout in milliseconds. For more information, see USERTASKTIMEOUT_MS.
withManagedAccess String
(Default: fallback to Snowflake default - uses special value that cannot be set in the configuration manually (default)) Specifies a managed schema. Managed access schemas centralize privilege management with the schema owner. Available options are: "true" or "false". When the value is not set in the configuration the provider will put "default" there which means to use the Snowflake default for this value.

Supporting Types

SchemaDescribeOutput
, SchemaDescribeOutputArgs

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

SchemaParameter
, SchemaParameterArgs

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

SchemaParameterCatalog
, SchemaParameterCatalogArgs

Default string
Description string
Key string
Level string
Value string
Default string
Description string
Key string
Level string
Value string
default_ String
description String
key String
level String
value String
default string
description string
key string
level string
value string
default String
description String
key String
level String
value String

SchemaParameterDataRetentionTimeInDay
, SchemaParameterDataRetentionTimeInDayArgs

Default string
Description string
Key string
Level string
Value string
Default string
Description string
Key string
Level string
Value string
default_ String
description String
key String
level String
value String
default string
description string
key string
level string
value string
default String
description String
key String
level String
value String

SchemaParameterDefaultDdlCollation
, SchemaParameterDefaultDdlCollationArgs

Default string
Description string
Key string
Level string
Value string
Default string
Description string
Key string
Level string
Value string
default_ String
description String
key String
level String
value String
default string
description string
key string
level string
value string
default String
description String
key String
level String
value String

SchemaParameterEnableConsoleOutput
, SchemaParameterEnableConsoleOutputArgs

Default string
Description string
Key string
Level string
Value string
Default string
Description string
Key string
Level string
Value string
default_ String
description String
key String
level String
value String
default string
description string
key string
level string
value string
default String
description String
key String
level String
value String

SchemaParameterExternalVolume
, SchemaParameterExternalVolumeArgs

Default string
Description string
Key string
Level string
Value string
Default string
Description string
Key string
Level string
Value string
default_ String
description String
key String
level String
value String
default string
description string
key string
level string
value string
default String
description String
key String
level String
value String

SchemaParameterLogLevel
, SchemaParameterLogLevelArgs

Default string
Description string
Key string
Level string
Value string
Default string
Description string
Key string
Level string
Value string
default_ String
description String
key String
level String
value String
default string
description string
key string
level string
value string
default String
description String
key String
level String
value String

SchemaParameterMaxDataExtensionTimeInDay
, SchemaParameterMaxDataExtensionTimeInDayArgs

Default string
Description string
Key string
Level string
Value string
Default string
Description string
Key string
Level string
Value string
default_ String
description String
key String
level String
value String
default string
description string
key string
level string
value string
default String
description String
key String
level String
value String

SchemaParameterPipeExecutionPaused
, SchemaParameterPipeExecutionPausedArgs

Default string
Description string
Key string
Level string
Value string
Default string
Description string
Key string
Level string
Value string
default_ String
description String
key String
level String
value String
default string
description string
key string
level string
value string
default String
description String
key String
level String
value String

SchemaParameterQuotedIdentifiersIgnoreCase
, SchemaParameterQuotedIdentifiersIgnoreCaseArgs

Default string
Description string
Key string
Level string
Value string
Default string
Description string
Key string
Level string
Value string
default_ String
description String
key String
level String
value String
default string
description string
key string
level string
value string
default String
description String
key String
level String
value String

SchemaParameterReplaceInvalidCharacter
, SchemaParameterReplaceInvalidCharacterArgs

Default string
Description string
Key string
Level string
Value string
Default string
Description string
Key string
Level string
Value string
default_ String
description String
key String
level String
value String
default string
description string
key string
level string
value string
default String
description String
key String
level String
value String

SchemaParameterStorageSerializationPolicy
, SchemaParameterStorageSerializationPolicyArgs

Default string
Description string
Key string
Level string
Value string
Default string
Description string
Key string
Level string
Value string
default_ String
description String
key String
level String
value String
default string
description string
key string
level string
value string
default String
description String
key String
level String
value String

SchemaParameterSuspendTaskAfterNumFailure
, SchemaParameterSuspendTaskAfterNumFailureArgs

Default string
Description string
Key string
Level string
Value string
Default string
Description string
Key string
Level string
Value string
default_ String
description String
key String
level String
value String
default string
description string
key string
level string
value string
default String
description String
key String
level String
value String

SchemaParameterTaskAutoRetryAttempt
, SchemaParameterTaskAutoRetryAttemptArgs

Default string
Description string
Key string
Level string
Value string
Default string
Description string
Key string
Level string
Value string
default_ String
description String
key String
level String
value String
default string
description string
key string
level string
value string
default String
description String
key String
level String
value String

SchemaParameterTraceLevel
, SchemaParameterTraceLevelArgs

Default string
Description string
Key string
Level string
Value string
Default string
Description string
Key string
Level string
Value string
default_ String
description String
key String
level String
value String
default string
description string
key string
level string
value string
default String
description String
key String
level String
value String

SchemaParameterUserTaskManagedInitialWarehouseSize
, SchemaParameterUserTaskManagedInitialWarehouseSizeArgs

Default string
Description string
Key string
Level string
Value string
Default string
Description string
Key string
Level string
Value string
default_ String
description String
key String
level String
value String
default string
description string
key string
level string
value string
default String
description String
key String
level String
value String

SchemaParameterUserTaskMinimumTriggerIntervalInSecond
, SchemaParameterUserTaskMinimumTriggerIntervalInSecondArgs

Default string
Description string
Key string
Level string
Value string
Default string
Description string
Key string
Level string
Value string
default_ String
description String
key String
level String
value String
default string
description string
key string
level string
value string
default String
description String
key String
level String
value String

SchemaParameterUserTaskTimeoutM
, SchemaParameterUserTaskTimeoutMArgs

Default string
Description string
Key string
Level string
Value string
Default string
Description string
Key string
Level string
Value string
default_ String
description String
key String
level String
value String
default string
description string
key string
level string
value string
default String
description String
key String
level String
value String

SchemaShowOutput
, SchemaShowOutputArgs

Comment string
CreatedOn string
DatabaseName string
DroppedOn string
IsCurrent bool
IsDefault bool
Name string
Options string
Owner string
OwnerRoleType string
RetentionTime string
Comment string
CreatedOn string
DatabaseName string
DroppedOn string
IsCurrent bool
IsDefault bool
Name string
Options string
Owner string
OwnerRoleType string
RetentionTime string
comment String
createdOn String
databaseName String
droppedOn String
isCurrent Boolean
isDefault Boolean
name String
options String
owner String
ownerRoleType String
retentionTime String
comment string
createdOn string
databaseName string
droppedOn string
isCurrent boolean
isDefault boolean
name string
options string
owner string
ownerRoleType string
retentionTime string
comment String
createdOn String
databaseName String
droppedOn String
isCurrent Boolean
isDefault Boolean
name String
options String
owner String
ownerRoleType String
retentionTime String

Package Details

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