Databricks Lakehouse Platform vs Snowflake

Likelihood to Recommend

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.

Read full review

Verified User

Team Lead in Engineering

Financial Services Company, 10,001+ employees

View all 7 answers on this topic

It is highly recommended to those companies that need a track and secure mode for the transfer of the data. Its sharing is amazing for the business community. It will be suitable for the B2B type business setups. This tool is very cost-effective and will align your daily technical queries for better handling.

Read full review

Darren Mihalic

Business Development Manager

Torqx Capital PartnersVenture Capital & Private Equity, 11-50 employees

View all 26 answers on this topic

Pros

It supports all data science programming languages like Python and R
it takes very few minutes to deploy models into production
it has tools that ensures collaborations between developers

Read full review

Kofi Joshua

Machine Learning And Deep Learning Mentee

Runmila AI InstituteEducation Management, 201-500 employees

View all 7 answers on this topic

Snowflake is very easy to use and doesn't have heavy DBA overhead.
Snowflake's ability to separate storage and compute is a radical departure from how databases of the past were built.
Snowflake is very easy for customers to scale as their needs shrink and grow.

Read full review

Brian Bickell

Data Practice Director

InterWorksInformation Services, 201-500 employees

View all 26 answers on this topic

Cons

Better Localized Testing
When they were primarily OSS Spark; it was easier to test/manage releases versus the newer DB Runtime. Wish there was more configuration in Runtime less pick a version.
Graphing Support went non-existent; when it was one of their compelling general engine.

Read full review

Verified User

Director in Information Technology

Financial Services Company, 201-500 employees

View all 7 answers on this topic

Snowflake UI can be clunky and breaks sometimes, which can be annoying
Snowflake has to be paired with the Data Build Tool (DBT) to allow for templating and macro usage. No inbuilt solution.
Snowflake Python connector development doesn't necessarily track popular packages such as Pandas as quickly as Pandas releases
Could do with better machine learning capability over warehouse tables, but I assume this is coming soon

Read full review

Verified User

Engineer in Other

Computer Software Company, 201-500 employees

View all 26 answers on this topic

Likelihood to Renew

No score

No answers yet

No answers on this topic

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

Read full review

Verified User

Team Lead in Engineering

Computer Games Company, 51-200 employees

View all 1 answers on this topic

Usability

Databricks Lakehouse 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

Read full review

Verified User

Team Lead in Engineering

Financial Services Company, 10,001+ employees

View all 1 answers on this topic

Snowflake 8.7

Based on 11 answers

The interface is similar to other SQL query systems I've used and is fairly easy to use. My only complaint is the syntax issues. Another thing is that the error messages are not always the easiest thing to understand, especially when you incorporate temp tables. Some of that is to be expected with any new database.

Read full review

Jake Schlingman

Product Manager

AppFolio, Inc.Computer Software, 1001-5000 employees

View all 11 answers on this topic

Support Rating

No score

No answers yet

No answers on this topic

Snowflake 8.7

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.

Read full review

Verified User

Analyst in Corporate

Cosmetics Company, 10,001+ employees

View all 10 answers on this topic

Alternatives Considered

I also use Microsoft Azure Machine Learning in parallel with Databricks. They use different file formats which teach me to be flexible and able to write different programs. They are equally useful to me and I would like to master both platforms for any future usage. I do prefer Databricks because it could be free if I decided to go with the Databricks Community Edition only.

Read full review

Ann Le

Freelance Translator

ZOO Digital Group plcEntertainment, 501-1000 employees

View all 7 answers on this topic

Delivered as an easy-to-use data warehouse service, Snowflake enables you to process and analyze all your diverse data, build multiple databases, query with a common robust ANSI SQL environment, and execute ACID transnational capabilities.
No need to create indexes and optimize query plans—plan storage capacity months in advance.
Easy to configure new instances, create databases and set up security.

Read full review

Verified User

Analyst in Information Technology

Consumer Goods Company, 51-200 employees

View all 26 answers on this topic

Return on Investment

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

Read full review

Verified User

Strategist in Engineering

Computer Hardware Company, 10,001+ employees

View all 7 answers on this topic

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.

Read full review

Jacob Biguvu

Database Engineer/DBA (Cloud and On-Premises)

Capital OneFinancial Services, 10,001+ employees

View all 26 answers on this topic

Pricing Details

General

Free Trial

—

Free/Freemium Version

—

Premium Consulting/Integration Services

—

Entry-level set up fee?

No

Databricks Lakehouse Platform Editions & Modules

Edition

Standard	$0.07¹
Premium	$0.10¹
Enterprise	$0.13¹

Per DBU

Additional Pricing Details

—

General

Free Trial

—

Free/Freemium Version

—

Premium Consulting/Integration Services

—

Entry-level set up fee?

No

Snowflake Editions & Modules

Edition

US East	$20.00¹

Per TB

Additional Pricing Details

—