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

Model your database diagram

Datascale helps map out data models from existing schema and SQL queries

Try for free

Data Modeling for SQL

Data Modeling for SQL