DATABASE
Config path:
/<database>/params.yaml
Example:
is_transient: true
retention_time: 60
comment: "Test database"
- 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)
- 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.
Last modified 1yr ago