Skip to content
0:00 / 0:00

#sqlfluff#dbt#linter

Presenting: SQLFluff

dbt Labs

17K subscribers • 2 videos on Hallway

YouTube
  • Recommended by 1 person: 1 in engineering communities.
  • Presented by Alan Cruickshank

Intermediate. Assumes working knowledge.

15K views5 years ago1 recommendation

Tools and practiceDatabases and dataData engineering and warehousesTestingSQL

Alan Cruickshank introduces SQLFluff, an open-source SQL linter designed to help teams maintain consistent SQL codebases.

The dbt project at tails.com has over 600 models and 66k lines of code. With multiple contributors to a project and varying SQL backgrounds, it's really difficult to maintain consistent readability and comprehension across a codebase like that by hand. Python has flake8, Javascript has JSLint, but SQL...? Listen to this talk from Alan Cruickshank to find out whether SQLFluff might help your teams be more productive with SQL.

Why it's here

1 person recommends this

What people say. Recommended as a key tool for maintaining SQL code quality in data pipelines.

u/Jwelch25in r/dataengineering • Recommends

Data-Ops-ish Design and Workflow Walkthrough In another thread, u/brendersplide asked about building a regression test suite. In response to my comment, there were a few individuals who wanted to know more about the system I am currently running. ( u/isleepbad and u/htrp) It's more than what should be in a reply so I thought I would do a post for anyone else interested. WARNING: This is a long post. DISCLAIMER: This is, by no means, the best way to do things. We are constantly evolving and tweaking. As a little context, I run data and analytics at a start-up-ish financial company and have a very small team. In order to combat that constraint, we have done a lot to automate our workflow.…