> For the complete documentation index, see [llms.txt](https://docs.snowddl.com/llms.txt). Markdown versions of documentation pages are available by appending `.md` to page URLs; this page is available as [Markdown](https://docs.snowddl.com/basic/yaml-configs/database.md).

# DATABASE

Config path: `/<database>/params.yaml`

Example:

```yaml
is_transient: true
retention_time: 60
comment: "Test database"
```

## Schema

* **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 [permission model](/basic/yaml-configs/permission-model.md)
* **external\_volume** (ident) - name of EXTERNAL VOLUME used for [Iceberg tables](/guides/other-guides/iceberg-tables.md)
* **catalog** (ident) - name of CATALOG used for [Iceberg tables](/guides/other-guides/iceberg-tables.md)
* **event\_table** (ident) - name of [EVENT\_TABLE](/basic/yaml-configs/event-table.md)
* **log\_level** (str) - logging parameter [LOG\_LEVEL](https://docs.snowflake.com/en/sql-reference/parameters#label-log-level)
* **log\_event\_level** (str) - logging parameter LOG\_EVENT\_LEVEL
* **metric\_level** (str) - logging parameter [METRIC\_LEVEL](https://docs.snowflake.com/en/sql-reference/parameters#label-metric-level)
* **trace\_level** (str) - logging parameter [TRACE\_LEVEL](https://docs.snowflake.com/en/sql-reference/parameters#trace-level)
* **quoted\_identifiers\_ignore\_case** (bool)
* **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)

## Usage notes

1. File `params.yaml` is optional. All parameters are set to default if file is omitted.
2. Schema `PUBLIC` is dropped from newly created databases automatically.
3. Inbound `SHARES` are currently not managed by SnowDDL, but can be created manually by `ACCOUNTADMIN`. You may read more about inbound shares in [the relevant guide](/guides/other-guides/inbound-shares.md).
4. 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.
5. **owner\_\*** parameters are designed to provide additional privileges which are required for some object types to operate properly. These parameters require [permission model](/basic/yaml-configs/permission-model.md) with `database_owner` ruleset.

## Links

* [CREATE DATABASE](https://docs.snowflake.com/en/sql-reference/sql/create-database.html)
* [ALTER DATABASE](https://docs.snowflake.com/en/sql-reference/sql/alter-database.html)
* [SHOW DATABASES](https://docs.snowflake.com/en/sql-reference/sql/show-databases.html)
* [Parser & JSON Schema (GitHub)](https://github.com/littleK0i/SnowDDL/blob/master/snowddl/parser/database.py)