Amazon Redshift vs SnapLogic comparison

The compared Amazon Web Services (AWS) and SnapLogic solutions aren't in the same category. Amazon Web Services (AWS) is ranked #5 in CDW , with an average rating of 7.6, and holds a 6.8% mindshare in the category. SnapLogic is ranked #9 in PaaS , with an average rating of 7.2, and holds a 4.1% mindshare. Additionally, 86% of Amazon Web Services (AWS) users are willing to recommend the solution, compared to 87% of SnapLogic users who would recommend it.

Amazon Redshift

Read 67 Amazon Redshift reviews

5,352 Views
3,493 Comparison Views

86% willing to recommend

SnapLogic

Read 24 SnapLogic reviews

953 Views
652 Comparison Views

87% willing to recommend

Amazon Redshift

SnapLogic

Comparison Buyer's Guide

Download the report

Executive Summary

We performed a comparison between Amazon Redshift and SnapLogic based on real PeerSpot user reviews.

Find out what your peers are saying about Snowflake Computing, Microsoft, Google and others in Cloud Data Warehouse.

To learn more, read our detailed Cloud Data Warehouse Report (Updated: February 2025).

Buyer's Guide

Cloud Data Warehouse

February 2025

Download the complete report

Helped 838,713 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

Amazon Redshift

Average Rating

7.8

Reviews Sentiment

6.9

Number of Reviews

Ranking in other categories

Cloud Data Warehouse (5th)

SnapLogic

Average Rating

7.8

Reviews Sentiment

7.1

Number of Reviews

Ranking in other categories

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

Mindshare comparison

Amazon Redshift and SnapLogic aren’t in the same category and serve different purposes. Amazon Redshift is designed for Cloud Data Warehouse and holds a mindshare of 6.8%, down 9.7% compared to last year.
SnapLogic, on the other hand, focuses on Integration Platform as a Service (iPaaS), holds 4.1% mindshare, up 3.8% since last year.

Cloud Data Warehouse

Integration Platform as a Service (iPaaS)

Q&A Highlights

it_user698982

Works

Jul 16, 2017

Which ETL or Data Integration tool goes the best with Amazon Redshift?

S3 copy is the best solution to load data into Redshift. I have used Informatica to move data from On premise to S3 and used S3 Copy to load Redshift.

See all answers

Featured Reviews

Ved Prakash Yadav

Senior Data Platform Manager at a manufacturing company with 10,001+ employees

Works as a data warehouse system and collects data from different sources

In terms of improvement, I believe Amazon Redshift could work on reducing its costs, as they tend to increase significantly. Additionally, there are occasional issues with nodes going down, which can be problematic. We often encounter issues like someone dropping a column or changing the order of columns, which can cause synchronization problems when pushing data through our pipeline. It's a minor issue, but it can be annoying.

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

"It allows you write complex queries and perform row by row processes."

"Its simplicity in configuration, cost-effectiveness due to being in the cloud and close to our data sources, and the fact that it's a managed service that is scalable and reliable are highly valuable."

"Redshift allows you to transform different data formats and consolidate them into one Redshift cluster. This means you can transform various siloed data sources like Excel files and CSV files into Redshift."

"The product is relatively easy to use because there is no indexing and no partitions."

"The seamless connection and good scalability on the cloud are valuable features of Amazon Redshift."

"It's very easy to migrate from other databases to Redshift. There are migration tools dedicated for this purpose, enabling migration from other databases like MS SQL directly to Redshift. The majority of the scripts will be automatically transposed."

"The solution's speed, stability, and user concurrency have been very good."

"Redshift is a major service of Amazon and is very scalable. It enables faster recalculations and data management, helping to retrieve data quickly."

More Amazon Redshift pros

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

"SnapLogice is a low-code development tool."

"The solution could improve its API management."

"SnapLogic is a great platform for establishing integrations among various systems or patterns by using any kind of interface. If something is not supported by predefined snaps – snaps are connectors in SnapLogic – you can create them (custom snaps) or write a script."

"The initial setup is very straightforward."

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

"The vendor handles the maintenance of the solution"

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

More SnapLogic pros

Cons

"There is some missing functionality and sometimes it's so difficult to work in. We need to convert these functionalities using VACUUM inside Amazon Redshift and then it causes some complexity."

"One area where Amazon Redshift could improve is in adopting the compute-separate, data-separate architecture, which Delta, Snowflake are adopting, and a few others in the cloud data warehouse spectrum."

"Query compilation time needs a lot of improvement for cases where you are generating queries dynamically."

"The explain panel in the Redshift database could be better."

"The refreshment rate of data reaching Redshift from other sources should be faster."

"The speed of the solution and its portability needs improvement."

"It lacks a few features which can be very useful, such as stored procedures"

"It takes a lot of time to ingest and update the data."

More Amazon Redshift cons

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

"They should expand in terms of features for SaaS-based market requirements in different sectors."

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

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

"The solution isn't ideal for complex processing or logic. We use another solution for that."

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

"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 setup cost would be four or five. There would be only one point of improvement if the price could be lower."

More SnapLogic cons

Pricing and Cost Advice

"The price of the solution is reasonable. According to the RA3 cluster particularly, it provides 128 GB of storage with only four nodes. If you can manage your computations processes with the help of materialized views and proper queries. I think the IP clusters are very useful and overall fair for the price."

"I have heard complaints about the solution’s pricing, and thus I rate it as a five."

"It's around $200 US dollars. There are some data transfer costs but it's minimal, around $20."

"Amazon Redshift is an expensive solution. Larger organizations can afford this solution, but smaller businesses would struggle to afford it."

"At the moment, pricing is a little bit on the higher side, although it depends on the size of the company."

"For Amazon Redshift, we pay around INR 60,000 annually. The cost factor also depends on the number of existing customers."

"This solution implements the pay-as-you-use model, so no license. Pricing could be cheaper."

"It's not very pricey compared to other tools. I would rate the price as 5 out of 10."

More Amazon Redshift pricing and cost advice

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

"The license model is based on consumption."

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

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

"I used the free trial."

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

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

"The pricing is okay."

More SnapLogic pricing and cost advice

See which vendors are best for you

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

See recommendations

838,713 professionals have used our research since 2012.

Answers from the Community

it_user698982

Works

Jul 16, 2017

Which ETL or Data Integration tool goes the best with Amazon Redshift?

S3 copy is the best solution to load data into Redshift. I have used Informatica to move data from On premise to S3 and used S3 Copy to load Redshift.

2 out of 14 answers

it_user130794

Consultant at a tech services company with 1,001-5,000 employees

Jul 13, 2017

Matillion or SAP BODS can be used as etl.

Read full answer

it_user524709

Works

Jul 13, 2017

Informatica is good to go with Redshit, however any open source ETL is good enough. Thanks

Read full answer

See all 14 answers

Top Industries

By visitors reading reviews

Educational Organization

65%

Financial Services Firm

Computer Software Company

Manufacturing Company

Financial Services Firm

26%

Manufacturing Company

11%

Computer Software Company

Real Estate/Law Firm

Company Size

By reviewers

Large Enterprise

Midsize Enterprise

Small Business

Questions from the Community

How does Amazon Redshift compare with Microsoft Azure Synapse Analytics?

Amazon Redshift is very fast, has a very good response time, and is very user-friendly. The initial setup is very straightforward. This solution can merge and integrate well with many different dat...

See all answers

What do you like most about Amazon Redshift?

The tool's most valuable feature is its parallel processing capability. It can handle massive amounts of data, even when pushing hundreds of terabytes, and its scaling capabilities are good.

See all answers

What is your experience regarding pricing and costs for Amazon Redshift?

I have no idea about pricing.

See all answers

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.

See all answers

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

See all answers

What is your primary use case for SnapLogic?

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

See all answers

Comparisons

Teradata vs Amazon Redshift

Compared 16% of the time

Snowflake vs Amazon Redshift

Compared 11% of the time

Oracle Exadata vs Amazon Redshift

Compared 11% of the time

AWS Lake Formation vs Amazon Redshift

Compared 10% of the time

Vertica vs Amazon Redshift

Compared 10% of the time

More Amazon Redshift Competitors

AWS Glue vs SnapLogic

Compared 16% of the time

IBM InfoSphere DataStage vs SnapLogic

Compared 8% of the time

Azure Data Factory vs SnapLogic

Compared 8% of the time

Alteryx Designer vs SnapLogic

Compared 7% of the time

Informatica Intelligent Data Management Cloud (IDMC) vs SnapLogic

Compared 6% of the time

More SnapLogic Competitors

Product Reports

Buyer's Guide

Amazon Redshift

February 2025

Download Amazon Redshift product report

Buyer's Guide

SnapLogic

January 2025

Download SnapLogic product report

Also Known As

No data available

DataFlow

Overview

What is Amazon Redshift?

Amazon Redshift is a fully administered, petabyte-scale cloud-based data warehouse service. Users are able to begin with a minimal amount of gigabytes of data and can easily scale up to a petabyte or more as needed. This will enable them to utilize their own data to develop new intuitions on how to improve business processes and client relations.

Initially, users start to develop a data warehouse by initiating what is called an Amazon Redshift cluster or a set of nodes. Once the cluster has been provisioned, users can seamlessly upload data sets, and then begin to perform data analysis queries. Amazon Redshift delivers super-fast query performance, regardless of size, utilizing the exact SQL-based tools and BI applications that most users are already working with today.

The Amazon Redshift service performs all of the work of setting up, operating, and scaling a data warehouse. These tasks include provisioning capacity, monitoring and backing up the cluster, and applying patches and upgrades to the Amazon Redshift engine.

Amazon Redshift Functionalities

Amazon Redshift has many valuable key functionalities. Some of its most useful functionalities include:

Cluster administration: The Amazon Redshift cluster is a group of nodes that contains a leader node and one (or more) compute node(s). The compute nodes needed are dependent on the data size, amount of queries needed, and the query execution functionality desired.
Cluster snapshots: Snapshots are backups of a cluster from an exact point in time. Amazon Redshift offers two types of snapshots: manual and automated. Amazon will store these snapshots internally in the Amazon Simple Storage Service (Amazon S3) utilizing an SSL connection. Whenever a Snapshot restore is needed, Amazon Redshift will create a new cluster and will import data from the snapshot as directed.
Cluster access: Amazon Redshift provides several intuitive features to help define connectivity rules, encrypt data and connections, and control the overall access of your cluster.
IAM credentials and AWS accounts: The Amazon Redshift cluster is only accessible by the AWS account that created the cluster. This automatically secures the cluster and keeps it safe. Inside the AWS account, users access the AWS Identity and IAM protocol to create additional user accounts and manage permissions, granting specified users the desired access needed to control cluster performance.
Encryption: Users have the option to choose to encrypt the clusters for additional added security once the cluster is provisioned. When encryption is enabled, Amazon Redshift will store all the data in user-created tables in a secure encrypted format. To manage Amazon Redshift encryption keys, users will access AWS Key Management Service (AWS KMS).

Reviews from Real Users

“Redshift's versioning and data security are the two most critical features. When migrating into the cloud, it's vital to secure the data. The encryption and security are there.” - Kundan A., Senior Consultant at Dynamic Elements AS

“With the cloud version whenever you want to deploy, you can scale up, and down, and it has a data warehousing capability. Redshift has many features. They have enriched and elaborate documentation that is helpful.”- Aishwarya K., Solution Architect at Capgemini

Amazon Web Services (AWS)

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.

SnapLogic

Sample Customers

Liberty Mutual Insurance, 4Cite Marketing, BrandVerity, DNA Plc, Sirocco Systems, Gainsight, Blue 449

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

Find out what your peers are saying about Snowflake Computing, Microsoft, Google and others in Cloud Data Warehouse. Updated: February 2025.

DOWNLOAD NOW

838,713 professionals have used our research since 2012.

We monitor all Cloud Data Warehouse reviews to prevent fraudulent reviews and keep review quality high. We do not post reviews by company employees or direct competitors. We validate each review for authenticity via cross-reference with LinkedIn, and personal follow-up with the reviewer when necessary.