How to change max_line_length when running a DBT project?

Question

I have a problem when run a DBT project. Some of my SQL commands are longer then the limit (80). So I have got the following error info:

I have tried to change the limit in dbt_project.yml and .sqlfluff. But none of the worked.

How to fix this problem and change the length limit?

Answer 1

That's a linter-related issue, so most probably nothing to do with your dbt_project.yml.

In order to correctly set a max_line_length value in your .sqlfluff file, you need to nest it under the [sqlfluff] tag. Meaning that your .sqlfluff file should look like this:

[sqlfluff]
dialect = snowflake
exclude_rules = L031
max_line_length = 120

See this example for SQLFluff's docs here.