We compared Amazon Redshift and AWS Lake Formation based on our user's reviews in several parameters.
In summary, Amazon Redshift is praised for its efficient performance, cost-effectiveness, and comprehensive monitoring tools, while user feedback highlights the need for improvements in query performance and data loading speeds. On the other hand, AWS Lake Formation is commended for its flexible pricing and robust data management capabilities, with users suggesting enhancements in usability and data processing speed.
Features: Amazon Redshift offers efficient performance, cost-effective pricing, scalability, and seamless integration with other AWS services. Users appreciate its ability to run complex analytical queries quickly and the comprehensive monitoring and management tools provided. AWS Lake Formation excels in data management capabilities, comprehensive security measures, simple setup process, seamless integration with other AWS services, and robust access control mechanisms. Users value its ease of data management, reliability, and availability. The platform's security measures guarantee privacy and protection, while the simple setup process allows for swift adoption. Seamless integration and robust access control mechanisms enable efficient workflows and data governance.
Pricing and ROI: Amazon Redshift's setup cost is minimal and its licensing process is straightforward. Users appreciate the transparency and flexibility in pricing options. AWS Lake Formation also offers a straightforward and hassle-free setup cost, with flexible licensing options. Both products are considered cost-effective, but Redshift has a reputation for being reasonable and competitive., Amazon Redshift has proven to be highly beneficial in terms of efficiency, cost-effectiveness, query speed, scalability, user-friendliness, and integration capabilities. AWS Lake Formation also provides a significant ROI with positive results and benefits reported.
Room for Improvement: Amazon Redshift could benefit from improvements in query performance, data loading speeds, cluster management, user interface, troubleshooting documentation, access control flexibility, continuous updates, and bug fixes. AWS Lake Formation needs enhancements in usability, user interface, access permission management, data processing speed, troubleshooting resources, data integration options, and customizable features to meet specific business requirements.
Deployment and customer support: The user reviews for Amazon Redshift and AWS Lake Formation indicate that there is some variability in the duration required for deployment, setup, and implementation. However, while Amazon Redshift reviews focus more on deployment and setup as separate phases, AWS Lake Formation reviews indicate that these terms likely refer to the same period., Amazon Redshift's customer service and support have received high praise from users. They appreciate the prompt and helpful responses, the expertise of the support team, the user-friendly interface, and the detailed documentation. On the other hand, AWS Lake Formation's customer service and support also impress users. They commend the responsiveness and expertise of the support team, the company's commitment to customer success, and their ability to streamline operations and enhance the overall user experience.
The summary above is based on 25 interviews we conducted recently with Amazon Redshift and AWS Lake Formation users. To access the review's full transcripts, download our report.
"The most valuable feature of Redshift is its cluster."
"The ability to reload data multiple times at different times."
"The stability of Amazon Redshift is good."
"We have found Machine Learning use cases are very nice."
"Amazon Redshift is a really powerful database system for reporting and data warehousing."
"The solution's flexibility is its most valuable feature. It's also easy to scale and has relatively painless pricing."
"This service can merge and integrate well with all databases."
"I find the most valuable features to be the MPP style of processing, which mostly all of the data warehouses provide. The ability to integrate all other AWS services, such as NSS and S3, with little effort is very helpful. The service is well maintained, there are update patches frequently."
"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."
"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."
"The product must provide new indexes that support special data structures or data types like TEXT."
"The technical support should be better in terms of their knowledge, and they should be more customer-friendly."
"The solution has four maintenance windows so, when it comes to stability, I think it would be better to decrease their number."
"There are too many limitations with respect to concurrency."
"The OLAP slide and dice features need to be improved."
"If you require a highly scalable solution, I would not recommend Amazon Redshift."
"It lacks a few features which can be very useful, such as stored procedures"
"AWS Snowflake has a very good feature for cloning databases. It makes it easy to clone a data warehouse, which is useful. I would like to see this feature in Redshift."
"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."
"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."
"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."
Amazon Redshift is ranked 4th in Cloud Data Warehouse with 61 reviews while AWS Lake Formation is ranked 12th in Cloud Data Warehouse with 5 reviews. Amazon Redshift is rated 7.8, while AWS Lake Formation is rated 7.6. The top reviewer of Amazon Redshift writes "Provides one place where we can store data, and allows us to easily connect to other services with AWS". On the other hand, the top reviewer of AWS Lake Formation writes "Strategically aligning data management in a multi-cloud environment with significant reporting challenges". Amazon Redshift is most compared with Teradata, Vertica, Snowflake, Microsoft Azure Synapse Analytics and Oracle Exadata, whereas AWS Lake Formation is most compared with Snowflake, Azure Data Factory, Microsoft Azure Synapse Analytics, BigQuery and Amazon EMR. See our AWS Lake Formation vs. Amazon Redshift report.
See our list of best Cloud Data Warehouse vendors.
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.