DATABASE
Config path: /<database>/params.yaml
Example:
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
File
params.yaml
is optional. All parameters are set to default if file is omitted.Schema
PUBLIC
is dropped from newly created databases automatically.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
Last updated