Comment on page
SCHEMA
Config path:
/<database>/<schema>/params.yaml
Example:
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.yaml
is 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_sandbox
will not be dropped by SnowDDL if not defined in config. Business users must haveschema_owner
role assigned to them to be able to create and modify objects in schema. - 5.
owner_schema_*
parameters are helpful when dealing withVIEWS
andPROCEDURES
, which require access to objects in another schemas. Usually only objects in the current schema are available to theOWNER
role of this schema.
Last modified 7d ago