Define Database Policies

Database policies allow you to define and adhere to code standards to ensure compliance and data quality. Policy Checks allow you to do this within Liquibase.io. Using Policy Checks, you can automate rules so they do not have to be memorized, discover mistakes from previous deployments, and analyze your changelogs, changesets, and SQL for specific commands and patterns that require close review early in the development life cycle. This feature is integrated into the build and deployment automation process.

Configure Policy Checks

Liquibase.io Policy Checks are composed during workflow configuration.

Before you begin 

Before you configure a workflow where Policy Checks are defined, you must create a project, create a connection, and configure your environment:

• Create a Project 

• Creating Connections 

• Configure an Environment 

Begin

• Determine the Policy: Follow the Configure a Workflow page that describes how to add a Policy Check to your Workflow.

Business Benefits

Policy Checks deliver the following benefits:

• Reduce Errors and Risk: Automatically enforce consistent and high-quality changes that meet your governance requirements.

• Increase Productivity: Reduce manual reviews by enforcing policy standards automatically in your CI/CD pipeline.

• Ensure Data Quality: Enforce code standards and correct nomenclature, patterns, and labels to ensure data is entered correctly.

Example Scenarios

• Enforce Standards: Quickly and easily validate naming standards, column links, and other common changes.

• Access/Privileges: Secure your database by getting immediate notice that user and role privileges are being modified.