Need advice about which tool to choose?Ask the StackShare community!

dbt

179
184
+ 1
1
Flyway

222
425
+ 1
29
Add tool

dbt vs Flyway: What are the differences?

Developers describe dbt as "A command line tool that enables data analysts and engineers to transform data in their warehouse more effectively". dbt - Documentation. On the other hand, Flyway is detailed as "Database Migrations Made Easy". Easy to setup, simple to master. Flyway lets you regain control of your database migrations with pleasure and plain sql. Solves only one problem and solves it well. Flyway migrates your database, so you don't have to worry about it anymore.

dbt and Flyway belong to "Database Tools" category of the tech stack.

Flyway is an open source tool with 4.2K GitHub stars and 915 GitHub forks. Here's a link to Flyway's open source repository on GitHub.

JustWatch, Red Panda Platform, and Picnic Technologies are some of the popular companies that use Flyway, whereas dbt is used by nurx, Trussle, and Flux Work. Flyway has a broader approval, being mentioned in 15 company stacks & 19 developers stacks; compared to dbt, which is listed in 3 company stacks and 4 developer stacks.

Get Advice from developers at your company using Private StackShare. Sign up for Private StackShare.
Learn More
Pros of dbt
Pros of Flyway
  • 1
    Easy for SQL programmers to learn
  • 11
    Superb tool, easy to configure and use
  • 9
    Very easy to config, great support on plain sql scripts
  • 5
    Is fantastic and easy to install even with complex DB
  • 4
    Simple and intuitive

Sign up to add or upvote prosMake informed product decisions

Cons of dbt
Cons of Flyway
    Be the first to leave a con
    • 2
      "Undo Migrations" requires pro version, very expensive

    Sign up to add or upvote consMake informed product decisions

    - No public GitHub repository available -

    What is dbt?

    It enables analytics engineers to transform data in their warehouses by simply writing select statements. It handles turning these select statements into tables and views.

    What is Flyway?

    It lets you regain control of your database migrations with pleasure and plain sql. Solves only one problem and solves it well. It migrates your database, so you don't have to worry about it anymore.

    Need advice about which tool to choose?Ask the StackShare community!

    What companies use dbt?
    What companies use Flyway?
    See which teams inside your own company are using dbt or Flyway.
    Sign up for Private StackShareLearn More

    Sign up to get full access to all the companiesMake informed product decisions

    What tools integrate with dbt?
    What tools integrate with Flyway?

    Sign up to get full access to all the tool integrationsMake informed product decisions

    What are some alternatives to dbt and Flyway?
    act
    Rather than having to commit/push every time you want test out the changes you are making to your .github/workflows/ files (or for any changes to embedded GitHub actions), you can use this tool to run the actions locally. The environment variables and filesystem are all configured to match what GitHub provides.
    Airflow
    Use Airflow to author workflows as directed acyclic graphs (DAGs) of tasks. The Airflow scheduler executes your tasks on an array of workers while following the specified dependencies. Rich command lines utilities makes performing complex surgeries on DAGs a snap. The rich user interface makes it easy to visualize pipelines running in production, monitor progress and troubleshoot issues when needed.
    Looker
    We've built a unique data modeling language, connections to today's fastest analytical databases, and a service that you can deploy on any infrastructure, and explore on any device. Plus, we'll help you every step of the way.
    Apache Spark
    Spark is a fast and general processing engine compatible with Hadoop data. It can run in Hadoop clusters through YARN or Spark's standalone mode, and it can process data in HDFS, HBase, Cassandra, Hive, and any Hadoop InputFormat. It is designed to perform both batch processing (similar to MapReduce) and new workloads like streaming, interactive queries, and machine learning.
    Slick
    It is a modern database query and access library for Scala. It allows you to work with stored data almost as if you were using Scala collections while at the same time giving you full control over when a database access happens and which data is transferred.
    See all alternatives