DATABASE

Config path: /<database>/params.yaml

Example:

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 objects created in schemas of sandbox database will not be dropped if not present in config

• 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. SHARES are currently not supported by SnowDDL. But you may create shares manually, grant shares to a GLOBAL ROLE, grant GLOBAL ROLE to BUSINESS ROLE.

Links

• CREATE DATABASE

• ALTER DATABASE

• SHOW DATABASES

• Parser & JSON Schema (GitHub)