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 initial setup is easy."
"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."
"The most valuable feature is that the solution is fully embedded in the AWS stack."
"It allows for the storage of huge amounts of data."
"Redshift has an advantage when it comes to administration, making it easier to manage and collaborate."
"The product offers good support for the data lake."
"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."
"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."
"The solution has many features that are applicable to events such as audits."
"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 is quite good at handling analytics. It's done a good job at helping us centralize them."
"The product could be improved by making it more flexible."
"The explain panel in the Redshift database could be better."
"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."
"It would be useful to have an option where all of the data can be queried at once and then have the result shown."
"The OLAP slide and dice features need to be improved."
"Amazon should provide more cloud-native tools that can integrate with Redshift like Microsoft's development tools for Azure."
"Pricing is one of the things that it could improve. It should be more competitive."
"They should provide a better way to work with interim data in a structured way than to store it in parquet files locally."
"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."
"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."
"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."
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, Vertica, Teradata, 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 Apache Hadoop. 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.