Table of Contents

  1. Data transformation
  2. Data testing
  3. Implementations + deployment
  4. Documentation + metadata
  5. The modern data stack
  6. Data dream teams

Presenting: SQLFluff

Alan is one of the 2020 UK DataIQ100 and leads the data team at tails.com. Founded in 2014, the online, direct-to-consumer, pet-nutrition business now feeds over 150,000 dogs across Europe. His team has been using dbt since early 2018 and have been active members of the dbt community, presenting both at London dbt meetups and as part of dbt office hours. In his spare time, he has been wrangling with the challenge of shepherding the growing open source community around SQLFluff, a SQL linter for humans.

Originally presented on 2020-12-13

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...?

Join this session to find out whether SQLFluff might help your teams be more productive with SQL.

Browse this talk’s Slack archives #

The day-of-talk conversation is archived here in dbt Community Slack.

Not a member of the dbt Community yet? You can join here to view the Coalesce chat archives.