How to configure .sqruff to avoid spaces inside {{ and function calls without disabling alias alignment?

[18michal]

Hi,

I'm configuring Sqruff with the following .sqruff settings:

[sqruff]
dialect = snowflake
max_line_length = 256
exclude_rules = RF01, LT01
rules = all

[sqruff:indentation]
indent_unit = space
tab_space_size = 4
indented_joins = True

[sqruff:layout:type:alias_expression]
spacing_before = align
align_within = select_clause
align_scope = bracketed

I want to:

• Avoid adding spaces between {{

• Avoid adding spaces after function names like LOWER( and DECIMAL(.

Currently, the rule LT01 causes spaces after functions, but if I exclude it, the alias alignment breaks.

[sqruff]
dialect = snowflake
max_line_length = 256
exclude_rules = RF01, LT01
rules = all

And without LT01 it works fine

What config changes or overrides can I apply to keep alias alignment working and prevent unwanted spaces?

[nikolaevx]

@benfdking do we need to configure the templater?

[benfdking]

We need to finish the dbt templater for this. I expect this not to work because dbt doesn't work yet.

[nastynaz]

@benfdking any update on this?

[benfdking]

The dbt templater now works well.