Need advice about which tool to choose?Ask the StackShare community!
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.
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
- 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