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."We use AWS Lake Formation typically for the data warehouse."
"The solution is quite good at handling analytics. It's done a good job at helping us centralize them."
"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 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."
"Our primary use case is for gathering data and analytics. We provide insights into vehicle data. We gather millions of records per second and we have various millions of vehicles running across."
"The most valuable feature of Microsoft Azure Synapse Analytics is the capabilities, and the integration with other Azure resources, such as Data Factory, Databricks, and Spark for data processing. The overall ability to compose the solution with other Azure resources is valuable."
"The most valuable feature is that you can suspend the computer if it is not being used, which means that you don't incur costs."
"The setup is pretty simple."
"Very interactive and provides flexibility."
"The most valuable feature of Microsoft Azure Synapse Analytics is its integration with the new legacy systems. Whatever application we want to integrate, we receive the reports based on the objects. The solution is easy to purchase from the cloud."
"The product is very user friendly."
"Synapse Analytics' best feature is its ability to process large files."
"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."
"It would be of interest to improve things like the web service integration and availability in terms of being easy to create internal web services in the database."
"Microsoft Azure Synapse Analytics can improve by adding more flexibility to the reports. Having more visible structures based on the area, region and country would be beneficial."
"One area that could be improved is the schema management."
"We'd, of course, always like to pay less for the service if we can."
"It would be ideal if the solution could be better used intuitively by the staff without having a great deal of training."
"They should provide a less expensive version with a smaller setup for small businesses. Currently, its price is quite high for entry-level or small businesses. In terms of integration, new connectors are always welcomed."
"I would like to see more ready-to-use products from Synapse. Right now, everything seems a bit futuristic without much modern use."
"I would like to see better integration with Active Directory, because we have had problems, and we still do."
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 86 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.