SnowDDL
Search
K
Comment on page

SCHEMA

Config path: /<database>/<schema>/params.yaml
Example:
retention_time: 7
is_sandbox: true

Schema

  • is_transient (bool) - make schema TRANSIENT
  • retention_time (int) - data retention time in days
  • is_sandbox (bool) - custom objects created in sandbox schema will not be dropped if not present in config
  • owner_schema_read (list)
    • {items} (ident) - grant READ privileges for objects in another schema to OWNER role of the current schema
  • owner_schema_write (list)
    • {items} (ident) - grant WRITE privileges for objects in another schema to OWNER role of the current schema
  • comment (str)

Usage notes

  1. 1.
    File params.yaml is optional. All parameters are set to default if file is omitted.
  2. 2.
    All schemas are created WITH MANAGED ACCESS.
  3. 3.
    is_transient and retention_time are inherited from DATABASE object if omitted.
  4. 4.
    Objects in schema marked as is_sandbox will not be dropped by SnowDDL if not defined in config. Business users must have schema_owner role assigned to them to be able to create and modify objects in schema.
  5. 5.
    owner_schema_* parameters are helpful when dealing with VIEWS and PROCEDURES, which require access to objects in another schemas. Usually only objects in the current schema are available to the OWNER role of this schema.