Snowflake · Schema
Database
Snowflake database object.
Data LakesData SharingData WarehousingDatabaseSQL
Properties
| Name | Type | Description |
|---|---|---|
| created_on | string | Date and time the database was created. |
| kind | string | Database type, permanent (default) or transient. |
| is_default | boolean | Whether the database is the default database for a user. |
| is_current | boolean | Current database for the session. |
| origin | string | |
| owner | string | Name of the role that owns the database. |
| comment | string | Optional comment in which to store information related to the database. |
| options | string | |
| retention_time | integer | Number of days that historical data is retained for Time Travel. |
| dropped_on | string | Date and time the database was 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. |
| owner_role_type | string | Type of role that owns the object, either ROLE or DATABASE_ROLE |
| 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 an 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. Currently, Snowflake supports only `TRACE`, `DEBUG`, `INFO`, `WARN`, `ERROR`, `FATAL` and `OFF`. |
| 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. Currently, Snowflake supports only `ALWAYS`, `ON_EVENT`, and `OFF`. |
| 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. Minimum XSMALL, Maximum XXLARGE. |
| serverless_task_max_statement_size | string | Specifies the maximum allowed warehouse size for the serverless task. Minimum XSMALL, Maximum XXLARGE. |