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."The solution has many features that are applicable to events such as audits."
"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 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."
"Scaling this solution is easy and the uptime is okay."
"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 setup is pretty simple."
"We have found that it is easy to develop and to do the analytics in the modules of data."
"The solution's best feature is its predictive analytics."
"The solution operates like a typical SQL Server environment so there is no alienation in terms of technical knowledge."
"Azure Synapse combines the strengths of SQL technologies for effective enterprise data management."
"The initial setup was really easy and straightforward."
"AWS Lake Formation's pricing could be cheaper."
"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."
"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."
"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."
"This solution needs to have query caching so that if the same query is run and the results are available, it will return the data from the cache without having to re-run the query."
"It would be ideal if the solution could be better used intuitively by the staff without having a great deal of training."
"Integration with other vendors has limitations and could be improved."
"The support and price could improve."
"The linked services can be improved. We can create dynamic linked services to access a lot of databases but only those of the same type. For example, I can use the same linked services to access 11 SQL databases. However, if I have 11 SQL databases and five Oracle databases, I need two dynamic linked services. I cannot do it with only one linked service. The UI also needs to be improved. When I have used Azure Synapse for programming with PySpark, Scala, or .NET, for example, the UI has been unstable. If I open two notebooks for programming, one notebook will queue the session of the other."
"The configuration for things like high-availability could be more user-friendly for non-technical users."
"I would like to see more ready-to-use products from Synapse. Right now, everything seems a bit futuristic without much modern use."
"The initial setup has a bit of a learning curve."
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.