Databricks serverless Vs snowflake

Phani1 — Mon, 30 Sep 2024 07:56:04 GMT

Hi All,

We want to switch from Snowflake to Databricks SQL Warehouse/serverless to simplify our data layers and reduce data copies before the reporting layer. Please share the benefits of using serverless over Snowflake and any limitations you see. We value your opinion on this.

Regards,Phani

Re: Databricks serverless Vs snowflake

-werners- — Mon, 30 Sep 2024 11:18:51 GMT

one big pro is that you do not need to copy data to the dwh. also your transformations and analytics queries reside on the same platform (databricks).
If databricks can cover all the requirementsm compared to snowflakem is hard to tell. Probably there are functionalities that are available in one but not in the other and vice versa.

Costwise it is necessary to analyse your current query consumption on snowflake, and then use a cost calculator to see what it would cost on databricks (serverless/classic dwh).

We decided to get rid of Synapse (which is similar to snowflake but way crappier) and use sql serverless instead.
We calculated that costwise it would be a small saving, but effortwise and maintenancewise a big win.

topic Databricks serverless Vs snowflake in Get Started Discussions

Databricks serverless Vs snowflake

Re: Databricks serverless Vs snowflake