SnowDDL
Search…
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.

Links

Copy link
On this page
Schema
Usage notes
Links