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 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."
"Amazon Redshift is very fast. It has really good response times. It's very user-friendly."
"Redshift is a major service of Amazon and is very scalable. It enables faster recalculations and data management, helping to retrieve data quickly."
"The most valuable features of Amazon Redshift are that its fast and efficient. We have lots of TBs of data and it's very fast."
"It allows you write complex queries and perform row by row processes."
"We have found Machine Learning use cases are very nice."
"This service can merge and integrate well with all databases."
"The most valuable features are that it's easy to set up and easy to connect the many tools that connect to it."
"It is seamlessly integrated within the AWS ecosystem, making it straightforward to manage access patterns for AWS-native services."
"The solution has many features that are applicable to events such as audits."
"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."
"We use AWS Lake Formation typically for the data warehouse."
"The solution is quite good at handling analytics. It's done a good job at helping us centralize them."
"In the solution, user-based access is quite hard. In general, certain permissions are difficult to manage."
"In our experiments, the handling of unstructured data was not very smooth."
"The initial setup is a complex process, especially for someone who is not familiar with nodes and configuring terms like RPUs."
"We recently moved from the DC2 cluster to the RA3 cluster, which is a different node type and we are finding some issues with the RA3 cluster regarding connection and processing. There is room for improvement in this area. We are in talks with AWS regarding the connection issues."
"The technical support should be better in terms of their knowledge, and they should be more customer-friendly."
"Amazon Redshift is a little more expensive than other products."
"Should be made available across zones, like other Multi-AZ solutions."
"Pricing is one of the things that it could improve. It should be more competitive."
"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."
"For the end-users, it's not as user-friendly as it could be."
"AWS Lake Formation's pricing could be cheaper."
"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."
"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."
Amazon Redshift is ranked 4th in Cloud Data Warehouse with 59 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 Snowflake, Teradata, Vertica, 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.