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."
"The solution has many features that are applicable to events such as audits."
"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."
"Microsoft provides both the platform and the data center, so you don't have to look for a cloud vendor. It saves you from having to deal with two vendors for the same task."
"The solution offers strong scalability opportunities."
"The solution operates like a typical SQL Server environment so there is no alienation in terms of technical knowledge."
"Technical support is okay in terms of the help they provide."
"Can capture all the transactional data throughout a company."
"They are available on the Cloud, and the platform is very intuitive."
"We use Azure Synapse Analytics in many different areas and industries, so I like that you can administrate and create pipelines for difference sources of data and later integrate and deploy it to other internal areas, such as separate dashboards for financials, and so on."
"The product works well with other Azure products."
"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."
"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."
"For the end-users, it's not as user-friendly as it could be."
"AWS Lake Formation's pricing could be cheaper."
"Microsoft should develop an interface to make it easier to shift from on-premise to the cloud."
"Indicating what areas need improvement in this solution is a difficult question because the organizations that I am working for are really new in this area. However, an even better more simple interface, or perhaps an extension of a connector app store solution, would be helpful."
"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."
"I would like my team to be able to build pipelines that integrate with the Azure Data Factory."
"When I was trying to link services to an SFTP site it was not able to do all the possible encryption that I needed. They can improve by adding more encryption options."
"The cost of the solution has room for improvement."
"Documentation could be improved."
"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."
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.