Object management automation tool for Snowflake
Project description
SnowDDL
SnowDDL is a declarative-style tool for object management automation in Snowflake.
It is not intended to replace other tools entirely, but to provide an alternative approach focused on practical data engineering challenges.
You may find SnowDDL useful if:
- complexity of object schema grows exponentially, and it becomes hard to manage;
- your organization maintains multiple Snowflake accounts (dev, stage, prod);
- your organization has multiple developers sharing the same Snowflake account and suffering from conflicts;
- it is necessary to generate some part of configuration dynamically using Python;
Main features
- SnowDDL is "stateless".
- SnowDDL can revert any changes.
- SnowDDL supports ALTER COLUMN.
- SnowDDL provides built-in "Role hierarchy" model.
- SnowDDL re-creates invalid views automatically.
- SnowDDL simplifies code review.
- SnowDDL supports creation of isolated "environments" for individual developers and CI/CD scripts.
- SnowDDL strikes a good balance between dependency management overhead and parallelism.
- SnowDDL configuration can be generated dynamically in Python code.
- SnowDDL can manage packages for Java and Python UDF scripts natively.
Quick links
Introduction videos
Mini-roadmap
placeholders in YAML configs(done)documentation for dynamic config generation in Python ("advanced mode")(done)video tutorials(done, but more tutorials are coming in future)- full test coverage for all object types and transformations
Issues? Questions? Feedback?
Please use GitHub "Issues" to report bugs and technical problems.
Please use GitHub "Discussions" to ask questions and provide feedback.
Created by
Vitaly Markov, 2024
Enjoy!
Release history Release notifications | RSS feed
Download files
Download the file for your platform. If you're not sure which to choose, learn more about installing packages.
Source Distribution
snowddl-0.25.3.tar.gz
(112.8 kB
view hashes)
Built Distribution
snowddl-0.25.3-py3-none-any.whl
(214.0 kB
view hashes)
