Skip to content

Latest commit

 

History

History
55 lines (43 loc) · 3.19 KB

README.md

File metadata and controls

55 lines (43 loc) · 3.19 KB

vigilant-umbrella

This repo contains artifacts to be use by the Liquibase Pro Data Governance Workshop on Policy Checks Assumes you are using Liquibase Pro 4.29.2 or higher with a valid license key You will need to have JAVA version 17+ to utilize the custom policy checks with python code feature

Once you clone the repo make sure that the parent directory of the local repo is included in the LIQUIBASE_SEARCH_PATH

The WorkshopLabs directory contain the lab instructions for using this in your own environment

These environment variables need to be defined for environment session of within a liquibase.properties file:
LIQUIBASE_COMMAND_CHANGELOG_FILE=workshopChangelog.xml
LIQUIBASE_COMMAND_USERNAME=[db user name]
LIQUIBASE_COMMAND_PASSWORD=[db user password for target DB]
LIQUIBASE_COMMAND_URL=[jdbc connect string for target database]
LIQUIBASE_LICENSE_KEY=[your valid pro license key]
LIQUIBASE_COMMAND_CHECKS_RUN_CHECKS_OUTPUT=ISSUES
LIQUIBASE_LOG_FORMAT=JSON_PRETTY
LIQUIBASE_REPORTS_ENABLED=true
LIQUIBASE_COMMAND_CHECKS_RUN_CHECKS_SCRIPTS_ENABLED='true'

Liquibase Doc Pages that may be helpful:

Quality Checks

Quality Check Packages

For details on custom policy checks using regex patterns - Learn more here:
Single Regex Pattern Check
PatternAFollowedByPatternB
PatternANotFollowedByPatternB
PatternANotPrecededByPatternB
PatternAPrecededByPatternB

For details on custom policy checks using python scripts - Learn more here:
[Custom Policy Checks] https://docs.liquibase.com/liquibase-pro/policy-checks/custom-policy-checks/home.html
Liquibase prerequisites for python based custom policy checks
Liquibase 4.29.0+ with the Liquibase Checks extension - only available to users on MacOS or Linux
Download the liquibase-checks-.jar and put it in the liquibase/lib directory.
You can find the jar file here - https://mvnrepository.com/artifact/org.liquibase.ext/liquibase-checks

If you use Maven, add this dependency to your pom.xml file:

<?xml version="1.0"?>
<dependency>
    <groupId>org.liquibase.ext</groupId>
    <artifactId>liquibase-checks</artifactId>
    <version>1.0.0</version>
</dependency>

Java Development Kit 17+ (available for Open JDK and Oracle JDK) Linux, macOS, or Windows operating system
Familiarity with Liquibase concepts: Changelog, Changeset, checks-scope, and snapshot