Skip to main content
Version: 2.23 (prerelease)

sqlfluff

The Sqlfluff SQL linter (https://github.com/sqlfluff/sqlfluff).

This version of Pants uses sqlfluff version 2.3.5 by default. Use a dedicated lockfile and the install_from_resolve option to control this.

Backend: pants.backend.experimental.sql.lint.sqlfluff

Config section: [sqlfluff]

Basic options​

args​

--sqlfluff-args="[<shell_str>, <shell_str>, ...]"
PANTS_SQLFLUFF_ARGS
pants.toml
[sqlfluff]
args = [
    <shell_str>,
    <shell_str>,
    ...,
]
default: []

Arguments to pass directly to Sqlfluff, e.g. --sqlfluff-args='--dialect=postgres --exclude-rules LT08,RF02'.

fix_args​

--sqlfluff-fix-args="[<shell_str>, <shell_str>, ...]"
PANTS_SQLFLUFF_FIX_ARGS
pants.toml
[sqlfluff]
fix_args = [
    <shell_str>,
    <shell_str>,
    ...,
]
default: []

Arguments to pass directly to Sqlfluff, e.g. --sqlfluff-args='--force'.

skip​

--[no-]sqlfluff-skip
PANTS_SQLFLUFF_SKIP
pants.toml
[sqlfluff]
skip = <bool>
default: False

If true, don't use Sqlfluff when running pants fmt and pants fix and pants lint.

Advanced options​

config​

--sqlfluff-config=<file_option>
PANTS_SQLFLUFF_CONFIG
pants.toml
[sqlfluff]
config = <file_option>
default: None

Path to the pyproject.toml or .sqlfluff file to use for configuration (https://docs.sqlfluff.com/en/stable/configuration.html).

Setting this option will disable [sqlfluff].config_discovery. Use this option if the config is located in a non-standard location.

config_discovery​

--[no-]sqlfluff-config-discovery
PANTS_SQLFLUFF_CONFIG_DISCOVERY
pants.toml
[sqlfluff]
config_discovery = <bool>
default: True

If true, Pants will include any relevant config files during runs (pyproject.toml, and .sqlfluff).

Use [sqlfluff].config instead if your config is in a non-standard location.

console_script​

--sqlfluff-console-script=<str>
PANTS_SQLFLUFF_CONSOLE_SCRIPT
pants.toml
[sqlfluff]
console_script = <str>
default: sqlfluff

The console script for the tool. Using this option is generally preferable to (and mutually exclusive with) specifying an --entry-point since console script names have a higher expectation of staying stable across releases of the tool. Usually, you will not want to change this from the default.

entry_point​

--sqlfluff-entry-point=<str>
PANTS_SQLFLUFF_ENTRY_POINT
pants.toml
[sqlfluff]
entry_point = <str>
default: None

The entry point for the tool. Generally you only want to use this option if the tool does not offer a --console-script (which this option is mutually exclusive with). Usually, you will not want to change this from the default.

install_from_resolve​

--sqlfluff-install-from-resolve=<str>
PANTS_SQLFLUFF_INSTALL_FROM_RESOLVE
pants.toml
[sqlfluff]
install_from_resolve = <str>
default: None

If specified, install the tool using the lockfile for this named resolve.

This resolve must be defined in [python].resolves, as described in https://www.pantsbuild.org/2.23/docs/python/overview/lockfiles#lockfiles-for-tools.

The resolve's entire lockfile will be installed, unless specific requirements are listed via the requirements option, in which case only those requirements will be installed. This is useful if you don't want to invalidate the tool's outputs when the resolve incurs changes to unrelated requirements.

If unspecified, and the lockfile option is unset, the tool will be installed using the default lockfile shipped with Pants, which uses sqlfluff version 2.3.5.

If unspecified, and the lockfile option is set, the tool will use the custom sqlfluff "tool lockfile" generated from the version and extra_requirements options. But note that this mechanism is deprecated.

interpreter_constraints​

--sqlfluff-interpreter-constraints="['<str>', '<str>', ...]"
PANTS_SQLFLUFF_INTERPRETER_CONSTRAINTS
pants.toml
[sqlfluff]
interpreter_constraints = [
    '<str>',
    '<str>',
    ...,
]
default: 
[
  "CPython>=3.7,<4"
]

Python interpreter constraints for this tool.

requirements​

--sqlfluff-requirements="['<str>', '<str>', ...]"
PANTS_SQLFLUFF_REQUIREMENTS
pants.toml
[sqlfluff]
requirements = [
    '<str>',
    '<str>',
    ...,
]
default: []

If install_from_resolve is specified, install these requirements, at the versions provided by the specified resolve's lockfile.

Values can be pip-style requirements (e.g., tool or tool==1.2.3 or tool>=1.2.3), or addresses of python_requirement targets (or targets that generate or depend on python_requirement targets). Make sure to use the // prefix to refer to targets using their full address from the root (e.g. //3rdparty/python:tool). This is necessary to distinguish address specs from local or VCS requirements.

The lockfile will be validated against the requirements - if a lockfile doesn't provide the requirement (at a suitable version, if the requirement specifies version constraints) Pants will error.

If unspecified, install the entire lockfile.

Deprecated options​

None

None