Snowddl

Latest version: v0.29.0

Safety actively analyzes 641134 Python packages for vulnerabilities to keep your Python projects secure.

Scan your dependencies

Page 6 of 14

0.14.4

- Grant `CREATE FILE FORMAT` privilege for OWNER schema roles. It should help to handle common use case when external tools try to create a `FILE_FORMAT` object before running `COPY INTO` command.

0.14.3

- Move `STRICT` and `IMMUTABLE` before `RUNTIME_VERSION` in SQL generated for object types `FUNCTION` and `PROCEDURE`.

0.14.2

- Added `is_memoizable` for `FUNCTION` object type.
- Added tests for `FUNCTION` object type.
- Starting slash `/` in `STAGE FILE` path is now optional.
- Runtime version for `FUNCTION` and `PROCEDURE` in YAML config can now be defined either as `number` or as `string`. Previously it was only defined as string, which caused confusion for numeric versions, like Python "3.8".

0.14.1

- Added `__hash__` implementation for `Ident` objects. It allows usage of such objects as keys for dictionaries.

0.14.0

- Implemented `ALERT` object type.
- Added better error message for missing `text` in YAML config for `VIEW` object type.

0.13.0

- Completely reworked `STAGE` object type resolver. Now it checks actual property values and does not rely on short hash anymore. `STAGE` objects will be re-created only when absolutely necessary. ALTER will be applied for the majority of changes.
- Introduced CLI option `--refresh-stage-encryption` to re-apply encryption parameters for each external `STAGE`. Normally it is not possible to compare config encryption parameters with existing parameters in Snowflake.
- Introduced a few "safe" alters for `TABLE` object type: (1) add new column, (2) change comment on table, (3) change comment on specific column. Previously all alters for `TABLE` were unsafe.
- `ROLE` resolver will no longer try to revoke `OWNERSHIP` grant on objects. This grant can only be transferred.
- `ROLE` resolver will now revoke `WRITE` permission on `STAGES` before trying to revoke `READ` permission.

Page 6 of 14

© 2024 Safety CLI Cybersecurity Inc. All Rights Reserved.