AWS Lake Formation vs Databricks comparison

Read 88 Databricks reviews

2,196 Views
1,662 Comparison Views

96% willing to recommend

AWS Lake Formation

Comparison Buyer's Guide

Download the report

Executive Summary

We performed a comparison between AWS Lake Formation and Databricks 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.

To learn more, read our detailed AWS Lake Formation vs. Databricks Report (Updated: March 2025).

AWS Lake Formation vs. Databricks

March 2025

Download the complete report

Helped 845,849 peers since 2012

Review summaries and opinions

We asked business professionals to review the solutions they use. Here are some excerpts of what they said:

Categories and Ranking

AWS Lake Formation

Ranking in Cloud Data Warehouse

13th

Average Rating

7.6

Reviews Sentiment

6.9

Number of Reviews

Ranking in other categories

No ranking in other categories

Databricks

Ranking in Cloud Data Warehouse

7th

Average Rating

8.2

Reviews Sentiment

7.0

Number of Reviews

Ranking in other categories

Data Science Platforms (1st), Streaming Analytics (1st)

Mindshare comparison

As of April 2025, in the Cloud Data Warehouse category, the mindshare of AWS Lake Formation is 5.2%, down from 6.0% compared to the previous year. The mindshare of Databricks is 8.4%, up from 3.2% compared to the previous year. It is calculated based on PeerSpot user engagement data.

Cloud Data Warehouse

Featured Reviews

Ramesh Raghavan

US South Lead, Accenture AWS Business Group at Accenture

Centralized repository, offers various cataloging mechanisms for quick data retrieval but data governance capabilities could be better

There are a couple of areas for improvement with Lake Formation. One of the main challenges, especially when dealing with rich media content, like in MarTech (Marketing Technology) or ad agencies, is its versatility. Some clients feel that Lake Formation doesn’t meet their needs and they tend to prefer competitor products for those specific use cases. The second area for improvement is in data governance. Specifically, Lake Formation could enhance its capabilities in audit logs, real-time monitoring, and advanced data governance. This includes managing the entire data lineage—where the data originated, how it moves, and where it’s currently stored. The visibility of the data as it evolves is crucial, and that’s where more advanced governance capabilities would be beneficial.

Read full review

ShubhamSharma7

Data Engineer at a engineering company with 1,001-5,000 employees

Capability to integrate diverse coding languages in a single notebook greatly enhances workflow

Databricks offers various courses that I can use, whether it's PySpark, Scala, or R. I can leverage all these courses in a single notebook, which is beneficial for clients as they can access various tools in one place whenever needed. This is quite significant. I usually work with PySpark based on client requirements. After coding, I feed the Databricks notebooks into the ADF pipeline for updates. Databricks' capability to process data in parallel enhances data processing speed. Furthermore, I can connect our Databricks notebook directly with Power BI and other visualization tools like Qlik. Once we develop code, it allows us to transform raw data into visualizations for clients using analysis diagrams, which is very helpful.

Read full review

Quotes from Members

We asked business professionals to review the solutions they use. Here are some excerpts of what they said:

Pros

"AWS Lake Formation works hand in hand with other products."

"I can easily move data from cold storage to regular storage."

"AWS Lake Formation lets you see all your data and tables on one screen."

"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."

"The solution has many features that are applicable to events such as audits."

"Databricks allows me to automate the creation of a cluster, optimized for machine learning and construct AI machine learning models for the client."

"Can cut across the entire ecosystem of open source technology to give an extra level of getting the transformatory process of the data."

"Databricks is based on a Spark cluster and it is fast. Performance-wise, it is great."

"The main features of the solution are efficiency."

"The most valuable feature of Databricks is the integration with Microsoft Azure."

"It can send out large data amounts."

"Databricks' Lakehouse architecture has been most useful for us. The data governance has been absolutely efficient in between other kinds of solutions."

"The setup is quite easy."

More Databricks pros

Cons

"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."

"If I could improve AWS Lake Formation, I would add more integrations with SageMaker."

"Lake Formation could enhance its capabilities in audit logs, real-time monitoring, and advanced data governance."

"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."

"You need to have data experience to use the product."

"For the end-users, it's not as user-friendly as it could be."

"I would like it if Databricks adopted an interface more like R Studio. When I create a data frame or a table, R Studio provides a preview of the data. In R Studio, I can see that it created a table with so many columns or rows. Then I can click on it and open a preview of that data."

"The API deployment and model deployment are not easy on the Databricks side."

"The data visualization for this solution could be improved. They have started to roll out a data visualization tool inside Databricks but it is in the early stages. It's not comparable to a solution like Power BI, Luca, or Tableau."

"The product should incorporate more learning aspects. It needs to have a free trial version that the team can practice."

"I would like it if Databricks made it easier to set up a project."

"Can be improved by including drag-and-drop features."

"Databricks has a lack of debuggers, and it would be good to see more components."

"Databricks' performance when serving the data to an analytics tool isn't as good as Snowflake's."

More Databricks cons

Pricing and Cost Advice

"AWS Lake Formation is a bit expensive."

"I rate the price of Databricks as eight out of ten."

"My smallest project is around a hundred euros, and my most expensive is just under a thousand euros a week. That is based on terabytes of data processed each month."

"Price-wise, I would rate Databricks a three out of five."

"I'm not involved in the financing, but I can say that the solution seemed reasonably priced compared to the competitors. Similar products are usually in the same price range. With five being affordable and one being expensive, I would rate Databricks a four out of five."

"The cost is around $600,000 for 50 users."

"Licensing on site I would counsel against, as on-site hardware issues tend to really delay and slow down delivery."

"I would rate Databricks' pricing seven out of ten."

"We implement this solution on behalf of our customers who have their own Azure subscription and they pay for Databricks themselves. The pricing is more expensive if you have large volumes of data."

More Databricks pricing and cost advice

See which vendors are best for you

Use our free recommendation engine to learn which Cloud Data Warehouse solutions are best for your needs.

See recommendations

845,849 professionals have used our research since 2012.

Top Industries

By visitors reading reviews

Financial Services Firm

21%

Computer Software Company

14%

Manufacturing Company

Government

Financial Services Firm

17%

Computer Software Company

11%

Manufacturing Company

Healthcare Company

Company Size

By reviewers

Large Enterprise

Midsize Enterprise

Small Business

Questions from the Community

What do you like most about AWS Lake Formation?

It is seamlessly integrated within the AWS ecosystem, making it straightforward to manage access patterns for AWS-native services.

What is your experience regarding pricing and costs for AWS Lake Formation?

The pricing is expensive compared to OpenStack, but cheaper than other cloud environments. It's middle-of-the-road for regular storage yet very cost-effective when using Amazon Glacier for data.

What needs improvement with AWS Lake Formation?

If I could improve AWS Lake Formation, I would add more integrations with SageMaker. I would have built-in functions that provide statistics for the data when using the GUI, such as SageMaker Insig...

Which do you prefer - Databricks or Azure Machine Learning Studio?

Databricks gives you the option of working with several different languages, such as SQL, R, Scala, Apache Spark, or Python. It offers many different cluster choices and excellent integration with ...

How would you compare Databricks vs Amazon SageMaker?

We researched AWS SageMaker, but in the end, we chose Databricks. Databricks is a Unified Analytics Platform designed to accelerate innovation projects. It is based on Spark so it is very fast. It...

Which would you choose - Databricks or Azure Stream Analytics?

Databricks is an easy-to-set-up and versatile tool for data management, analysis, and business analytics. For analytics teams that have to interpret data to further the business goals of their orga...

Snowflake vs AWS Lake Formation

Comparisons

Compared 38% of the time

Amazon Redshift vs AWS Lake Formation

Compared 19% of the time

Azure Data Factory vs AWS Lake Formation

Compared 18% of the time

Microsoft Azure Synapse Analytics vs AWS Lake Formation

Compared 12% of the time

BigQuery vs AWS Lake Formation

Compared 8% of the time

More AWS Lake Formation Competitors

Dataiku vs Databricks

Compared 11% of the time

Microsoft Power BI vs Databricks

Compared 9% of the time

Dremio vs Databricks

Compared 8% of the time

Informatica PowerCenter vs Databricks

Compared 7% of the time

Tableau vs Databricks

Compared 5% of the time

More Databricks Competitors

Product Reports

Download AWS Lake Formation product report

AWS Lake Formation

April 2025

Download Databricks product report

April 2025

Also Known As

No data available

Databricks Unified Analytics, Databricks Unified Analytics Platform, Redash

Overview

AWS Lake Formation is a service that makes it easy to set up a secure data lake in days. A data lake is a centralized, curated, and secured repository that stores all your data, both in its original form and prepared for analysis.

Amazon Web Services (AWS)

Databricks is utilized for advanced analytics, big data processing, machine learning models, ETL operations, data engineering, streaming analytics, and integrating multiple data sources.

Organizations leverage Databricks for predictive analysis, data pipelines, data science, and unifying data architectures. It is also used for consulting projects, financial reporting, and creating APIs. Industries like insurance, retail, manufacturing, and pharmaceuticals use Databricks for data management and analytics due to its user-friendly interface, built-in machine learning libraries, support for multiple programming languages, scalability, and fast processing.

What are the key features of Databricks?

User-friendly interface: Simplifies operations and usability.
Built-in machine learning libraries: Facilitates machine learning tasks.
Support for multiple programming languages: Enhances flexibility.
Scalability: Efficiently handles growing data needs.
Fast processing: Improves performance and speed.
Automated optimization: Reduces manual efforts.
Data visualization: Provides insightful visuals.
Collaborative features: Enhances teamwork.
Delta Lake performance: Boosts data management.
Seamless cluster management: Simplifies system operations.

What are the benefits or ROI to look for in Databricks reviews?

Efficiency in handling large datasets: Ensures smooth processing.
Interactive workspace environment: Improves user collaboration.
Integration with platforms: Provides connectivity benefits.
Performance optimization: Enhances overall system performance.
Support for data governance and security: Ensures data integrity and protection.

Databricks is implemented in insurance for risk analysis and claims processing; in retail for customer analytics and inventory management; in manufacturing for predictive maintenance and supply chain optimization; and in pharmaceuticals for drug discovery and patient data analysis. Users value its scalability, machine learning support, collaboration tools, and Delta Lake performance but seek improvements in visualization, pricing, and integration with BI tools.

Sample Customers

bp, Cerner, Expedia, Finra, HESS, intuit, Kellog's, Philips, TIME, workday

Elsevier, MyFitnessPal, Sharethrough, Automatic Labs, Celtra, Radius Intelligence, Yesware