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, 2026

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

Uploaded Source

Built Distribution

If you're not sure about the file name format, learn more about wheel file names.

snowddl-0.67.2-py3-none-any.whl (283.5 kB view details)

Uploaded Python 3

File details

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

File metadata

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

File hashes

Hashes for snowddl-0.67.2.tar.gz
Algorithm Hash digest
SHA256 c969758008788e7139ea588667bc3aae20ed662075cbb143d5f10f34d4bb4d64
MD5 f19dae031e2beb7a3d84c614769f9009
BLAKE2b-256 e2ae90bf4b8cc15b2e8f323d66fedc7ee58ed1f436b6caf38408ba62a8c82408

See more details on using hashes here.

File details

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

File metadata

  • Download URL: snowddl-0.67.2-py3-none-any.whl
  • Upload date:
  • Size: 283.5 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.67.2-py3-none-any.whl
Algorithm Hash digest
SHA256 f16364ac91e837dd3e7e311437fbfe5c5795f211516e9b12e1f20826dfa9b230
MD5 853f54299988b4646b39d670426e49ee
BLAKE2b-256 da1cdcbc2c64e968bced24e294389461c29b8e56656c2aea186927897041e082

See more details on using hashes here.

Supported by

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