We compared Snowflake and AWS Lake Formation based on our user's reviews in several parameters.
In summary, Snowflake is praised for its high performance, scalability, user-friendly interface, and efficient customer support. Users find Snowflake's pricing reasonable and appreciate its positive ROI. On the other hand, AWS Lake Formation is lauded for its flexible pricing, excellent data management capabilities, comprehensive security measures, and seamless integration with other AWS services. Users value its efficient setup process and commendable customer service. Areas for improvement in AWS Lake Formation include usability, access permissions management, data processing speed, documentation, data integration options, and customization features.
Features: Snowflake's valuable features include high performance, scalability, and ease of use. Users appreciate its ability to handle large data volumes quickly. In contrast, AWS Lake Formation offers excellent data management capabilities, comprehensive security measures, and seamless integration with other AWS services. Users enjoy the simple setup process and robust access control mechanisms, ensuring reliable data management and efficient workflows.
Pricing and ROI: The setup cost for Snowflake is seen as reasonable and competitive, with a straightforward and uncomplicated process. Users appreciate the flexible licensing terms and options. On the other hand, AWS Lake Formation offers a flexible and cost-effective pricing model, with a straightforward and hassle-free setup cost. Users value the licensing options provided., The user reviews for Snowflake indicate a positive and beneficial ROI. Similarly, AWS Lake Formation also provides a significant ROI with positive results reported by users.
Room for Improvement: Snowflake has room for improvement in specific areas to enhance user experience and functionality. AWS Lake Formation, on the other hand, needs enhancements in usability, access permissions management, data processing speed, troubleshooting resources, data integration options, and feature customization.
Deployment and customer support: The reviews highlight that when evaluating the duration required for a new tech solution, Snowflake users emphasize distinguishing between deployment and setup phases, while AWS Lake Formation users have varying timeframes for deployment, setup, and implementation, suggesting that these phases should be considered separately., Snowflake's customer service has received positive feedback for promptness and effectiveness. Users appreciate the expertise and helpful guidance provided by the support team. AWS Lake Formation's customer service is also commendable, with users valuing their responsiveness, expertise, and commitment to customer success.
The summary above is based on 43 interviews we conducted recently with Snowflake and AWS Lake Formation users. To access the review's full transcripts, download our report.
"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."
"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 product's most important feature is unloading data to S3."
"The features I found most valuable with this solution are sharing options and built-in time zone conversion."
"The solution is very stable."
"Snowflake has a variety of other ETL provisions that they provide. You can use your own ETL pipeline. Additionally, they provide adapters, and they are always evolving, it is a well-developed solution."
"It's ultra-fast at handling queries, which is what we find very convenient."
"The solution's computing time is less."
"The solution is easy to use."
"Snowflake is an enormously useful platform. The Snowpipe feature is valuable because it allows us to load terabytes and petabytes of data into the data mart at a very low cost."
"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."
"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."
"Support needs improvement, as it can take several days before you get some initial support."
"The UI could improve because sometimes in the security query the UI freezes. We then have to close the window and restart."
"If they could bring in some tools for data integration, it would be really great."
"Currently, Snowflake doesn't support unstructured data."
"The cost is a bit high."
"They need to incorporate some basic OLAP capabilities in the backend or at the database level. Currently, it is purely a database. They call it purely a data warehouse for the cloud. Currently, just like any database, we have to calculate all the KPIs in the front-end tools. The same KPIs again need to be calculated in Snowflake. It would be very helpful if they can include some OLAP features. This will bring efficiency because we will be able to create the KPIs within Snowflake itself and then publish them to multiple front-end tools. We won't have to recreate the same in each project. There should be the ability to automate raised queries, which is currently not possible. There should also be something for Exception Aggregation and things like that."
"The solution could improve by allowing non-structured data, such as PDFs, images, or videos. We cannot see the data."
"Snowflake could improve if they had an Operational Data Store(ODS) space."
AWS Lake Formation is ranked 12th in Cloud Data Warehouse with 5 reviews while Snowflake is ranked 1st in Cloud Data Warehouse with 92 reviews. AWS Lake Formation is rated 7.6, while Snowflake is rated 8.4. The top reviewer of AWS Lake Formation writes "Strategically aligning data management in a multi-cloud environment with significant reporting challenges". On the other hand, the top reviewer of Snowflake writes "Good usability, good data sharing and elastic compute features, and requires less DBA involvement". AWS Lake Formation is most compared with Azure Data Factory, Amazon Redshift, Microsoft Azure Synapse Analytics, BigQuery and Amazon EMR, whereas Snowflake is most compared with BigQuery, Azure Data Factory, Teradata, Vertica and Amazon EMR. See our AWS Lake Formation vs. Snowflake 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.