Snowddl

Latest version: v0.29.0

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

Scan your dependencies

Page 4 of 14

0.22.0

- Introduced `NETWORK RULE`, `SECRET`, `EXTERNAL ACCESS INTEGRATION` object types.
- Added `EXTERNAL_ACCESS_INTEGRATIOS` and `SECRETS` parameters for functions and procedures.
- Added ability to set `default` for function and procedure arguments.
- Fixed issue with event tables being dropped while processing normal tables.
- Implemented "owner" check via `SHOW GRANTS` for `NETWORK POLICY` and `EXTERNAL ACCESS INTEGRATION`. "Owner" column is normally not available for these objects types.
- Added `--env-admin-role` CLI option.

0.21.0

- Introduced custom value for application option (`SnowDDL <version>`) while opening Snowflake connection. Now it should be possible to find sessions created by SnowDDL using `SESSIONS` system view.
- Added `--query-tag` CLI option to set custom `QUERY_TAG` session parameter.
- Fixed pydantic deprecation warning related to `__fields__`.
- Added explicit `.close()` call for Snowflake connection after execution of CLI commands. It should help to terminate SnowDDL sessions earlier, regardless of `CLIENT_SESSION_KEEP_ALIVE` parameter.

0.20.1

- Added additional debug logs for `VIEW` resolver in attempt to diagnose rare unnecessary re-creation problem.

0.20.0

- Replaced blueprint dataclasses with `pydantic` V2 models. Dataclasses are no longer used.
- Introduced a lot of default parameter values for the majority of blueprints and related objects. It should make the custom code operating on config and blueprints more clear. It will also prevent this code from breaking when new optional parameters are added to blueprints.
- Introduced `black` for code formatting. Reformatted entire codebase.
- Introduced `ruff` for code linting. Fixed or explicitly skipped ruff warnings across the entire codebase.
- Introduced the ability to dynamically add custom blueprints and adjust existing blueprints by placing Python modules in special config directory `__custom`.
- Database names starting with `__` (double underscore) will now be ignored. It is necessary to support more special config sub-directories in future.

0.18.2

- When comparing grants, run `REVOKE` commands prior to `GRANT` commands. It should help to resolve issues with `OWNERSHIP` future grant, which should be revoked before a new `OWNERSHIP` grant can be added.

0.18.1

- Ignore grants for object types which are currently not supported by SnowDDL.

Page 4 of 14

© 2024 Safety CLI Cybersecurity Inc. All Rights Reserved.