What users are saying about
24 Ratings
<a href='https://www.trustradius.com/static/about-trustradius-scoring' target='_blank' rel='nofollow noopener noreferrer'>trScore algorithm: Learn more.</a>
Score 8.5 out of 100
Top Rated
80 Ratings
<a href='https://www.trustradius.com/static/about-trustradius-scoring' target='_blank' rel='nofollow noopener noreferrer'>trScore algorithm: Learn more.</a>
Score 9.1 out of 100

Highlights

Databricks and Snowflake are solutions for processing big data workloads and tend to be deployed at larger enterprises. Databricks handles data ingestion, data pipeline engineering, and ML/data science with its collaborative workbook for writing in R, Python, etc. Snowflake is a cloud-based SQL data warehouse that emphasizes analysis acceleration, data access, & BI collaboration through its Snowflake Data Exchange that allows data to flow across departments, and the Snowflake Data Marketplace data-as-a-service (DaaS) which provides data from third-parties or vendor partners, and allows users to monetize their own data.

Through a strategic partnership, a connection between the solutions enables one to use Databricks’ storage layer to ingest and prepare data for storage in Snowflake; and use a Databricks notebook to act on data stored in Snowflake (e.g. train an ML model). Documentation on how to implement the connection is published by Snowflake, Databricks, and Azure support.

Features

For entities processing large quantities of data, Snowflake and Databricks both provide unique advantages over competitors.

Users appreciate Snowflake for its power, and the ease-of-use of its SQL query engine, and the speed of its data warehouse when querying data. Snowflake is flexible, and sits on Azure, S3, or Google Cloud. It is also described as fast to set up, and operable with a low footprint.

Similarly, Databricks is praised for its core competencies; its data science notebook is better than alternatives (e.g. Jupyter Notebook) for enabling flexible and fast analysis on massive amounts of data while swapping between work in SQL, R, Scala, Python. Its open source community documentation, available to all, is well regarded.

Limitations

Databricks and Snowflake also have some key limitations that are important to consider.

Databricks is costly, as is its certification cost. Additionally, Databricks can be hard to use for non-technical users, who say its in-app help is unclear and hard to use. And a few say Databricks lacks good visualizations for displaying work.

Snowflake lacks a desktop tool, which opens a door to competitors with on-prem options ( Vertica, Teradata Vantage, SAP BW/4HANA). Snowflake’s performance is strictly cloud service provider dependent, which may present an issue. Some complain Snowflake’s UI is difficult to use, and that its table expression support and SQL editor lack expected features (e.g. debug, auto-fill).

Pricing

Snowflake’s pricing is based on storage and data loading usage, as well as service tier. The Standard tier starts at $2 per compute hour and is a complete SQL Data Warehouse with always-on encryption and 24-hour support. Snowflake Enterprise adds data masking, tokenization, search optimization for lookups, as well as extended “time travel” (i.e. historical data access) for $3 per compute hour. The Business Critical edition is $4 per compute hour and includes data compliance, Azure / AWS PrivateLink support, database failover protection, and continuity service.

Azure Databricks bills for virtual machines provisioned in clusters and Databricks Units, (DBUs, processing capability priced per second) based on VM instance. VMs are based on Azure’s rates. Databricks Units are priced on workload type (Data Engineering, Data Engineering Light, or Data Analytics) and service tier: Standard vs. Premium. The Premium tier adds authentication and access features, and audit log. The Data Analytics workload plan is $.40 per DBU hour ($.55 premium tier) and includes data preparation and the data science notebook. The Data Engineering tier includes only the data pipeline and workload processing; it’s available for $.15 per DBU hour ($.30 Premium tier). Data Engineering Light is available at $.07 per DBU hour ($.22 Premium tier) and only allows users to run jobs.

Databricks AWS price depends on service tier (Standard, Premium, Enterprise) and workload. Service Tier determines security and privacy; higher tiers add Optimized Autoscaling with Premium adding role-based access, federated IAM, etc., and Enterprise adds HIPAA compliant storage, access lists for audit, and customer-managed keys. The Jobs Compute workload service allows users to run data engineering pipelines and manage & clean data lakes (priced $.07, $.10, .$13 per service tier), and the All-Purpose Compute service ($.40, $.55, $.65) is fully featured.

Likelihood to Recommend

Databricks Unified Analytics Platform

Databricks has helped my teams write PySpark and Spark SQL jobs and test them out before formally integrating them in Spark jobs. Through Databricks we can create parquet and JSON output files. Datamodelers and scientists who are not very good with coding can get good insight into the data using the notebooks that can be developed by the engineers.
Anonymous | TrustRadius Reviewer

Snowflake

Specific scenarios where Snowflake is very strong include analytical data processing scenarios. Snowflake is wonderful at inexpensively consolidating and storing data and allowing very fast access to that data while maintaining a low cost profile with it's ability to automatically resume and suspend virtual warehouses. Snowflake is less suited to transaction processing scenarios and isn't a best choice to back up an online order processing system.
Brian Bickell | TrustRadius Reviewer

Feature Rating Comparison

Platform Connectivity

Databricks Unified Analytics Platform
8.3
Snowflake
Connect to Multiple Data Sources
Databricks Unified Analytics Platform
9.0
Snowflake
Extend Existing Data Sources
Databricks Unified Analytics Platform
9.0
Snowflake
Automatic Data Format Detection
Databricks Unified Analytics Platform
7.0
Snowflake

Data Exploration

Databricks Unified Analytics Platform
6.0
Snowflake
Visualization
Databricks Unified Analytics Platform
6.0
Snowflake
Interactive Data Analysis
Databricks Unified Analytics Platform
6.0
Snowflake

Data Preparation

Databricks Unified Analytics Platform
8.0
Snowflake
Interactive Data Cleaning and Enrichment
Databricks Unified Analytics Platform
8.0
Snowflake
Data Transformations
Databricks Unified Analytics Platform
9.0
Snowflake
Data Encryption
Databricks Unified Analytics Platform
7.0
Snowflake
Built-in Processors
Databricks Unified Analytics Platform
8.0
Snowflake

Platform Data Modeling

Databricks Unified Analytics Platform
8.3
Snowflake
Multiple Model Development Languages and Tools
Databricks Unified Analytics Platform
9.0
Snowflake
Automated Machine Learning
Databricks Unified Analytics Platform
8.0
Snowflake
Single platform for multiple model development
Databricks Unified Analytics Platform
9.0
Snowflake
Self-Service Model Delivery
Databricks Unified Analytics Platform
7.0
Snowflake

Model Deployment

Databricks Unified Analytics Platform
7.5
Snowflake
Flexible Model Publishing Options
Databricks Unified Analytics Platform
7.0
Snowflake
Security, Governance, and Cost Controls
Databricks Unified Analytics Platform
8.0
Snowflake

Pros

Databricks Unified Analytics Platform

  • Extremely Flexible in Data Scenarios
  • Fantastic Performance
  • DB is always updating the system so we can have latest features.
Anonymous | TrustRadius Reviewer

Snowflake

  • Resources that scale up and down automatically to ensure that queries run quickly and efficiently without paying for computing power that is not being used
  • Much more reliable than our previous software
  • No noticable limit to query size
  • Runs very quickly
Jake Schlingman | TrustRadius Reviewer

Cons

Databricks Unified Analytics Platform

  • The navigation through which one would create a workspace is a bit confusing at first. It takes a couple minutes to figure out how to create a folder and upload files since it is not the same as traditional file systems such as box.com
  • Also, when you create a table, if you forgot to copy the link where the table is stored, it is hard to relocate it. Most of the time I would have to delete the table and re-created.
Ann Le | TrustRadius Reviewer

Snowflake

  • Very limited amount of tabs - saved queries, which requires us to store the code somewhere else and re-use existing queries.
  • Performance can really be a problem if there are many users on the system at the same time.
  • SnowFlake support sometimes can be hard to reach.
Anonymous | TrustRadius Reviewer

Likelihood to Renew

Databricks Unified Analytics Platform

No score
No answers yet
No answers on this topic

Snowflake

Snowflake 8.0
Based on 1 answer
SnowFlake is very cost effective and we also like the fact we can stop, start and spin up additional processing engines as we need to. We also like the fact that it's easy to connect our SQL IDEs to Snowflake and write our queries in the environment that we are used to
Anonymous | TrustRadius Reviewer

Usability

Databricks Unified Analytics Platform

Databricks Unified Analytics Platform 9.0
Based on 1 answer
This has been very useful in my organization for shared notebooks, integrated data pipeline automation and data sources integrations. Integration with AWS is seamless. Non tech users can easily learn how to use Databricks. You can have your company LDAP connect to it for login based access controls to some extent
Anonymous | TrustRadius Reviewer

Snowflake

Snowflake 8.7
Based on 11 answers
Extensive documentation and several tutorial videos are available online which reduces learning and deployment time. User Interface is very intuitive and provide flexibility to create databases, schema, tables and assign permissions in a few clicks (no need to write SQL queries). SQL History helps to track usages and billing dashboard provide credit breakup per warehouse. Create views and write procedures in JavaScript for more complex data transformation requirement
Anonymous | TrustRadius Reviewer

Support Rating

Databricks Unified Analytics Platform

No score
No answers yet
No answers on this topic

Snowflake

Snowflake 8.5
Based on 10 answers
Overall, the support from Snowflake has been very good. Since we are one of the major users for Snowflake and have a dedicated tech team to solve all the technical problem on our way. On the side of the technical problem, any sql related questions can be found from everywhere online.
Anonymous | TrustRadius Reviewer

Alternatives Considered

Databricks Unified Analytics Platform

Easier to set up and get started. Less of a learning curve.
Anonymous | TrustRadius Reviewer

Snowflake

The average percentage of time that a data warehouse is actually doing something is around 20%. Given this, the price by query estimate becomes an important pricing consideration. For this, Snowflake crucially decouples of storage and compute. With Snowflake you pay for 1) storage space used and 2) amount of time spent querying data. Snowflake also has a notion of a “logical warehouse” which is the “compute” aspect of the database. These warehouses can be scaled up or down to deliver different grades of performance. You can also configure the number of compute nodes to parallelize query execution. These warehouses can be configured to “pause” when you’re not using them for cost efficiency. As a result, you can have a super beefy warehouse for BI queries that’s only running when people are using your BI tools, while your background batch jobs can use cheaper hardware.
Andrew Goss | TrustRadius Reviewer

Return on Investment

Databricks Unified Analytics Platform

  • Rapid growth of analytics within our company.
  • Cost model aligns with usage allowing us to make a reasonable initial investment and scale the cost as we realize the value.
  • Platform is easy to learn and Databricks provides excellent support and training.
  • Platform does not require a large DevOPs investment
Anonymous | TrustRadius Reviewer

Snowflake

  • Quick installation/setup for a data warehouse solution.
  • Make easy to handle/manage the various type of semi-structured data using the native solutions and provided new data modeling concepts such as schema-read data model and schema-write data model.
  • Make easy and simplified the workload management using virtual warehouses and materialized views.
Jacob Biguvu | TrustRadius Reviewer

Pricing Details

Databricks Unified Analytics Platform

General

Free Trial
Free/Freemium Version
Premium Consulting/Integration Services
Entry-level set up fee?
No

Snowflake

General

Free Trial
Free/Freemium Version
Premium Consulting/Integration Services
Entry-level set up fee?
No

Rating Summary

Likelihood to Recommend

Databricks Unified Analytics Platform
8.9
Snowflake
9.1

Likelihood to Renew

Databricks Unified Analytics Platform
Snowflake
8.0

Usability

Databricks Unified Analytics Platform
9.0
Snowflake
8.7

Support Rating

Databricks Unified Analytics Platform
Snowflake
8.5

Add comparison