Snowflake · Schema
Snowflake Database
A Snowflake database is a logical grouping of schemas, which in turn contain database objects such as tables, views, and stages. Databases support features like cloning, replication, failover, Time Travel, and data sharing.
Data LakesData SharingData WarehousingDatabaseSQL
Properties
| Name | Type | Description |
|---|---|---|
| name | string | Identifier for the database. Must be unique within the account. |
| kind | string | Database type. Permanent databases persist until explicitly dropped. Transient databases exist for the duration of the user session and do not have a Fail-safe period. |
| comment | string | Optional comment in which to store information related to the database. |
| data_retention_time_in_days | 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 |
| default_ddl_collation | string | Default collation specification for all schemas and tables added to the database. You can override the default at the schema and individual table levels. |
| log_level | string | Severity level of messages that should be ingested and made available in the active event table. |
| max_data_extension_time_in_days | integer | 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. |
| suspend_task_after_num_failures | integer | Maximum number of consecutive failed task runs before the current task is suspended automatically. |
| trace_level | string | How trace events are ingested into the event table. |
| user_task_managed_initial_warehouse_size | string | Size of the compute resources to provision for the first run of the serverless task, before a task history is available for Snowflake to determine an ideal size. |
| user_task_timeout_ms | integer | Time limit, in milliseconds, for a single run of the task before it times out. |
| serverless_task_min_statement_size | string | Specifies the minimum allowed warehouse size for the serverless task. |
| serverless_task_max_statement_size | string | Specifies the maximum allowed warehouse size for the serverless task. |
| created_on | string | Date and time the database was created. |
| is_default | boolean | Whether the database is the default database for a user. |
| is_current | boolean | Whether the database is the current database for the session. |
| origin | string | For a database created from a share, the fully qualified name of the source database. |
| owner | string | Name of the role that owns the database. |
| owner_role_type | string | Type of role that owns the object, either ROLE or DATABASE_ROLE. |
| options | string | Options set on the database. |
| retention_time | integer | Number of days that historical data is retained for Time Travel. |
| dropped_on | stringnull | Date and time the database was dropped. Null if the database has not been dropped. |
| budget | string | Budget that defines a monthly spending limit on the compute costs for a Snowflake account or a custom group of Snowflake objects. |