Introducing SQL Linter with SQLFluff

Automatically validate and fix SQL for you. Never worry about anti-pattern code again.

Automatically validate and fix SQL for you. Never worry about anti-pattern code again.

Poom Wettayakorn

Oct 16, 2023

Oct 16, 2023

changelog

👋 Hi there, welcome to Datascale: SQL+Data modeling. We help create database diagrams and map out data models from existing schema and SQL queries 🌱. Find us on LinkedIn 🎉

What's new

We’re happy to announce our new feature, the 🧙‍♂️ "SQL Linter"

  • 🪄 This will automatically validate and fix SQL for you.

  • 🫣 Never worry about anti-pattern code again.

Watch on Youtube https://youtu.be/AlLBrn1n5s4

What's SQLFluff

"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.", https://sqlfluff.com/

Auto formatting the code

Detect anti-pattern queries and show rules reference

Learn more about Rules Reference

https://docs.sqlfluff.com/en/stable/rules.html

Example rule: RF04

https://docs.sqlfluff.com/en/stable/rules.html#rule-RF04

Contents

Section

Get a clear view of your SQL dependencies

Datascale helps reverse engineer data models from existing schema and SQL queries

Learn more

Where data gets modeled

Where data gets modeled

Where data gets modeled