Need advice about which tool to choose?Ask the StackShare community!
Add tool
dbt vs Liquibase: What are the differences?
dbt: A command line tool that enables data analysts and engineers to transform data in their warehouse more effectively. dbt - Documentation; Liquibase: Source control for your database. Developers store database changes in text-based files on their local development machines and apply them to their local databases. Changelog files can be be arbitrarily nested for better management.
dbt and Liquibase belong to "Database Tools" category of the tech stack.
Liquibase is an open source tool with 1.78K GitHub stars and 1.09K GitHub forks. Here's a link to Liquibase's open source repository on GitHub.
Viadeo, Orbitz, and Virgin Pulse are some of the popular companies that use Liquibase, whereas dbt is used by nurx, Trussle, and Flux Work. Liquibase has a broader approval, being mentioned in 15 company stacks & 12 developers stacks; compared to dbt, which is listed in 3 company stacks and 4 developer stacks.
Get Advice from developers at your company using StackShare Enterprise. Sign up for StackShare Enterprise.
Learn MorePros of dbt
Pros of Liquibase
Pros of dbt
- Easy for SQL programmers to learn3
- CI/CD2
- Schedule Jobs2
- Reusable Macro2
- Faster Integrated Testing2
- Modularity, portability, CI/CD, and documentation2
Pros of Liquibase
- Many DBs supported18
- Great database tool18
- Easy setup12
- Database independent migration scripts8
- Database version controller5
- Unique open source tool5
- Precondition checking2
- Supports NoSQL and Graph DBs1
Sign up to add or upvote prosMake informed product decisions
Cons of dbt
Cons of Liquibase
Cons of dbt
- Only limited to SQL1
- Cant do complex iterations , list comprehensions etc .1
- People will have have only sql skill set at the end1
- Very bad for people from learning perspective1
Cons of Liquibase
- Documentation is disorganized5
- No vendor specifics in XML format - needs workarounds5
Sign up to add or upvote consMake informed product decisions
- No public GitHub repository available -
What is dbt?
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.
What is 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.
Need advice about which tool to choose?Ask the StackShare community!
Jobs that mention dbt and Liquibase as a desired skillset
What companies use dbt?
What companies use Liquibase?
What companies use Liquibase?
See which teams inside your own company are using dbt or Liquibase.
Sign up for StackShare EnterpriseLearn MoreSign up to get full access to all the companiesMake informed product decisions
What tools integrate with dbt?
What tools integrate with Liquibase?
What tools integrate with dbt?
What tools integrate with Liquibase?
Sign up to get full access to all the tool integrationsMake informed product decisions
What are some alternatives to dbt and Liquibase?
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.