We performed a comparison between AWS Lake Formation and Microsoft Azure Synapse Analytics 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."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."
"We use AWS Lake Formation typically for the data warehouse."
"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 has many features that are applicable to events such as audits."
"Its scalability and ease of use are valuable. It is fairly simple for a tool that's that powerful. If you have a background in Microsoft SQL Server, it is a very easy-to-transition path."
"The solution handles single or complex items within a second."
"It's quite quick for querying, even with large datasets, and it's scalable. It's also flexible to use, so it's easy to update and get data quickly without wasting time."
"Technical support is okay in terms of the help they provide."
"I think the most valuable component is that pipelines are built into it and then the feature that you can mirror a cosmos BB for analytics."
"The MPP (Massively Parallel Processing) architecture helps to make things a lot faster."
"They are available on the Cloud, and the platform is very intuitive."
"We can have the dedicated SQL up and running within 15 minutes."
"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."
"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."
"AWS Lake Formation's pricing could be cheaper."
"While the solution is flexible, sometimes this works against the user."
"The need to improve a little bit in terms of user-friendliness."
"There may be some challenges in terms of connecting with Virtual Networks (VNETs) to Microsoft Azure Synapse Analytics."
"I'd like to see part of the service de-coupled."
"The cost of the solution has room for improvement."
"Real-time integration is hard to do in Microsoft Azure Synapse Analytics."
"The security performance and cost are the two things that needs improvement."
"Microsoft Azure Synapse Analytics's pricing could be reduced."
More Microsoft Azure Synapse Analytics Pricing and Cost Advice →
AWS Lake Formation is ranked 12th in Cloud Data Warehouse with 5 reviews while Microsoft Azure Synapse Analytics is ranked 2nd in Cloud Data Warehouse with 85 reviews. AWS Lake Formation is rated 7.6, while Microsoft Azure Synapse Analytics is rated 7.8. 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 Microsoft Azure Synapse Analytics writes "No competitors provide the entire solution to one place ". AWS Lake Formation is most compared with Snowflake, Azure Data Factory, Amazon Redshift, BigQuery and Amazon EMR, whereas Microsoft Azure Synapse Analytics is most compared with Azure Data Factory, SAP BW4HANA, Snowflake, Oracle Autonomous Data Warehouse and SAP Business Warehouse. See our AWS Lake Formation vs. Microsoft Azure Synapse Analytics 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.
