.sqlfluff

[sqlfluff]
templater = dbt
dialect = snowflake
exclude_rules = L010, L027, L030, L032, layout.indent, layout.cte_bracket, layout.select_targets, ST06, CV11, AM06
verbose = 0
max_line_length = 160
large_file_skip_byte_limit = 40000
runaway_limit = 10

[sqlfluff:rules]
allow_scalar = True
single_table_references = consistent
unquoted_identifiers_policy = all
capitalisation_policy = upper
extended_capitalisation_policy = upper

[sqlfluff:rules:convention.terminator]
multiline_newline = True

[sqlfluff:indentation]
tab_space_size = 4
indent_unit = space

[sqlfluff:layout:type:comma]
spacing_before = touch
line_position = trailing

[sqlfluff:templater:jinja:context]
dbt_date= {"time_zone": "America/Los_Angeles"}

[sqlfluff:templater:jinja]
apply_dbt_builtins = true

[sqlfluff:templater:jinja:macros]

# Specific Rule rules
[sqlfluff:rules:aliasing.length]
min_alias_length = 4
max_alias_length = None


[sqlfluff:rules:capitalisation.keywords]
capitalisation_policy = upper

[sqlfluff:rules:aliasing.table]
aliasing = explicit

[sqlfluff:rules:aliasing.column]
aliasing = explicit

[sqlfluff:rules:aliasing.expression]
allow_scalar = False

[sqlfluff:rules:capitalisation.identifiers]
extended_capitalisation_policy = lower

[sqlfluff:rules:capitalisation.functions]
capitalisation_policy = upper

[sqlfluff:rules:capitalisation.literals]
capitalisation_policy = upper

[sqlfluff:rules:ambiguous.column_references]  # Number in group by
group_by_and_order_by_style = implicit