Need advice about which tool to choose?Ask the StackShare community!
dbt vs Slick: 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; Slick: Database query and access library for Scala. 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.
dbt and Slick can be categorized as "Database" tools.
Slick is an open source tool with 2.27K GitHub stars and 542 GitHub forks. Here's a link to Slick's open source repository on GitHub.
orat.io, Massdrop, and SpringRole are some of the popular companies that use Slick, whereas dbt is used by nurx, Trussle, and Flux Work. Slick has a broader approval, being mentioned in 7789 company stacks & 4 developers stacks; compared to dbt, which is listed in 4 company stacks and 8 developer stacks.
Pros of dbt
- Easy for SQL programmers to learn5
- CI/CD2
- Schedule Jobs2
- Reusable Macro2
- Faster Integrated Testing2
- Modularity, portability, CI/CD, and documentation2
Pros of Slick
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