SnapLogic vs dbt comparison

Read 24 SnapLogic reviews

2,461 Views
1,692 Comparison Views

87% willing to recommend

dbt

Comparison Buyer's Guide

Download the report

Executive SummaryUpdated on Dec 19, 2024

SnapLogic and dbt are competing in the data integration and transformation category. SnapLogic stands out for its integration capabilities, while dbt has an advantage in transformation tools due to its detailed data processing features.

Features: SnapLogic offers pre-built connectors, a straightforward integration platform, and robust cloud integration features, making it a great fit for businesses needing efficient data movement. dbt provides strong transformation capabilities, focusing on data modeling and customization through SQL-based models, and benefits from its open-source transformation framework that supports detailed processing.

Ease of Deployment and Customer Service: SnapLogic offers faster deployment times and responsive customer service, aiding quick adoption. dbt deployment is efficient but requires more technical expertise. Its customer support is well-regarded but may involve more self-service to solve issues.

Pricing and ROI: SnapLogic has a higher initial setup cost due to its extensive integration features, but this is seen as reasonable given the efficiency and scalability it provides. dbt is more cost-effective initially, appealing to companies prioritizing detailed data transformation with the potential for enhancing long-term ROI.

To learn more, read our detailed SnapLogic vs. dbt Report (Updated: March 2025).

SnapLogic vs. dbt

Download the complete report

Helped 845,406 peers since 2012

Review summaries and opinions

We asked business professionals to review the solutions they use. Here are some excerpts of what they said:

Categories and Ranking

dbt

Ranking in Data Integration

38th

Average Rating

7.6

Reviews Sentiment

7.4

Number of Reviews

Ranking in other categories

No ranking in other categories

SnapLogic

Ranking in Data Integration

21st

Average Rating

7.8

Reviews Sentiment

7.1

Number of Reviews

Ranking in other categories

Process Automation (15th), Cloud Data Integration (12th), Integration Platform as a Service (iPaaS) (10th)

Featured Reviews

Ninad Magdum

Senior Machine Learning Engineer at Happiest Minds Technologies

Developer-friendly and easy to use, but doesn't have many optimization options

We also use stored procedures and Talend. They are not replaced by dbt completely. We use dbt only for the transformation process. My recommendations would depend on an organization’s requirements and problems. I will recommend the tool to others. The product is developer-friendly. However, it is still dependent on the data warehouse for big data and optimization. It's just a SQL transformation tool. It doesn't have a lot of optimization options like Spark. It's a good tool for Snowflake. If it were only for Snowflake, I would have rated it an eight out of ten. However, there are other data platforms. Overall, I rate the tool a six and a half out of ten.

Read full review

VinethSuresh

Senior Data Analyst at a pharma/biotech company with 10,001+ employees

Achieves rapid results in data migration and has an intuitive user interface

I find SnapLogic to be user-friendly, especially for beginners with limited experience in data engineering or ETL. The interface is interactive, allowing me to quickly learn how to run pipelines and achieve production-ready results swiftly. This agility translates to cost savings, especially for smaller projects and proofs of concept, as less time and effort are needed to deliver results.

Read full review

Quotes from Members

We asked business professionals to review the solutions they use. Here are some excerpts of what they said:

Pros

"The product is developer-friendly."

"SnapLogic is an IPA tool that leverages a low code environment to connect to multiple sources, extract data, and store it in Azure data lake."

"They are very good at building out new aspects according to customer requirements."

"I find SnapLogic to be user-friendly, especially for beginners with limited experience in data engineering or ETL."

"It's more developer-friendly, and development can be done at a faster phase."

"The feature I found most valuable in SnapLogic is low-code development. Low-code development has been very useful for simple processes, which is required for business users such as extracting details from a file or getting things reported by calling your web service. Calling your web service also becomes easier with SnapLogic because of the snaps available, so if you have the documentation, you can call an API. You don't have to write all those clients to call an API, so that is another feature I found very easy in SnapLogic. Configuring and managing all the file systems also become very handy with the solution."

"The solution could improve its API management."

"I found SnapLogic valuable and what I found most valuable about it was its ETL feature. I also found its automation feature valuable. It can be used for automating manual activities. It can be used as a middleware for certain transactional data processing and minimal datasets and ETL activities."

"The solutions ability to connect "snaps" or components to the graphic user interface is very intuitive, prevents errors, and makes implementations easy."

More SnapLogic pros

Cons

"The solution must add more Python-based implementations."

"I am looking for more scheduling options. When it comes to scheduling, there are different tools in the market."

"The dashboards regarding scheduled tasks need further improvement."

"If the AI capabilities and integrations were more intuitive and easy for new users to learn, it would be greatly beneficial."

"While new features are always welcome, I do not have anything else at the top of my mind currently."

"SnapLogic doesn't provide any on-premises software, so users have only cloud-based software to use."

"I would like to see more performance-related dashboards, ones that display the cost of a pipeline, for instance. Also, it would be helpful to have management dashboards for overseeing pipelines and connections."

"The support is the most important improvement they could make."

"One of the areas for improvement in SnapLogic is that the connectors for some of the applications should be more available in terms of testing in the dev environment. Another area for improvement is that the logging should be standardized, for example, the integration with an ELK stack should be required out-of-the-box, so you can ship the log and have it in the ELK stack. There should be integration with ELK stack for the log shipping."

More SnapLogic cons

Pricing and Cost Advice

"The solution’s pricing is affordable."

"When comparing it with solutions like Apigee or MuleSoft, it still offers better value."

"By scaling the solution incrementally the cost is controlled and more beneficial to the client."

"From the ROI perspective, the price is extremely high"

"They have pricing/usage tiers that are easy to move up or down."

"The cost with SnapLogic is an annual license and better than Informatica."

"SnapLogic is not expensive. It's reasonably priced."

"SnapLogic's price is high compared to the other tools available in the market."

"The license model is based on consumption."

More SnapLogic pricing and cost advice

See which vendors are best for you

Use our free recommendation engine to learn which Data Integration solutions are best for your needs.

See recommendations

845,406 professionals have used our research since 2012.

Top Industries

By visitors reading reviews

Financial Services Firm

15%

Insurance Company

10%

Healthcare Company

Computer Software Company

Financial Services Firm

25%

Manufacturing Company

10%

Computer Software Company

Real Estate/Law Firm

Company Size

By reviewers

Large Enterprise

Midsize Enterprise

Small Business

No data available

Questions from the Community

What is your experience regarding pricing and costs for dbt?

It is cheap because dbt is open source. If you compare the pay-per-service of Dbt with the open source option you can manage. We are managing the solution, when we were acquiring service from them....

What needs improvement with dbt?

SQL statements that beyond DML, are not possible. Currently, they are not possible in Dbt. Having more features in SQL statements will support us. Another issue is the terms of data ingestion becau...

What is your primary use case for dbt?

We use the solution to deal with data transformations inside different organizations.

What do you like most about SnapLogic?

Despite having no prior experience in SnapLogic, we managed to build, test, and prepare it for release in just three hours, handling heavy data efficiently.

What needs improvement with SnapLogic?

I am quite happy with the solution and do not have specific requirements at the moment. I tend to frequently communicate with SnapLogic to ask for additional features, and they have been responsive...

What is your primary use case for SnapLogic?

I mainly use it for data integration and some API tasks.

Informatica PowerCenter vs dbt

Comparisons

SSIS vs dbt

Compared 28% of the time

Compared 16% of the time

Tobiko vs dbt

Compared 8% of the time

Palantir Foundry vs dbt

Compared 7% of the time

Azure Data Factory vs dbt

Compared 4% of the time

More dbt Competitors

AWS Glue vs SnapLogic

Compared 16% of the time

IBM InfoSphere DataStage vs SnapLogic

Compared 8% of the time

Alteryx Designer vs SnapLogic

Compared 6% of the time

Azure Data Factory vs SnapLogic

Compared 5% of the time

More SnapLogic Competitors

Product Reports

Data Integration

Download dbt product report

Download SnapLogic product report

Also Known As

No data available

DataFlow

Overview

dbt is a transformational tool that empowers data teams to quickly build trusted data models, providing a shared language for analysts and engineering teams. Its flexibility and robust feature set make it a popular choice for modern data teams seeking efficiency.

Designed to integrate seamlessly with the data warehouse, dbt enables analytics engineers to transform raw data into reliable datasets for analysis. Its SQL-centric approach reduces the learning curve for users familiar with it, allowing powerful transformations and data modeling without needing a custom backend. While widely beneficial, dbt could improve in areas like version management and support for complex transformations out of the box.

What are the most valuable features of dbt?

SQL-Based Development: Facilitates transformations using SQL, streamlining the data modeling process.
Modularity: Encourages reusable components, making projects easier to manage and scale.
Version Control: Integrates with version control systems to track changes and collaborate effectively.
Testing Framework: Ensures data quality through automated tests, increasing trust in data outputs.

What benefits should you expect from using dbt?

Efficiency: Cuts down data processing times, allowing faster access to insights.
Collaboration: Promotes teamwork through shared data models and a common working language.
Scalability: Supports growing data demands by transforming complex data more flexibly and modularly.
Transparency: Provides clear documentation and lineage tracking, aiding in troubleshooting and understanding.

In the finance industry, dbt helps in cleansing and preparing transactional data for analysis, leading to more accurate financial reporting. In e-commerce, it empowers teams to rapidly integrate and analyze customer behavior data, optimizing marketing strategies and improving user experience.

dbt Labs

The SnapLogic Intelligent Integration Platform uses AI-powered workflows to automate all stages of IT integration projects – design, development, deployment, and maintenance – whether on-premises, in the cloud, or in hybrid environments. The platform’s easy-to-use, self-service interface enables both expert and citizen integrators to manage all application integration, data integration, API management, B2B integration, and data engineering projects on a single, scalable platform. With SnapLogic, organizations can connect all of their enterprise systems quickly and easily to automate business processes, accelerate analytics, and drive transformation.

Sample Customers

Information Not Available

Adobe, ADP, BlackBerry, Bonobos, Box, Capital One, Dannon, Eero, Endo, Gensler, HCL, HP, Grovo, HIS, iRobot, Leica, Merck, Sans, Target, Verizon, Vodafone, Yelp, Yahoo!

SnapLogic vs. dbt