dbt vs SQLFluff

Overview

dbt

Stacks517

Followers461

Votes16

SQLFluff

Stacks17

Followers5

Votes0

GitHub Stars9.3K

Forks895

Share your Stack

Help developers discover the tools you use. Get visibility for your team's tech choices and contribute to the community's knowledge.

View Docs

CLI (Node.js)

Manual

Detailed Comparison

dbt	SQLFluff
dbt is a transformation workflow that lets teams deploy analytics code following software engineering best practices like modularity, portability, CI/CD, and documentation. Now anyone who knows SQL can build production-grade data pipelines.	It is an extensible and modular linter designed to help you write good SQL and catch errors and bad SQL before it hits your database.
Code compiler; Package management; Seed file loader; Data snapshots; Understand raw data sources; Tests; Documentation; CI/CD	Dialect-flexible and configurable SQL linter; Works with jinja templating and dbt; Auto-fix most linting errors
Statistics
GitHub Stars -	GitHub Stars 9.3K
GitHub Forks -	GitHub Forks 895
Stacks 517	Stacks 17
Followers 461	Followers 5
Votes 16	Votes 0
Pros & Cons
Pros 5 Easy for SQL programmers to learn 3 Reusable Macro 2 CI/CD 2 Modularity, portability, CI/CD, and documentation 2 Faster Integrated Testing Cons 1 Only limited to SQL 1 Very bad for people from learning perspective 1 People will have have only sql skill set at the end 1 Cant do complex iterations , list comprehensions etc .	No community feedback yet
Integrations
Exasol Snowflake Materialize Presto Amazon Redshift Google BigQuery PostgreSQL Apache Spark Dremio Databricks	Python Jinja

What are some alternatives to dbt, SQLFluff?

dbForge Studio for MySQL

It is the universal MySQL and MariaDB client for database management, administration and development. With the help of this intelligent MySQL client the work with data and code has become easier and more convenient. This tool provides utilities to compare, synchronize, and backup MySQL databases with scheduling, and gives possibility to analyze and report MySQL tables data.

dbForge Studio for Oracle

It is a powerful integrated development environment (IDE) which helps Oracle SQL developers to increase PL/SQL coding speed, provides versatile data editing tools for managing in-database and external data.

dbForge Studio for PostgreSQL

It is a GUI tool for database development and management. The IDE for PostgreSQL allows users to create, develop, and execute queries, edit and adjust the code to their requirements in a convenient and user-friendly interface.

Code Climate

After each Git push, Code Climate analyzes your code for complexity, duplication, and common smells to determine changes in quality and surface technical debt hotspots.

Codacy

Codacy automates code reviews and monitors code quality on every commit and pull request on more than 40 programming languages reporting back the impact of every commit or PR, issues concerning code style, best practices and security.

Phabricator

Phabricator is a collection of open source web applications that help software companies build better software.

dbForge Studio for SQL Server

It is a powerful IDE for SQL Server management, administration, development, data reporting and analysis. The tool will help SQL developers to manage databases, version-control database changes in popular source control systems, speed up routine tasks, as well, as to make complex database changes.

Liquibase

Liquibase is th leading open-source tool for database schema change management. Liquibase helps teams track, version, and deploy database schema and logic changes so they can automate their database code process with their app code process.