DATABASE
Last updated
Last updated
Config path: /<database>/params.yaml
Example:
is_transient (bool) - make database TRANSIENT
retention_time (int) - data retention time in days
is_sandbox (bool) - custom schemas and schema objects created in sandbox database will not be dropped if not present in config
permission_model (str) - name of custom
owner_database_read (list)
{items} (ident) - grant READ privileges for objects in another database to OWNER role of this database
owner_database_write (list)
{items} (ident) - grant WRITE privileges for objects in another database to OWNER role of this database
owner_schema_read (list)
{items} (ident) - grant READ privileges for objects in another schema to OWNER role of this database
owner_schema_write (list)
{items} (ident) - grant WRITE privileges for objects in another schema to OWNER role of this database
owner_share_read (list)
{items} (ident) - grant IMPORTED PRIVILEGES or DATABASE ROLE for inbound share to OWNER role of this database
owner_integration_usage (list)
{items} (ident) - grant USAGE privilege on global integration to OWNER role of this database
owner_warehouse_usage (list)
{items} (ident) - grant USAGE privilege on warehouse to OWNER role of this database
owner_account_grants (list)
{items} (str) - grant account-level privilege to OWNER role of this database
owner_global_roles (list)
{items} (ident) - grant external roles with custom permissions created outside of SnowDDL to OWNER roles in this database
comment (str)
File params.yaml is optional. All parameters are set to default if file is omitted.
Schema PUBLIC is dropped from newly created databases automatically.
Use is_sandbox parameter if you are planning to let external software to create SCHEMAS inside this database. Otherwise schemas which are not mentioned in SnowDDL config will be dropped.
Inbound SHARES are currently not managed by SnowDDL, but can be created manually by ACCOUNTADMIN. You may read more about inbound shares in .
owner_* parameters are designed to provide additional privileges which are required for some object types to operate properly. These parameters require with database_owner ruleset.