sqlfluff

sqlfluff documentation

Version in MegaLinter: 3.3.0
Visit Official Web Site
See How to configure sqlfluff rules
- If custom .sqlfluff config file isn't found, .sqlfluff will be used
See Index of problems detected by sqlfluff

Configuration in MegaLinter

Enable sqlfluff by adding SQL_SQLFLUFF in ENABLE_LINTERS variable
Disable sqlfluff by adding SQL_SQLFLUFF in DISABLE_LINTERS variable

Variable	Description	Default value
SQL_SQLFLUFF_ARGUMENTS	User custom arguments to add in linter CLI call Ex: `-s --foo "bar"`
SQL_SQLFLUFF_COMMAND_REMOVE_ARGUMENTS	User custom arguments to remove from command line before calling the linter Ex: `-s --foo "bar"`
SQL_SQLFLUFF_FILTER_REGEX_INCLUDE	Custom regex including filter Ex: `(src\\|lib)`	Include every file
SQL_SQLFLUFF_FILTER_REGEX_EXCLUDE	Custom regex excluding filter Ex: `(test\\|examples)`	Exclude no file
SQL_SQLFLUFF_CLI_LINT_MODE	Override default CLI lint mode - `file`: Calls the linter for each file - `list_of_files`: Call the linter with the list of files as argument - `project`: Call the linter from the root of the project	`list_of_files`
SQL_SQLFLUFF_FILE_EXTENSIONS	Allowed file extensions. `"*"` matches any extension, `""` matches empty extension. Empty list excludes all files Ex: `[".py", ""]`	`[".sql"]`
SQL_SQLFLUFF_FILE_NAMES_REGEX	File name regex filters. Regular expression list for filtering files by their base names using regex full match. Empty list includes all files Ex: `["Dockerfile(-.+)?", "Jenkinsfile"]`	Include every file
SQL_SQLFLUFF_PRE_COMMANDS	List of bash commands to run before the linter	None
SQL_SQLFLUFF_POST_COMMANDS	List of bash commands to run after the linter	None
SQL_SQLFLUFF_UNSECURED_ENV_VARIABLES	List of env variables explicitly not filtered before calling SQL_SQLFLUFF and its pre/post commands	None
SQL_SQLFLUFF_CONFIG_FILE	sqlfluff configuration file nameUse `LINTER_DEFAULT` to let the linter find it	`.sqlfluff`
SQL_SQLFLUFF_RULES_PATH	Path where to find linter configuration file	Workspace folder, then MegaLinter default rules
SQL_SQLFLUFF_DISABLE_ERRORS	Run linter but consider errors as warnings	`false`
SQL_SQLFLUFF_DISABLE_ERRORS_IF_LESS_THAN	Maximum number of errors allowed	`0`
SQL_SQLFLUFF_CLI_EXECUTABLE	Override CLI executable	`['sqlfluff']`

MegaLinter Flavors

This linter is available in the following flavors

Flavor	Description	Embedded linters
all	Default MegaLinter Flavor	124
c_cpp	Optimized for pure C/C++ projects	54
cupcake	MegaLinter for the most commonly used languages	84
documentation	MegaLinter for documentation projects	49
dotnet	Optimized for C, C++, C# or VB based projects	62
dotnetweb	Optimized for C, C++, C# or VB based projects with JS/TS	71
go	Optimized for GO based projects	51
java	Optimized for JAVA based projects	53
javascript	Optimized for JAVASCRIPT or TYPESCRIPT based projects	59
php	Optimized for PHP based projects	54
python	Optimized for PYTHON based projects	62
ruby	Optimized for RUBY based projects	50
rust	Optimized for RUST based projects	50
salesforce	Optimized for Salesforce based projects	54
swift	Optimized for SWIFT based projects	50
terraform	Optimized for TERRAFORM based projects	54

Behind the scenes

How are identified applicable files

Activated only if one of these files is found: .sqlfluff
File extensions: .sql

How the linting is performed

sqlfluff is called once with the list of files as arguments (list_of_files CLI lint mode)

Example calls

sqlfluff myfile.sql

sqlfluff --config .sqlfluff myfile.sql myfile2.sql

Help content

Usage: sqlfluff [OPTIONS] COMMAND [ARGS]...

  SQLFluff is a modular SQL linter for humans.

Options:
  --version   Show the version and exit.
  -h, --help  Show this message and exit.

Commands:
  dialects  Show the current dialects available.
  fix       Fix SQL files.
  format    Autoformat SQL files.
  lint      Lint SQL files via passing a list of files or using stdin.
  parse     Parse SQL files and just spit out the result.
  render    Render SQL files and just spit out the result.
  rules     Show the current rules in use.
  version   Show the version of sqlfluff.

  Examples:

  .. code-block:: sh

     sqlfluff lint --dialect postgres .

     sqlfluff lint --dialect mysql --rules ST05 my_query.sql

     sqlfluff fix --dialect sqlite --rules LT10,ST05 src/queries

     sqlfluff parse --dialect duckdb --templater jinja path/my_query.sql

Installation on mega-linter Docker image

Dockerfile commands :

# renovate: datasource=pypi depName=sqlfluff
ARG SQL_SQLFLUFF_VERSION=3.3.0

PIP packages (Python):
- sqlfluff==${SQL_SQLFLUFF_VERSION}