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.
"I like it because the usage is very similar to Microsoft SQL server. The structure of the query and the temporary tables are very similar."
"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."
"The solution is scalable. It handles different loads very well."
"It's very easy to migrate from other databases to Redshift. There are migration tools dedicated for this purpose, enabling migration from other databases like MS SQL directly to Redshift. The majority of the scripts will be automatically transposed."
"The initial setup is easy."
"Amazon Redshift is a really powerful database system for reporting and data warehousing."
"Easy to build out our snowflake design and load data."
"We have found Machine Learning use cases are very nice."
"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 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."
"The solution is quite good at handling analytics. It's done a good job at helping us centralize them."
"The solution has four maintenance windows so, when it comes to stability, I think it would be better to decrease their number."
"The initial setup is a complex process, especially for someone who is not familiar with nodes and configuring terms like RPUs."
"One area where Amazon Redshift could improve is in adopting the compute-separate, data-separate architecture, which Delta, Snowflake are adopting, and a few others in the cloud data warehouse spectrum."
"Amazon Redshift could improve the user interface support."
"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."
"This solution lacks integration with non-AWS sources."
"We are using third-party tools to integrate Amazon Redshift, they should create their own interface on their own for it to be easily connected on the AWS itself."
"Sometimes, it's difficult to get the metadata from Redshift."
"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."
"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."
"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."
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, Snowflake, 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.