We performed a comparison between AWS Lake Formation and Vertica based on real PeerSpot user reviews.
Find out in this report how the two Cloud Data Warehouse solutions compare in terms of features, pricing, service and support, easy of deployment, and ROI."The solution is quite good at handling analytics. It's done a good job at helping us centralize them."
"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 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."
"It's the fastest database I have ever tested. That's the most important feature of Vertica."
"The extensibility and efficiency provided by their C++ SDK."
"Partition and join back to node are easy and simple for DBAs."
"The most valuable feature is Vertica's performance and the ease of using the database."
"It maximizes cloud economics with Eon Mode by scaling cluster size to meet variable workload demands."
"For me, It's performance, scalability, low cost, and it's integrated into enterprise and big data environments."
"We are able to integrate our Vertica data warehouse with Tableau to create numerous reports quickly and efficiently."
"Vertica enabled us to close large deals. Customers with large data sets had to be migrated from PostgreSQL to Vertica due to performance."
"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."
"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 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."
"We are looking for a cheaper deployment for the solution. Although we did a lot of benchmarks, like Redshift. We tried Redshift, it didn't work. It didn't work out for us as well."
"They could improve on customer service."
"I have found that coding support could be simplified."
"Limitations in group by projections is where I would like to see an improvement."
"Promotion/marketing must be improved, even though it is a very useful product at very good price, it is not as "popular" as it should be."
"It should provide a GUI interface for data management and tuning."
"The integration of this solution with ODI could be improved."
"Some of our small to medium-sized customers would like to see containerization and flexibility from the deployment standpoint."
AWS Lake Formation is ranked 12th in Cloud Data Warehouse with 5 reviews while Vertica is ranked 7th in Cloud Data Warehouse with 83 reviews. AWS Lake Formation is rated 7.6, while Vertica is rated 8.2. 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 Vertica writes " A user-friendly tool that needs to improve its documentation part". AWS Lake Formation is most compared with Snowflake, Azure Data Factory, Amazon Redshift, Microsoft Azure Synapse Analytics and BigQuery, whereas Vertica is most compared with Snowflake, SQL Server, Amazon Redshift, Teradata and Oracle Exadata. See our AWS Lake Formation vs. Vertica 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.