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

  • owner_integration_usage (list)

    • {items} (ident) - grant USAGE privilege on integration to OWNER role of the current schema

  • comment (str)

Usage notes

  1. File params.yaml is optional. All parameters are set to default if file is omitted.

  2. All schemas are created WITH MANAGED ACCESS.

  3. is_transient and retention_time are inherited from DATABASE object if omitted.

  4. Objects in schema marked with is_sandbox flag will not be dropped by SnowDDL if not defined in config.

  5. owner_schema_read and owner_schema_write 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.

  6. owner_integration_usage parameter helps to provide additional USAGE privileges on various externally defined integration objects to schema OWNER role, which helps to resolve various permission-related issues. For example, it is required in order for error notification integrations to work properly.

Links

PreviousROW ACCESS POLICYNextSECRET

Last updated