Databricks vs KNIME comparison

Cancel
You must select at least 2 products to compare!
Databricks Logo
28,492 views|18,008 comparisons
96% willing to recommend
Knime Logo
10,966 views|7,554 comparisons
93% willing to recommend
Comparison Buyer's Guide
Executive Summary

We performed a comparison between Databricks and KNIME based on real PeerSpot user reviews.

Find out in this report how the two Data Science Platforms solutions compare in terms of features, pricing, service and support, easy of deployment, and ROI.
To learn more, read our detailed Databricks vs. KNIME Report (Updated: March 2024).
769,976 professionals have used our research since 2012.
Featured Review
Quotes From Members
We asked business professionals to review the solutions they use.
Here are some excerpts of what they said:
Pros
"I like how easy it is to share your notebook with others. You can give people permission to read or edit. I think that's a great feature. You can also pull in code from GitHub pretty easily. I didn't use it that often, but I think that's a cool feature.""It can send out large data amounts.""The solution is an impressive tool for data migration and integration.""I haven't heard about any major stability issues. At this time I feel like it's stable.""The most valuable feature of Databricks is the integration of the data warehouse and data lake, and the development of the lake house. Additionally, it integrates well with Spark for processing data in production.""Easy to use and requires minimal coding and customizations.""The solution is built from Spark and has integration with MLflow, which is important for our use case.""Databricks is based on a Spark cluster and it is fast. Performance-wise, it is great."

More Databricks Pros →

"I know I don't use it to its full capacity, but I love the Rule Engine feature. It has allowed me to create lookup tables on the fly and break down text fields into quantifiable data.""It's very convenient to write your own algorithms in KNIME. You can write it in Java script or Python transcript.""The product is very easy to understand even for non-analytical stakeholders. Sometimes we provide them with KNIME workflows and teach them how to run it on their own machine.""We have been able to appreciate the considerable reduction in prototyping time.""I've never had any problems with stability.""Clear view of the data at every step of ETL process enables changing the flow as needed.""This solution is easy to use and it can be used to create any kind of model.""Easy to use, stable, and powerful."

More KNIME Pros →

Cons
"Databricks has added some alerts and query functionality into their SQL persona, but the whole SQL persona, which is like a role, needs a lot of development. The alerts are not very flexible, and the query interface itself is not as polished as the notebook interface that is used through the data science and machine learning persona. It is clunky at present.""CI/CD needs additional leverage and support.""I'm not the guy that I'm working with Databricks on a daily basis. I'm on the management team. However, my team tells me there are limitations with streaming events. The connectors work with a small set of platforms. For example, we can work with Kafka, but if we want to move to an event-driven solution from AWS, we cannot do it. We cannot connect to all the streaming analytics platforms, so we are limited in choosing the best one.""There is room for improvement in visualization.""If I want to create a Databricks account, I need to have a prior cloud account such as an AWS account or an Azure account. Only then can I create a Databricks account on the cloud. However, if they can make it so that I can still try Databricks even if I don't have a cloud account on AWS and Azure, it would be great. That is, it would be nice if it were possible to create a pseudo account and be provided with a free trial. It is very essential to creating a workforce on Databricks. For example, students or corporate staff can then explore and learn Databricks.""Implementation of Databricks is still very code heavy.""There would also be benefits if more options were available for workers, or the clusters of the two points.""It would be very helpful if Databricks could integrate with platforms in addition to Azure."

More Databricks Cons →

"From the point of view of the interface, they can do a little bit better.""There are some parameters that I would like to have at a bigger scale. The upper limit of one node that tries to find spots or areas in photos was too small for us. It would need to be bigger.""It could be easier to use.""System resource usage. Knime will occupy total system RAM size and other applications will hang.""The solution is inconvenient when it comes to wrangling data that includes multiple steps or features because each step or feature requires its own icon.""The pricing needs improvement.""There should be better documentation and the steps should be easier.""The documentation needs a proper rework. ​"

More KNIME Cons →

Pricing and Cost Advice
  • "Whenever we want to find the actual costing, we have to send an email to Databricks, so having the information available on the internet would be helpful."
  • "I do not exactly know the costs, but one of our clients pays between $100 USD and $200 USD monthly."
  • "Licensing on site I would counsel against, as on-site hardware issues tend to really delay and slow down delivery."
  • "We find Databricks to be very expensive, although this improved when we found out how to shut it down at night."
  • "The pricing depends on the usage itself."
  • "I am based in South Africa, where it is expensive adapting to the cloud, and then there is the price for the tool itself."
  • "The price is okay. It's competitive."
  • "Databricks uses a price-per-use model, where you can use as much compute as you need."
  • More Databricks Pricing and Cost Advice →

  • "It is free of cost. It is GNU licensed."
  • "KNIME desktop is free, which is great for analytics teams. Server is well priced, depending on how much support is required."
  • "KNIME is free as a stand-alone desktop-based platform but if you want to get a KNIME server then you can find the cost on their website."
  • "The price of KNIME is quite reasonable and the designer tool can be used free of charge."
  • "It's an open-source solution."
  • "The price for Knime is okay."
  • "At this time, I am using the free version of Knime."
  • "This is an open-source solution that is free to use."
  • More KNIME Pricing and Cost Advice →

    report
    Use our free recommendation engine to learn which Data Science Platforms solutions are best for your needs.
    769,976 professionals have used our research since 2012.
    Questions from the Community
    Top Answer: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… more »
    Top Answer: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… more »
    Top Answer: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… more »
    Top Answer:Since KNIME is a no-code platform, it is easy to work with.
    Top Answer:We're using the free academic license just locally. I went for KNIME because they have a free academic license. And to be honest, I never bothered to check the prices.
    Top Answer:KNIME is not good at visualization. I would like to see NLQ (Natural language query) and automated visualizations added to KNIME.
    Ranking
    1st
    Views
    28,492
    Comparisons
    18,008
    Reviews
    47
    Average Words per Review
    441
    Rating
    8.3
    4th
    Views
    10,966
    Comparisons
    7,554
    Reviews
    21
    Average Words per Review
    501
    Rating
    7.9
    Comparisons
    Also Known As
    Databricks Unified Analytics, Databricks Unified Analytics Platform, Redash
    KNIME Analytics Platform
    Learn More
    Overview

    Databricks is an industry-leading data analytics platform which is a one-stop product for all data requirements. Databricks is made by the creators of Apache Spark, Delta Lake, ML Flow, and Koalas. It builds on these technologies to deliver a true lakehouse data architecture, making it a robust platform that is reliable, scalable, and fast. Databricks speeds up innovations by synthesizing storage, engineering, business operations, security, and data science.

    Databricks is integrated with Microsoft Azure, Amazon Web Services, and Google Cloud Platform. This enables users to easily manage a colossal amount of data and to continuously train and deploy machine learning models for AI applications. The platform handles all analytic deployments, ranging from ETL to models training and deployment.

    Databricks deciphers the complexities of processing data to empower data scientists, engineers, and analysts with a simple collaborative environment to run interactive and scheduled data analysis workloads. The program takes advantage of AI’s cost-effectivity, flexibility, and cloud storage.

    Databricks Key Features

    Some of Databricks key features include:

    • Cloud-native: Works well on any prominent cloud provider.
    • Data storage: Stores a broad range of data, including structured, unstructured, and streaming.
    • Self-governance: Built-in governance and security controls.
    • Flexibility: Flexible for small-scale jobs as well as running large-scale jobs like Big Data processing because it’s built from Spark and is specifically optimized for Cloud environments.
    • Data science tools: Production-ready data tooling, from engineering to BI, AI, and ML.
    • Familiar languages: While Databricks is Spark-based, it allows commonly used programming languages like R, SQL, Scala, and Python to be used.
    • Team sharing workspaces: Creates an environment that provides interactive workspaces for collaboration, which allow multiple members to collaborate for data model creation, machine learning, and data extraction.
    • Data source: Performs limitless Big Data analytics by connecting to Cloud providers AWS, Azure, and Google, as well as on-premises SQL servers, JSON and CSV.

    Reviews from Real Users

    Databricks stands out from its competitors for several reasons. Two striking features are its collaborative ability and its ability to streamline multiple programming languages.

    PeerSpot users take note of the advantages of these features. A Chief Research Officer in consumer goods writes, “We work with multiple people on notebooks and it enables us to work collaboratively in an easy way without having to worry about the infrastructure. I think the solution is very intuitive, very easy to use. And that's what you pay for.”

    A business intelligence coordinator in construction notes, “The capacity of use of the different types of coding is valuable. Databricks also has good performance because it is running in spark extra storage, meaning the performance and the capacity use different kinds of codes.”

    An Associate Manager who works in consultancy mentions, “The technology that allows us to write scripts within the solution is extremely beneficial. If I was, for example, able to script in SQL, R, Scala, Apache Spark, or Python, I would be able to use my knowledge to make a script in this solution. It is very user-friendly and you can also process the records and validation point of view. The ability to migrate from one environment to another is useful.”

    KNIME is an open-source analytics software used for creating data science that is built on a GUI based workflow, eliminating the need to know code. The solution has an inherent modular workflow approach that documents and stores the analysis process in the same order it was conceived and implemented, while ensuring that intermediate results are always available. 

    KNIME supports Windows, Linux, and Mac operating systems and is suitable for enterprises of all different sizes. With KNIME, you can perform functions ranging from basic I/O to data manipulations, transformations and data mining. It consolidates all the functions of the entire process into a single workflow. The solution covers all main data wrangling and machine learning techniques, and is based on visual programming.

    KNIME Features

    KNIME has many valuable key features. Some of the most useful ones include:

    • Scalability through data handling (intelligent automatic caching of data in the background while maximizing throughput performance)
    • High extensibility via a well-defined API for plugin extensions
    • Intuitive user interface
    • Import/export of workflows
    • Parallel execution on multi-core systems
    • Command line version for "headless" batch executions
    • Activity dashboard
    • Reporting & statistics
    • Third-party integrations
    • Workflow management
    • Local automation
    • Metanode linking
    • Tool blending
    • Big Data extensions

    KNIME Benefits

    There are many benefits to implementing KNIME. Some of the biggest advantages the solution offers include:

    • Integrated Deployment: KNIME’s integrated deployment moves both the selected model, and the entire data model preparation process into production simply and automatically, allowing for continuous optimization in production and also saving time because it eliminates error.
    • Elastic and Hybrid Execution: KNIME’s elastic and hybrid executions helps you reduce costs while covering periods of high demand, dynamically.
    • Metadata Mapping: KNIME enables complete metadata mapping of all aspects of your workflow. In addition, KNIME offers blueprint workflows for documenting the nodes, data sources, and libraries used, as well as runtime information.
    • Guided Analytics: KNIME’s guided analytics applications can be customized based on reusable components.
    • Powerful analytics, local automation, and workflow difference: KNIME uses advanced predictive and machine learning algorithms to provide you with the analytics you need. In combination with powerful analytics, KNIME’s automation capabilities and workflow difference prepare your organization with the tools you need to make better business decisions.
    • Supports enterprise-wide data science practices: The deployment and management functionalities of KNIME make it easy to productionize data science applications and services, and deliver usable, reliable, and reproducible insights for the business.
    • Helps you leverage insights gained from your data: Using KNIME ensures the data science process immediately reflects changing requirements or new insights.

    Reviews from Real Users

    Below are some reviews and helpful feedback written by PeerSpot users currently using the KNIME solution.

    An Emeritus Professor at a university says, “It can read many different file formats. It can very easily tidy up your data, deleting blank rows, and deleting rows where certain columns are missing. It allows you to make lots of changes internally, which you do using JavaScript to put in the conditional. It also has very good fundamental machine learning. It has decision trees, linear regression, and neural nets. It has a lot of text mining facilities as well. It's fairly fully-featured.”

    Benedikt S., CEO at SMH - Schwaiger Management Holding GmbH, explains, “All of the features related to the ETL are fantastic. That includes the connectors to other programs, databases, and the meta node function. Technical support has been extremely responsive so far. The solution has a very strong and supportive community that shares information and helps each other troubleshoot. The solution is very stable. The initial setup is pretty simple and straightforward.”

    Piotr Ś., Test Engineer at ProData Consult, says, “What I like the most is that it works almost out of the box with Random Forest and other Forest nodes.”

    Sample Customers
    Elsevier, MyFitnessPal, Sharethrough, Automatic Labs, Celtra, Radius Intelligence, Yesware
    Infocom Corporation, Dymatrix Consulting Group, Soluzione Informatiche, MMI Agency, Estanislao Training and Solutions, Vialis AG
    Top Industries
    REVIEWERS
    Computer Software Company25%
    Financial Services Firm16%
    Retailer9%
    Manufacturing Company9%
    VISITORS READING REVIEWS
    Financial Services Firm15%
    Computer Software Company12%
    Manufacturing Company8%
    Healthcare Company6%
    REVIEWERS
    University25%
    Comms Service Provider17%
    Retailer14%
    Government8%
    VISITORS READING REVIEWS
    Manufacturing Company12%
    Financial Services Firm11%
    Computer Software Company9%
    Educational Organization8%
    Company Size
    REVIEWERS
    Small Business27%
    Midsize Enterprise14%
    Large Enterprise59%
    VISITORS READING REVIEWS
    Small Business17%
    Midsize Enterprise11%
    Large Enterprise71%
    REVIEWERS
    Small Business28%
    Midsize Enterprise26%
    Large Enterprise46%
    VISITORS READING REVIEWS
    Small Business19%
    Midsize Enterprise14%
    Large Enterprise67%
    Buyer's Guide
    Databricks vs. KNIME
    March 2024
    Find out what your peers are saying about Databricks vs. KNIME and other solutions. Updated: March 2024.
    769,976 professionals have used our research since 2012.

    Databricks is ranked 1st in Data Science Platforms with 78 reviews while KNIME is ranked 4th in Data Science Platforms with 50 reviews. Databricks is rated 8.2, while KNIME is rated 8.2. The top reviewer of Databricks writes "A nice interface with good features for turning off clusters to save on computing". On the other hand, the top reviewer of KNIME writes "A low-code platform that reduces data mining time by linking script". Databricks is most compared with Amazon SageMaker, Informatica PowerCenter, Dataiku Data Science Studio, Microsoft Azure Machine Learning Studio and Dremio, whereas KNIME is most compared with RapidMiner, Microsoft Power BI, Alteryx, Dataiku Data Science Studio and Amazon SageMaker. See our Databricks vs. KNIME report.

    See our list of best Data Science Platforms vendors.

    We monitor all Data Science Platforms 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.