SnapLogic vs dbt comparison

Read 24 SnapLogic reviews

2,288 Views
1,395 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: June 2025).

Download the complete report

SnapLogic vs. dbt

June 2025

Helped 856,873 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

37th

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

18th

Average Rating

7.8

Reviews Sentiment

7.1

Number of Reviews

Ranking in other categories

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

Mindshare comparison

As of June 2025, in the Data Integration category, the mindshare of dbt is 1.8%, up from 0.0% compared to the previous year. The mindshare of SnapLogic is 1.4%, down from 1.6% compared to the previous year. It is calculated based on PeerSpot user engagement data.

Data Integration

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."

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

"The solution is easy to implement and easy to use. It's basically just drag and drop."

"What I found most valuable in SnapLogic is the ETL feature, particularly the Transform Snap Pack, for example, any kind of reading or writing on Transform Snaps. Other than that, all the third-party connectivity tools such as the SAP Snap Pack, Salesforce Snap Pack, Workday Snap Pack, even the ServiceNow Snap Pack, I find all those are pretty useful in SnapLogic."

"By using snaps instead of functions in code, you can see the building blocks of the integration visually. This helps a lot."

"The solution could improve its API management."

"Overall product rating is nine out of ten."

"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."

"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."

More SnapLogic pros

Cons

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

"SnapLogic sits somewhere in the middle. It doesn’t offer enough easy canned integrations for its users like some of the easier to use integration apps."

"While it performs well, there is some room for improvement in this area."

"Ultra Pipelines provides real-time ingestion but it needs some adjustment."

"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."

"What could be improved in SnapLogic is that it was not capable in terms of processing a large number of datasets, but at that point, SnapLogic was evolving. It didn't give a lot of Snaps. I heard recently there are a lot of Snaps getting added and the solution was being enhanced, particularly to connect different data sources. When I was working with SnapLogic six months to one year back, I faced the issue of it not being capable of handling a huge volume of datasets or didn't have much of Snaps, and that was the drawback. If there is any large number of data sets, that's based on or depends on your configuration. If it is a huge volume of data, other traditional ETL tools such as Informatica and Talend can process millions and billions of records, while in SnapLogic, the Snaplex fails or it returns an error in terms of processing that huge volume of data. Informatica, Talend, or any other ETL tool can run for hours in terms of jobs, while SnapLogic jobs fail when the threshold is reached. SnapLogic isn't able to withstand processing, but I don't know if that's still an issue at present, because the solution is getting enhanced and it's been more than six months to one year since I last worked with SnapLogic. There are now a lot of Snaps getting added to the solution, and if it can overcome the limitations I mentioned, SnapLogic could be the go-to tool because currently, it's not being used as much in organizations. It's being used comparatively less compared to other retail tools."

"It needs some more snaps. I would like to see some of the features be changed in some of the snaps."

"There is room for improvement with APM management and how task execution looks."

"I don't think the support has better knowledge about technologies and tool support. There were lots of times when we had an issue, and it took me quite a long time to explain the problem. I feel like some of the support staff don't know their product well."

More SnapLogic cons

Pricing and Cost Advice

"The solution’s pricing is affordable."

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

"It is a higher initial cost than other easy-to-use integration apps."

"The pricing is okay."

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

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

"I used the free trial."

"The license model is based on consumption."

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

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

856,873 professionals have used our research since 2012.

Top Industries

By visitors reading reviews

Financial Services Firm

14%

Insurance Company

12%

Healthcare Company

Computer Software Company

Financial Services Firm

24%

Manufacturing Company

11%

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 29% of the time

Compared 14% of the time

Tobiko vs dbt

Compared 7% of the time

Oracle Data Integrator (ODI) vs dbt

Compared 7% of the time

SAP Data Services vs dbt

Compared 3% of the time

More dbt Competitors

AWS Glue vs SnapLogic

Compared 16% of the time

IBM InfoSphere DataStage vs SnapLogic

Compared 6% of the time

Alteryx Designer vs SnapLogic

Compared 6% of the time

MuleSoft Anypoint Platform vs SnapLogic

Compared 5% of the time

Pentaho Data Integration and Analytics vs SnapLogic

Compared 5% of the time

More SnapLogic Competitors

Product Reports

Download dbt product report

Data Integration

June 2025

Download SnapLogic product report

May 2025

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!