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 is quite good at handling analytics. It's done a good job at helping us centralize them."
"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 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."
"Its performance is most valuable. As compared to SQL Server, we are able to see a significant improvement in performance with Snowflake."
"The syntax is advanced which reduces the time to write code."
"The feature that is really striking is the ability to translate the SQL workloads into the NoSQL version that can be used by Snowflake."
"The solution is easy to use."
"For us, the virtual warehousing is likely the most valuable aspect."
"The most valuable feature is the snapshot database. In one second, you can just take a snapshot of the database for test purposes."
"The querying speed is fast."
"The most valuable features are sharing data, Time Travel, Zero Copy Cloning, performance, and speed."
"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."
"For the end-users, it's not as user-friendly as it could be."
"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 needs a bit more rigor and governance, which is something you don't get with newer tools. This makes it less enterprise scalable. Its governance and structure can be enhanced, which would really be valuable. I would like to see some kind of prebuilt functionality in terms of having almost like a pre-built data warehouse. A functionality for generating automated kind of pieces would be good."
"In a future release we would like to have a link which would allow us to connect to an external database and create certain views in your own database. This is because it is becoming hard for us to compare the data between multiple sources."
"There are always a few operation updates here and there that can be made."
"If they could bring in some tools for data integration, it would be really great."
"I would like to see a client version of the GUI."
"There are some stored procedures that we've had trouble with. The solution also needs to fine-tune the connectors to be able to connect into the system source."
"The user interface continues to be an issue, especially when we need to get data out of Snowflake. It's very easy to get data in, but it's not too easy to get it out or extract it."
"Snowflake needs transparency over costs and pricing."
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.