Skip to main content

Object management automation tool for Snowflake

Project description

SnowDDL

PyPI Getting Started Pytest

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

  1. SnowDDL is "stateless".
  2. SnowDDL can revert any changes.
  3. SnowDDL supports ALTER COLUMN.
  4. SnowDDL provides built-in "Role hierarchy" model.
  5. SnowDDL re-creates invalid views automatically.
  6. SnowDDL simplifies code review.
  7. SnowDDL supports creation of isolated "environments" for individual developers and CI/CD scripts.
  8. SnowDDL strikes a good balance between dependency management overhead and parallelism.
  9. SnowDDL configuration can be generated dynamically in Python code.
  10. 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, 2025

Enjoy!

Project details


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.55.0.tar.gz (147.9 kB view details)

Uploaded Source

Built Distribution

snowddl-0.55.0-py3-none-any.whl (271.4 kB view details)

Uploaded Python 3

File details

Details for the file snowddl-0.55.0.tar.gz.

File metadata

  • Download URL: snowddl-0.55.0.tar.gz
  • Upload date:
  • Size: 147.9 kB
  • Tags: Source
  • Uploaded using Trusted Publishing? No
  • Uploaded via: twine/6.1.0 CPython/3.10.0

File hashes

Hashes for snowddl-0.55.0.tar.gz
Algorithm Hash digest
SHA256 ab2fd5b8931b278ea8e2ba54c0e0180e7542d50648badc44e5416fb39300d4e7
MD5 dfb7a50d51bb4b5fa3fef8e11f428dd6
BLAKE2b-256 8ddead2ca7db99cc18e867a555e71b4ae5631c8fe3238c8ae3550475ea63e03a

See more details on using hashes here.

File details

Details for the file snowddl-0.55.0-py3-none-any.whl.

File metadata

  • Download URL: snowddl-0.55.0-py3-none-any.whl
  • Upload date:
  • Size: 271.4 kB
  • Tags: Python 3
  • Uploaded using Trusted Publishing? No
  • Uploaded via: twine/6.1.0 CPython/3.10.0

File hashes

Hashes for snowddl-0.55.0-py3-none-any.whl
Algorithm Hash digest
SHA256 144563b014144c692b1fcc6cceabb470b6a682caa6c15c23e85d3d48fc648948
MD5 dd3decc974fd367a239ea87cf4f380e0
BLAKE2b-256 80cd44b9e4c8ed9fe00ba532d44ba3a22be14b16404491f7652f2546e147e3dd

See more details on using hashes here.

Supported by

AWS Cloud computing and Security Sponsor Datadog Monitoring Fastly CDN Google Download Analytics Pingdom Monitoring Sentry Error logging StatusPage Status page