Try our new research platform with insights from 80,000+ expert users

AWS Lake Formation vs Amazon Redshift comparison

 

Comparison Buyer's Guide

Executive SummaryUpdated on Oct 8, 2024
 

Categories and Ranking

Amazon Redshift
Ranking in Cloud Data Warehouse
4th
Average Rating
7.8
Reviews Sentiment
7.4
Number of Reviews
66
Ranking in other categories
No ranking in other categories
AWS Lake Formation
Ranking in Cloud Data Warehouse
12th
Average Rating
7.6
Number of Reviews
8
Ranking in other categories
No ranking in other categories
 

Mindshare comparison

As of November 2024, in the Cloud Data Warehouse category, the mindshare of Amazon Redshift is 7.7%, down from 11.9% compared to the previous year. The mindshare of AWS Lake Formation is 7.1%, down from 9.0% compared to the previous year. It is calculated based on PeerSpot user engagement data.
Cloud Data Warehouse
 

Featured Reviews

Ved Prakash Yadav - PeerSpot reviewer
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.
Ramesh Raghavan - PeerSpot reviewer
Centralized repository, offers various cataloging mechanisms for quick data retrieval but data governance capabilities could be better
There are a couple of areas for improvement with Lake Formation. One of the main challenges, especially when dealing with rich media content, like in MarTech (Marketing Technology) or ad agencies, is its versatility. Some clients feel that Lake Formation doesn’t meet their needs and they tend to prefer competitor products for those specific use cases. The second area for improvement is in data governance. Specifically, Lake Formation could enhance its capabilities in audit logs, real-time monitoring, and advanced data governance. This includes managing the entire data lineage—where the data originated, how it moves, and where it’s currently stored. The visibility of the data as it evolves is crucial, and that’s where more advanced governance capabilities would be beneficial.

Quotes from Members

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

Pros

"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."
"The product offers good support for the data lake."
"With the APIs that are available, it can be easily integrated with other tools."
"The most valuable features are that it's easy to set up and easy to connect the many tools that connect to it."
"Redshift Spectrum is the most valuable feature."
"The solution's speed, stability, and user concurrency have been very good."
"The most valuable feature of Redshift is its cluster."
"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 most important advantage in using AWS Lake Formation is its ability to connect the data lake to the other technologies in AWS. This is what I advise my clients."
"It is seamlessly integrated within the AWS ecosystem, making it straightforward to manage access patterns for AWS-native services."
"We use AWS Lake Formation typically for the data warehouse."
"AWS Lake Formation lets you see all your data and tables on one screen."
"The solution has many features that are applicable to events such as audits."
"The solution is quite good at handling analytics. It's done a good job at helping us centralize them."
"AWS Lake Formation works hand in hand with other products."
"I can easily move data from cold storage to regular storage."
 

Cons

"It would be good to see Redshift as a serverless offering."
"This solution lacks integration with non-AWS sources."
"It lacks a few features which can be very useful, such as stored procedures"
"The OLAP slide and dice features need to be improved."
"For people who struggle with IAM or role-based management, the setup isn't easy."
"The solution has four maintenance windows so, when it comes to stability, I think it would be better to decrease their number."
"The refreshment rate of data reaching Redshift from other sources should be faster."
"Improvement could be made in the area of streaming data."
"It falls short when it comes to more granular access control, such as cell-level or row-level entitlements which is a significant drawback for organizations that require precise control over who can access specific rows of data."
"You need to have data experience to use the product."
"The solution could make improvements around orchestration and doing some automation stuff on AWS front automation. It would be useful if we could use automation to build images and use hardened images which are CIS compliant."
"AWS Lake Formation's pricing could be cheaper."
"For the end-users, it's not as user-friendly as it could be."
"In our experience what could be improved are not the support, performance or monitoring, but at a managerial level, the very expensive professional services of AWS. This could be an area of improvement for them. It's too expensive to acquire their support."
"Lake Formation could enhance its capabilities in audit logs, real-time monitoring, and advanced data governance."
"If I could improve AWS Lake Formation, I would add more integrations with SageMaker."
 

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."
"Per hour pricing is helpful to keep the costs of a pilot down, but long-term retention is expensive."
"My customers have implementations that cost about $500 a month for a very small one. I also have a customer with a monthly invoice of about $25,000 USD."
"On a scale of one to ten, where one is a low price and ten is a high price, I rate the pricing a seven."
"The part that I like best is that you only pay for what you are using."
"It's around $200 US dollars. There are some data transfer costs but it's minimal, around $20."
"The solution has very competitive pricing."
"If you want a fixed price, an to not worry about every query, but you need to manage your nodes personally, use Redshift."
"AWS Lake Formation is a bit expensive."
report
Use our free recommendation engine to learn which Cloud Data Warehouse solutions are best for your needs.
816,406 professionals have used our research since 2012.
 

Top Industries

By visitors reading reviews
Educational Organization
60%
Financial Services Firm
7%
Computer Software Company
6%
Manufacturing Company
4%
Financial Services Firm
21%
Computer Software Company
14%
Manufacturing Company
10%
Government
5%
 

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...
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.
What is your experience regarding pricing and costs for Amazon Redshift?
You can start small with a basic cluster to learn and practice with it. Selecting the most basic and economical cluster type can save you enough money to move forward with the solution or go with a...
What do you like most about AWS Lake Formation?
It is seamlessly integrated within the AWS ecosystem, making it straightforward to manage access patterns for AWS-native services.
What is your experience regarding pricing and costs for AWS Lake Formation?
The pricing really depends on the kind of contract you have with AWS and who is selling you the AWS services. There are many ways to consume AWS services. It depends on whether you have an enterpri...
What needs improvement with AWS Lake Formation?
Not everybody can use AWS Lake Formation. You need to have data experience to use the product.
 

Overview

 

Sample Customers

Liberty Mutual Insurance, 4Cite Marketing, BrandVerity, DNA Plc, Sirocco Systems, Gainsight, Blue 449
bp, Cerner, Expedia, Finra, HESS, intuit, Kellog's, Philips, TIME, workday
Find out what your peers are saying about AWS Lake Formation vs. Amazon Redshift and other solutions. Updated: October 2024.
816,406 professionals have used our research since 2012.