Synapse and databricks

Question

Hi friends I have seen the refrence https://learn.microsoft.com/en-us/answers/questions/587071/differnce-between-synapse-and-databricks.html still not understanding why synpase prefer over Databricks. Synapse is expensive explain what is the advantage of using Synapse n databricks including costs and performance

Answer 1

Hello @Anshal ,

Thanks for the question and using MS Q&A platform.

Yes, you are correct. Azure Synapse Analytics is expensive when compared to Databricks.

In the end, the ultimate decision between Databricks and Azure Synapse may simply come down to whether or not your organization is already well-versed in the Azure platform.

For organizations dedicated to open source tools, Databricks may be the optimal choice. But if your teams are already familiar with Azure and its suite of tools, Azure Synapse may be the path of least resistance toward achieving your analytics goals.

Azure Synapse advantages over Azure Databricks:

• Azure Synapse Analytics is a limitless analytics service that brings together data integration, enterprise data warehousing and big data analytics.
• It gives you the freedom to query data on your terms, using either serverless or dedicated resources—at scale.
• Azure Synapse brings these worlds together with a unified experience to ingest, explore, prepare, manage and serve data for immediate BI and machine learning needs.

You may refer to the below articles for more detailed information:

• When to use Azure Synapse Analytics and/or Azure Databricks?
• Databricks Vs Synapse Spark Pools – What, When and Where?
• Azure Synapse or Databricks — Which is Right for Your Organization?

Hope this will help. Please let us know if any further queries.

------------------------------

• Please don't forget to click on or upvote button whenever the information provided helps you. Original posters help the community find answers faster by identifying the correct answer. Here is how
• Want a reminder to come back and check responses? Here is how to subscribe to a notification
• If you are interested in joining the VM program and help shape the future of Q&A: Here is how you can be part of Q&A Volunteer Moderators