Introducing G2.ai, the future of software buying.Try now
Compare AWS Lake Formation and Amazon Redshift 
Featured Products
Sponsored
You’re seeing this ad based on the product’s relevance to this page. Sponsored content does not receive preferential treatment in any of G2’s ratings.
Starburst
Visit Website
Sponsored
You’re seeing this ad based on the product’s relevance to this page. Sponsored content does not receive preferential treatment in any of G2’s ratings.
Astro by Astronomer
Visit Website
Sponsored
You’re seeing this ad based on the product’s relevance to this page. Sponsored content does not receive preferential treatment in any of G2’s ratings.
ILUM
Visit Website
At a Glance
Market Segments
Small-Business (45.2% of reviews)
Mid-Market (39.5% of reviews)
Entry-Level Pricing
No pricing available
$1.22 - $3.26 Per hour
AWS Lake Formation
Star Rating
(36)4.4 out of 5
Market Segments
Small-Business (45.2% of reviews)
Pros & Cons
Not enough data
Entry-Level Pricing
No pricing available
Learn more about AWS Lake FormationAmazon Redshift
Star Rating
(397)4.3 out of 5
Market Segments
Mid-Market (39.5% of reviews)
Pros & Cons
Entry-Level Pricing
$1.22 - $3.26 Per hour
Browse all 6 pricing plansSummary
AI Generated Summary
AI-generated. Powered by real user reviews.
- Users report that Amazon Redshift excels in data integration with a score of 8.8, making it a preferred choice for enterprises looking to consolidate data from various sources efficiently. In contrast, AWS Lake Formation, while strong in data governance, does not emphasize integration as heavily, which may be a drawback for users needing seamless data flow.
- Reviewers mention that Amazon Redshift's built-in data analytics feature scores 8.1, providing users with robust analytical capabilities directly within the database. Conversely, AWS Lake Formation focuses more on data lake management, which may not cater to users seeking immediate analytical insights.
- G2 users highlight that Amazon Redshift's performance in scalability is rated at 8.9, allowing businesses to handle large volumes of data effectively. In comparison, AWS Lake Formation, while offering solid data governance, does not match this level of scalability, which could limit its appeal for rapidly growing enterprises.
- Users on G2 appreciate Amazon Redshift's ease of setup, scoring 8.6, which is crucial for teams looking to implement solutions quickly. AWS Lake Formation, with a score of 8.3, may require more time for configuration, potentially delaying project timelines.
- Reviewers mention that Amazon Redshift's role-based authorization feature scores 8.7, providing robust security measures for data access. In contrast, AWS Lake Formation, while strong in data security with a score of 8.8, may not offer the same granularity in user access management, which could be a concern for organizations with strict compliance requirements.
- Users say that Amazon Redshift's data modeling capabilities are rated at 9.2, making it a standout for users needing to create complex data structures. AWS Lake Formation, while effective for data lake management, does not provide the same level of data modeling flexibility, which may limit its usability for advanced analytics.
Pricing
Entry-Level Pricing
AWS Lake Formation
No pricing availableAmazon Redshift
RA3.4xlarge
$1.22 - $3.26
Per hour
On-demand, 1-Year, or 3-Year Terms
- Commit to save up to 34%
Free Trial
AWS Lake Formation
Free Trial is available
Amazon Redshift
Free Trial is available
Ratings
Meets Requirements
8.8
25
8.7
281
Ease of Use
8.7
25
8.7
281
Ease of Setup
8.3
10
8.6
138
Ease of Admin
8.0
9
8.4
128
Quality of Support
8.3
24
8.5
264
Has the product been a good partner in doing business?
9.0
8
8.7
127
Product Direction (% positive)
10.0
21
8.8
252
Features by Category
Data Management
Not enough data
8.8
133
|
Verified
Not enough data
8.4
125
|
Verified
Not enough data
8.8
131
|
Verified
Not enough data
8.0
127
|
Verified
Not enough data
7.6
102
|
Verified
Not enough data
8.3
118
|
Verified
Integration
Not enough data
7.9
101
|
Verified
Not enough data
8.7
128
|
Verified
Not enough data
8.6
119
|
Verified
Deployment
Not enough data
8.1
102
Not enough data
8.9
130
|
Verified
Performance
Not enough data
8.9
134
|
Verified
Security
Not enough data
8.7
126
|
Verified
Not enough data
8.8
128
|
Verified
Generative AI
Not enough data
7.3
20
Not enough data
7.2
19
Storage
Not enough data
8.4
53
Not enough data
8.4
56
Availability
Not enough data
8.6
47
Not enough data
8.2
50
Not enough data
8.4
48
Performance
Not enough data
8.2
48
Security
Not enough data
8.7
47
Not enough data
8.4
52
Not enough data
8.1
47
Not enough data
8.5
48
Support
Not enough data
7.9
43
Not enough data
8.5
47
Database
8.0
11
Not enough data
8.6
11
Not enough data
8.6
12
Not enough data
Integrations
8.0
9
Not enough data
8.7
10
Not enough data
Platform
8.3
7
Not enough data
7.6
7
Not enough data
8.7
10
Not enough data
Processing
8.5
8
Not enough data
8.5
8
Not enough data
Building Reports
Not enough data
Not enough data
Not enough data
Not enough data
Not enough data
Not enough data
Not enough data
Not enough data
Platform
Not enough data
Not enough data
Not enough data
Not enough data
Not enough data
Not enough data
Not enough data
Not enough data
Not enough data
Not enough data
Not enough data
Not enough data
Not enough data
Not enough data
Categories
Categories
Shared Categories
AWS Lake Formation and Amazon Redshift are categorized as Big Data Integration Platforms
Unique Categories
AWS Lake Formation is categorized as Big Data Processing and Distribution
Amazon Redshift is categorized as Columnar Databases and Data Warehouse
Reviews
Reviewers' Company Size
AWS Lake Formation
Small-Business(50 or fewer emp.)
Mid-Market(51-1000 emp.)
Enterprise(> 1000 emp.)
Amazon Redshift
Small-Business(50 or fewer emp.)
Mid-Market(51-1000 emp.)
Enterprise(> 1000 emp.)
Small-Business
(50 or fewer emp.)
Mid-Market
(51-1000 emp.)
Enterprise
(> 1000 emp.)
Reviewers' Industry
Information Technology and Services
22.6%
Banking
9.7%
Retail
6.5%
Management Consulting
6.5%
Higher Education
6.5%
Other
48.4%
Information Technology and Services
15.5%
Computer Software
12.7%
Financial Services
7.7%
Retail
5.2%
Telecommunications
4.7%
Other
54.1%
Alternatives
Discussions
AWS Lake Formation has no discussions with answers
Should I use with a data mart for a frontend tool that make request on it ?
3 Comments
NM
Hi Mehdi
Can you elaborate your question?
AWS Redshift is a DataBase/Data Warehouse service, which is Ideal for Analytical use cases.
You can...Read more
When can I use Amazon redshift?
3 Comments
PG
Redshift is big data warehousing solution to handle petabytes of data and also for real time decisions. If you want highly optimized data warehousing...Read more
What are the characteristics of redshift?
2 Comments
AK
Redshift is mainly used for Big data and analytics to store the data in columner format. Retrieve the data is very fast and parallel processing also most...Read more
Hunting for software insights?
With over 3 million reviews, we can provide the specific details that help you make an informed software buying decision for your business. Finding the right product is important, let us help.
