SQLFluff is an open source, 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.
A modular SQL linter and auto-formatter with support for multiple dialects and templated code.
A14K has a very close relationship with the SQLFluff development community through Alan, who is the original author of the package. We can provide both implementation services for your organisation, and also cost effective sponsored development if open-source features if required for your use case.
But Why?#
Linting is a process of analysing code to find issues and bugs before code is run. It can sometimes be seen as “just consistent formatting”, but consistently formatted code is actually about better communication. It allows your team to see the logic rather than just the code and enables faster and more reliable analytics work within your team.
With teams of more than one person, it can be easy to see why writing code that is easy to read is important - as it smooths collaboration and reduces the risk of miscommunication. However linting is also valuable in single-person teams because it enables faster identification of bugs, and a better protection against context switching.
Why SQLFluff?#
SQLFluff is the de-facto standard SQL linter, by virtue of being free and the most frequently downloaded1. SQLFluff is also supported by platforms like hex or dbt cloud. We recommend all projects using the modern data stack and dbt use SQLFluff and we can include this with almost any of our other services.
Based on PyPi download stats. ↩︎
