Database
Last updated
Last updated
Represents a database in Snowflake.
A database can contain schemas. In Python, you can add a schema to a database in several ways: By database name:
By database object:
Or using the add
method:
In yaml, you can add schemas to a database using the schemas
field:
Or by name:
name
(string, required) - The name of the database.
transient
(bool) - Specifies if the database is transient. Defaults to False.
data_retention_time_in_days
(int) - The number of days to retain data. Defaults to 1.
max_data_extension_time_in_days
(int) - The maximum number of days to extend data retention. Defaults to 14.
default_ddl_collation
(string) - The default collation for DDL statements.
tags
(dict) - A dictionary of tags associated with the database.
comment
(string) - A comment describing the database.
owner
(string or ) - The owner role of the database. Defaults to "SYSADMIN".