Don't forget to specify the dialect of the database your SQL is written in. For instance, if you use postgres:

# File: .sqlfluff
[sqlfluff]

templater = jinja
dialect = postgres

See https://docs.sqlfluff.com/en/stable/reference/dialects.html#postgresql