notbugAs an Amazon Associate I earn from qualifying purchases.
Want a good read? Try FreeBSD Mastery: Jails (IT Mastery Book 15)
Want a good monitor light? See my photosAll times are UTC
Ukraine
Port details
py-schemachange Database Change Management tool for Snowflake
4.0.1 databases on this many watch lists=2 search for ports that depend on this port Find issues related to this port Report an issue related to this port View this port on Repology. pkg-fallout 3.7.0Version of this port present on the latest quarterly branch.
Maintainer: pat@patmaddox.com search for ports maintained by this maintainer
Port Added: 2023-10-22 11:30:08
Last Update: 2025-10-18 19:28:28
Commit Hash: 70cebc2
People watching this port, also watch:: jdictionary, py311-Automat, py311-python-gdsii, py311-PyOpenGL, p5-Sane
Also Listed In: python
License: APACHE20
WWW:
https://github.com/Snowflake-Labs/schemachange
Description:
schemachange is a simple python based tool to manage all of your Snowflake objects. It follows an Imperative-style approach to Database Change Management (DCM) and was inspired by the Flyway database migration tool. When combined with a version control system and a CI/CD tool, database changes can be approved and deployed through a pipeline using modern software delivery practices. As such schemachange plays a critical role in enabling Database (or Data) DevOps.
Homepage    cgit ¦ Codeberg ¦ GitHub ¦ GitLab ¦ SVNWeb - no subversion history for this port

Manual pages:
FreshPorts has no man page information for this port.
pkg-plist: as obtained via: make generate-plist
There is no configure plist information for this port.
USE_RC_SUBR (Service Scripts)
  • no SUBR information found for this port
Dependency lines:
  • ${PYTHON_PKGNAMEPREFIX}schemachange>0:databases/py-schemachange@${PY_FLAVOR}
To install the port:
cd /usr/ports/databases/py-schemachange/ && make install clean
To add the package, run one of these commands:
  • pkg install databases/py-schemachange
  • pkg install py311-schemachange
NOTE: If this package has multiple flavors (see below), then use one of them instead of the name specified above.
NOTE: This is a Python port. Instead of py311-schemachange listed in the above command, you can pick from the names under the Packages section.
PKGNAME: py311-schemachange
Package flavors (<flavor>: <package>)
  • py311: py311-schemachange
distinfo:
TIMESTAMP = 1760766128 SHA256 (schemachange-4.0.1.tar.gz) = f72b48ae3761035a2b27adafa013cba878acc730525ccf7b1b35530fbf806db0 SIZE (schemachange-4.0.1.tar.gz) = 54091

Packages (timestamps in pop-ups are UTC):
py39-schemachange
ABIaarch64amd64armv6armv7i386powerpcpowerpc64powerpc64le
FreeBSD:13:latest-----n/an/an/a
FreeBSD:13:quarterly-----n/an/an/a
FreeBSD:14:latest--------
FreeBSD:14:quarterly------3.6.0-
FreeBSD:15:latest--n/a-n/an/a3.6.0-
FreeBSD:15:quarterly--n/a-n/an/a--
FreeBSD:16:latest--n/a-n/an/a--
 

py311-schemachange
ABIaarch64amd64armv6armv7i386powerpcpowerpc64powerpc64le
FreeBSD:13:latest4.0.14.0.1-3.7.04.0.1n/an/an/a
FreeBSD:13:quarterly3.7.03.7.0-3.7.03.7.0n/an/an/a
FreeBSD:14:latest4.0.14.0.1-3.7.04.0.1---
FreeBSD:14:quarterly3.7.03.7.0-3.7.03.7.0---
FreeBSD:15:latest4.0.14.0.1n/a3.7.0n/an/a--
FreeBSD:15:quarterly3.7.03.7.0n/a-n/an/a--
FreeBSD:16:latest3.7.04.0.1n/a-n/an/a--
 

Dependencies
NOTE: FreshPorts displays only information on required and default dependencies. Optional dependencies are not covered.
Build dependencies:
  1. py311-Jinja2>=3.0<4 : devel/py-Jinja2@py311
  2. py311-pyyaml>=6.0<7 : devel/py-pyyaml@py311
  3. py311-requests>0 : www/py-requests@py311
  4. py311-snowflake-connector-python>=2.8<5 : databases/py-snowflake-connector-python@py311
  5. py311-structlog>=24.10.0 : devel/py-structlog@py311
  6. py311-setuptools>=40.9.0 : devel/py-setuptools@py311
  7. py311-wheel>0 : devel/py-wheel@py311
  8. python3.11 : lang/python311
  9. py311-build>=0 : devel/py-build@py311
  10. py311-installer>=0 : devel/py-installer@py311
Test dependencies:
  1. py311-Jinja2>=3.0<4 : devel/py-Jinja2@py311
  2. py311-pyyaml>=6.0<7 : devel/py-pyyaml@py311
  3. py311-requests>0 : www/py-requests@py311
  4. py311-snowflake-connector-python>=2.8<5 : databases/py-snowflake-connector-python@py311
  5. py311-structlog>=24.10.0 : devel/py-structlog@py311
  6. py311-pytest>0 : devel/py-pytest@py311
  7. python3.11 : lang/python311
Runtime dependencies:
  1. py311-Jinja2>=3.0<4 : devel/py-Jinja2@py311
  2. py311-pyyaml>=6.0<7 : devel/py-pyyaml@py311
  3. py311-requests>0 : www/py-requests@py311
  4. py311-snowflake-connector-python>=2.8<5 : databases/py-snowflake-connector-python@py311
  5. py311-structlog>=24.10.0 : devel/py-structlog@py311
  6. py311-cryptography>=44.0.3,1 : security/py-cryptography@py311
  7. python3.11 : lang/python311
There are no ports dependent upon this port

Configuration Options:
No options to configure
Options name:
databases_py-schemachange
USES:
python
FreshPorts was unable to extract/find any pkg message
Master Sites:
Expand this list (2 items)
Collapse this list.
  1. https://files.pythonhosted.org/packages/source/s/schemachange/
  2. https://pypi.org/packages/source/s/schemachange/
Collapse this list.

Number of commits found: 7

Commit History - (may be incomplete: for full details, see links to repositories near top of page)
CommitCreditsLog message
4.0.1
18 Oct 2025 19:28:28
commit hash: 70cebc21bc2a40723b0b4d959ef0ff576eeff949commit hash: 70cebc21bc2a40723b0b4d959ef0ff576eeff949commit hash: 70cebc21bc2a40723b0b4d959ef0ff576eeff949commit hash: 70cebc21bc2a40723b0b4d959ef0ff576eeff949 files touched by this commit
Vladimir Druzenko (vvd) search for other commits by this committer
Author: Pat Maddox
databases/py-schemachange: Update 3.7.0 => 4.0.1

Changelogs:
https://github.com/Snowflake-Labs/schemachange/releases/tag/v4.0.0
https://github.com/Snowflake-Labs/schemachange/releases/tag/v4.0.1

PR:	290338
3.7.0
10 Dec 2024 09:02:55
commit hash: 204b1078e41c17c5b1de8f01d2b220adc86fbf22commit hash: 204b1078e41c17c5b1de8f01d2b220adc86fbf22commit hash: 204b1078e41c17c5b1de8f01d2b220adc86fbf22commit hash: 204b1078e41c17c5b1de8f01d2b220adc86fbf22 files touched by this commit
Robert Clausecker (fuz) search for other commits by this committer
Author: Pat Maddox
databases/py-schemachange: Update to 3.7.0

Changelog: https://github.com/Snowflake-Labs/schemachange/releases/tag/v3.7.0

PR:		283121
3.6.1_1
15 Sep 2024 20:11:52
commit hash: 7024f0f3480d0875f968d91a9b7fb9515f26ef49commit hash: 7024f0f3480d0875f968d91a9b7fb9515f26ef49commit hash: 7024f0f3480d0875f968d91a9b7fb9515f26ef49commit hash: 7024f0f3480d0875f968d91a9b7fb9515f26ef49 files touched by this commit
Po-Chuan Hsieh (sunpoet) search for other commits by this committer
databases/py-schemachange: Add NO_ARCH

Approved by:	portmgr (blanket)
3.6.1_1
08 Sep 2024 18:40:26
commit hash: 4ec13356ca0e992f7a253f0ea6f26faf5c329044commit hash: 4ec13356ca0e992f7a253f0ea6f26faf5c329044commit hash: 4ec13356ca0e992f7a253f0ea6f26faf5c329044commit hash: 4ec13356ca0e992f7a253f0ea6f26faf5c329044 files touched by this commit
Po-Chuan Hsieh (sunpoet) search for other commits by this committer
databases/py-schemachange: Fix RUN_DEPENDS usage

Approved by:	portmgr (blanket)
With hat:	python
3.6.1_1
07 Jul 2024 08:05:33
commit hash: 1a80ec7c2281900b82b228ee3a7b070c8ca4286ecommit hash: 1a80ec7c2281900b82b228ee3a7b070c8ca4286ecommit hash: 1a80ec7c2281900b82b228ee3a7b070c8ca4286ecommit hash: 1a80ec7c2281900b82b228ee3a7b070c8ca4286e files touched by this commit
Po-Chuan Hsieh (sunpoet) search for other commits by this committer
devel/py-pyyaml: Move devel/py-yaml to devel/py-pyyaml

- Bump PORTREVISION of dependent ports for dependency change
3.6.1
06 May 2024 19:11:25
commit hash: a0a0e233cb7d8b88c5b839c7cabb61eab2763daccommit hash: a0a0e233cb7d8b88c5b839c7cabb61eab2763daccommit hash: a0a0e233cb7d8b88c5b839c7cabb61eab2763daccommit hash: a0a0e233cb7d8b88c5b839c7cabb61eab2763dac files touched by this commit
Robert Clausecker (fuz) search for other commits by this committer
Author: Pat Maddox
databases/py-schemachange: Update to 3.6.1

Changelog: https://github.com/Snowflake-Labs/schemachange/releases/tag/v3.6.1

PR:		276457
3.6.0
22 Oct 2023 11:28:46
commit hash: a65ea84c048e834e46c0011ff25caeed1c1ad884commit hash: a65ea84c048e834e46c0011ff25caeed1c1ad884commit hash: a65ea84c048e834e46c0011ff25caeed1c1ad884commit hash: a65ea84c048e834e46c0011ff25caeed1c1ad884 files touched by this commit
Kurt Jaeger (pi) search for other commits by this committer
Author: Pat Maddox
databases/py-schemachange: new port

schemachange is a simple python based tool to manage all of your Snowflake
objects. It follows an Imperative-style approach to Database Change Management
(DCM) and was inspired by the Flyway database migration tool. When combined with
a version control system and a CI/CD tool, database changes can be approved and
deployed through a pipeline using modern software delivery practices. As such
schemachange plays a critical role in enabling Database (or Data) DevOps.

PR:		274585
Author:		Pat Maddox <pat@patmaddox.com>

Number of commits found: 7