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 Amazon Redshift is its ability to handle really large sets of data."
"Redshift's Excel features are handy. Redshift spectrum allows you to directly query the data on an Excel sheet. Now, SQL Server also allows this, but Redshift has many more features."
"I like the cost-benefit ratio, meaning that it is as easy to use as it is powerful and well-performing."
"The solution is scalable. It handles different loads very well."
"It allows for the storage of huge amounts of data."
"For the on-premises version of Amazon Redshift, we need to start from scratch. However, 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."
"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 valuable features are that it's easy to set up and easy to connect the many tools that connect to it."
"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."
"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."
"The solution has many features that are applicable to events such as audits."
"This solution lacks integration with non-AWS sources."
"There are physically too many pipelines for a company of this size to maintain. For a data scientist, it's very difficult to learn the data in all of these different environments."
"It would be nice if we could turn off an instance. However, it would retain the instance in history, thus allowing us to restart without beginning from scratch."
"It would be useful to have an option where all of the data can be queried at once and then have the result shown."
"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."
"In the solution, user-based access is quite hard. In general, certain permissions are difficult to manage."
"The solution could improve in handling more data formats and more native support for RDF."
"The refreshment rate of data reaching Redshift from other sources should be faster."
"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."
"AWS Lake Formation's pricing could be cheaper."
"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."
"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."
Amazon Redshift is ranked 4th in Cloud Data Warehouse with 58 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.