SQLFluff

[amotl]

About

The SQL Linter for Humans.

SQLFluff is a dialect-flexible and configurable SQL linter. Designed with ELT applications in mind, SQLFluff also works with Jinja templating and dbt. SQLFluff will auto-fix most linting errors, allowing you to focus your time on what matters.

Resources

• https://sqlfluff.com/
• https://github.com/sqlfluff

References

• QA: Interoperability with Datacoves dbt-cratedb2#16
• Dagster #210

[amotl]

Tutorials

Learning material around SQLFluff.

• SQL linter with sqlfluff and CI/CD
  Getting familiar with the sqlfluff package. Create the sqlfluff config files. Setting up a CI/CD job in GitLab to fix your formatting once you create an MR.

• fs-sql-linter
  This repository contains a setup for linting SQL files using SQLFluff with separate configurations for MySQL and Snowflake dialects.

This is a living post. Please edit and add items as we go.

[amotl]

Update 2025-06

@karynzv asked about it recently, and we also need SQLFluff support for unlocking CrateDB as a dlt destination per DLT-2733, at this and other spots.