Skip to main content

Module rules

Module rules 

Source
Expand description

Lint rule implementations and registry.

Modules§

al_001
LINT_AL_001: Table alias style.
al_002
LINT_AL_002: Column alias style.
al_003
LINT_AL_003: Implicit column alias.
al_004
LINT_AL_004: Unique table alias.
al_005
LINT_AL_005: Unused table alias.
al_006
LINT_AL_006: Alias length.
al_007
LINT_AL_007: Forbid unnecessary alias.
al_008
LINT_AL_008: Unique column alias.
al_009
LINT_AL_009: Self alias column.
am_001
LINT_AM_001: DISTINCT with GROUP BY.
am_002
LINT_AM_002: Bare UNION quantifier.
am_003
LINT_AM_003: Ambiguous ORDER BY direction.
am_004
LINT_AM_004: Ambiguous column count (SQLFluff AM04 parity).
am_005
LINT_AM_005: Ambiguous JOIN style.
am_006
LINT_AM_006: Ambiguous column references.
am_007
LINT_AM_007: Ambiguous set-operation columns.
am_008
LINT_AM_008: Ambiguous JOIN condition.
am_009
LINT_AM_009: LIMIT/OFFSET without ORDER BY.
cp_001
LINT_CP_001: Keyword capitalisation.
cp_002
LINT_CP_002: Identifier capitalisation.
cp_003
LINT_CP_003: Function capitalisation.
cp_004
LINT_CP_004: Literal capitalisation.
cp_005
LINT_CP_005: Type capitalisation.
cv_001
LINT_CV_001: Not-equal style.
cv_002
LINT_CV_002: prefer COALESCE over IFNULL/NVL.
cv_003
LINT_CV_003: Select trailing comma.
cv_004
LINT_CV_004: Prefer COUNT(*) over COUNT(1).
cv_005
LINT_CV_005: Prefer IS [NOT] NULL over =/<> NULL.
cv_006
LINT_CV_006: Statement terminator.
cv_007
LINT_CV_007: Statement brackets.
cv_008
LINT_CV_008: Prefer LEFT JOIN over RIGHT JOIN.
cv_009
LINT_CV_009: Blocked words.
cv_010
LINT_CV_010: Consistent usage of preferred quotes for quoted literals.
cv_011
LINT_CV_011: Casting style.
cv_012
LINT_CV_012: JOIN condition convention.
jj_001
LINT_JJ_001: Jinja padding.
lt_001
LINT_LT_001: Layout spacing.
lt_002
LINT_LT_002: Layout indent.
lt_003
LINT_LT_003: Layout operators.
lt_004
LINT_LT_004: Layout commas.
lt_005
LINT_LT_005: Layout long lines.
lt_006
LINT_LT_006: Layout functions.
lt_007
LINT_LT_007: Layout CTE bracket.
lt_008
LINT_LT_008: Layout CTE newline.
lt_009
LINT_LT_009: Layout select targets.
lt_010
LINT_LT_010: Layout select modifiers.
lt_011
LINT_LT_011: Layout set operators.
lt_012
LINT_LT_012: Layout end of file.
lt_013
LINT_LT_013: Layout start of file.
lt_014
LINT_LT_014: Layout keyword newline.
lt_015
LINT_LT_015: Layout newlines.
rf_001
LINT_RF_001: References from.
rf_002
LINT_RF_002: References qualification.
rf_003
LINT_RF_003: References consistency.
rf_004
LINT_RF_004: References keywords.
rf_005
LINT_RF_005: References special chars.
rf_006
LINT_RF_006: References quoting.
st_001
LINT_ST_001: Unnecessary ELSE NULL in CASE expressions.
st_002
LINT_ST_002: Unnecessary CASE statement.
st_003
LINT_ST_003: Unused CTE.
st_004
LINT_ST_004: Flattenable nested CASE in ELSE.
st_005
LINT_ST_005: Structure subquery.
st_006
LINT_ST_006: Structure column order.
st_007
LINT_ST_007: Avoid JOIN … USING (…).
st_008
LINT_ST_008: Structure distinct.
st_009
LINT_ST_009: Reversed JOIN condition ordering.
st_010
LINT_ST_010: Constant boolean predicate.
st_011
LINT_ST_011: Unused joined source.
st_012
LINT_ST_012: Structure consecutive semicolons.
tq_001
LINT_TQ_001: TSQL sp_ prefix.
tq_002
LINT_TQ_002: TSQL procedure BEGIN/END block.
tq_003
LINT_TQ_003: TSQL empty batch.

Functions§

all_rules
Returns all available lint rules.