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.
"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 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 is quite good at handling analytics. It's done a good job at helping us centralize them."
"The solution has many features that are applicable to events such as audits."
"I like the fact that we don't need a DBA. It automatically scales stuff."
"The most valuable features of Snowflake are its performance and power."
"Can be leveraged with respect to better performance, auto tuning and competition."
"The solution is very stable."
"Snowflake's most valuable features are data enrichment and flattening."
"The initial setup is very simple."
"I like the ability to work with a managed service on the cloud and that is easy to start with."
"The tool's performance is good. I think it's the best in the game right now. It usually charges per query. For example, if you run a SQL query on Snowflake with the same number of data records, it would take less than half the time compared to running it on Microsoft. It has good documentation. You can pick up Snowflake if you have previous knowledge of SQL."
"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."
"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."
"Its transaction application needs improvement."
"There are some challenges with loading unstructured data and integrating some message queues or brokers. In one project, we had a problem connecting to one of the message queues and we had to take a different route altogether on Microsoft Azure."
"These aren't as crucial, but there are common errors sometimes where the database is down, or a table is nullified and a new table is added and you are not given access to that. With those errors, you don't have permissions."
"I would like to see more transparency in data processing, ATLs, and compute areas - which should give more comfort to the end users."
"For the Snowflake database, there should be some third-party features for the ETL. It would also be good to be able to use some kind of controls to get the data either from another database or a flat file. Its price should be improved. It should be cheaper than Microsoft."
"The scheduling system can definitely be better because we had to use external airflow for that. There should be orchestration for the scheduling system. Snowflake currently does not support machine learning, so it is just storage. They also need some alternatives for SQL Query. There should also be support for Spark in different languages such as Python."
"If you go with one cloud provider, you can't switch."
"The cost is a bit high."
AWS Lake Formation is ranked 12th in Cloud Data Warehouse with 5 reviews while Snowflake is ranked 1st in Cloud Data Warehouse with 94 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 Oracle Autonomous Data Warehouse. 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.