Flyway Enterprise

This is available in Flyway CLI only

Description

The name of the profile to run code review with. A profile is a named list of rules and rule groups that the run excludes, so naming one can only ever narrow the analysis - it never enables a rule your rules configuration has turned off.

If this parameter is not set, code review behaves exactly as it always has: every enabled rule is applied. There is no profile meaning "everything"; that is simply the default.

A profile is a property of the run rather than of the project, so it is named per invocation. Flyway Desktop names one when it analyzes a schema model, while a pipeline analyzing migrations names none - and both may be pointed at the same project. Giving a project a default profile is not supported.

Profiles are defined in profiles. Flyway ships with one:

• schemaModel excludes the rules that cannot fire, or that only produce noise, on the schema model files written by the comparison engine: the DML rules, the script shape rules, the data-loss DDL rules (a drop in a schema model is a deleted file, not a DROP statement), the ALTER-only rules, and the formatting families. Defining a profile of the same name in your configuration replaces it.

Naming a profile that is neither built in nor defined in your configuration fails the command and lists the profiles that are available.

Flyway cannot select a profile for you. Flyway Desktop copies the SQL to a temporary file and runs with check.scope=script, so the paths never resemble the schema model; the MCP server points check.scriptFilename at the file where it lives. Either way, the profile has to be named explicitly.

Reports do not record which profile ran; a profiled run simply reports fewer violations.

Note that if SQLFluff discovers a configuration file for itself - which can only happen when neither check.rulesConfig nor the bundled conf/sqlfluff.cfg resolves - the profile exclusions replace, rather than add to, any exclude_rules in that file.

Type

String

Default

none - every enabled rule runs

Usage

Flyway Desktop

This can't be added to a configuration file via Flyway Desktop. It is set explicitly under the hood in Flyway Desktop invocations of the Flyway command line.

Command-line

./flyway check -code "-check.code.profile=schemaModel"