Comment on page
SCHEMA
Config path:
/<database>/<schema>/params.yamlExample:
retention_time: 7
is_sandbox: true
- 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)
- 1.File
params.yamlis optional. All parameters are set to default if file is omitted. - 2.All schemas are created
WITH MANAGED ACCESS. - 3.
- 4.Objects in schema marked as
is_sandboxwill not be dropped by SnowDDL if not defined in config. Business users must haveschema_ownerrole assigned to them to be able to create and modify objects in schema. - 5.
owner_schema_*parameters are helpful when dealing withVIEWSandPROCEDURES, which require access to objects in another schemas. Usually only objects in the current schema are available to theOWNERrole of this schema.
Last modified 7d ago