Snowddl

Latest version: v0.29.0

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

Scan your dependencies

Page 7 of 14

0.12.3

- Fixed incorrect condition checking `comment` property for `WAREHOUSE` object type, which caused every warehouse to be re-created on every run.
- `FILE_FORMAT` object type is now properly replaced when `type` was changed. Other changes are still applied using `alter file format` command.
- Added tests for `PROCEDURE` and `FILE_FORMAT` object types.

0.12.2

- Fixed incorrect order of parameters when resolving `PROCEDURE` with both `comment` and `is_execute_as_caller`.
- Added protection from `FUNCTION` and `PROCEDURE` arguments with TIMESTAMP-like type and non-default precision. Snowflake bug, case 00444370.

Tests for UDFs and procedures are expected to be added in the next version.

0.12.1

- Fixed a bug with `session_params` being ignored for `USER` object type. Added additional checks to tests.

0.12.0

- (!breaking change!) Object types `NETWORK_POLICY` and `RESOURCE_MONITOR` now use env prefix, similar to other account-level objects. Previously env prefix was ignored for these object types.
- (!breaking change!) Object types `NETWORK_POLICY` and `RESOURCE_MONITOR` are now dropped during `destroy` action as long as `--apply-network-policy` and `--apply-resource-monitor` options are present.
- Added `global_resource_monitor` parameter for `WAREHOUSE` object type. Original `resource_monitor` now refers to monitor defined in config and managed by SnowDDL. New `global_resource_monitor` refers to monitor managed outside SnowDDL.
- User with `ACCOUNTADMIN` privileges is now required to run tests. It is not possible to test `RESOURCE_MONITOR` object type otherwise.
- Fixed a bug with `warehouse_params` not being applied for `WAREHOUSE` object type.
- Fixed a bug with `WAREHOUSE` parameters not being properly updated in specific edge cases.
- Added tests for `WAREHOUSE`, `NETWORK_POLICY`, `RESOURCE_MONITOR` object types.

0.11.0

- Implement query acceleration and object parameters for `WAREHOUSE` object type.
- Prevent suggestion of individual schema object drops if an entire schema was dropped.
- Add automatic placeholder `TARGET_DB` for SingleDB mode. It holds full identifier of target database.
- Add Snowflake account name and region to context object and logs.
- Add special conversion logic for `IDENTITY` columns of object type `TABLE`. Such columns are converted into `SEQUENCE` objects automatically.
- Rework naming of tests and objects in tests. It should help to streamline and speed up implementation of new tests.
- Add complete SQL file with all commands required to set up a new Snowflake test account from scratch.

0.10.0

- Add `is_transient` and `retention_time` for `TABLE` object type config.
- Add `is_transient` to `TABLE` object type converter.
- Implement advanced SEARCH OPTIMIZATION on specific columns. NB: VARIANT column paths are currently not supported due to high complexity of parsing `target` column from output of `DESC SEARCH OPTIMIZATION` command.

Page 7 of 14

© 2024 Safety CLI Cybersecurity Inc. All Rights Reserved.