SnowDDL
Search
⌃K

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. 1.
    File params.yaml is optional. All parameters are set to default if file is omitted.
  2. 2.
    Schema PUBLIC is dropped from newly created databases automatically.
  3. 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.
Previous
BUSINESS ROLE
Next
EXTERNAL FUNCTION
Last modified 1yr ago