A practical guide to moving from Synapse's Dedicated SQL, Serverless, and Spark pools to one unified Databricks Lakehouse governed by Unity Catalog
by Olga Romanova and Johannes Oehler
Azure Synapse has served as a reliable foundation for SQL analytics at scale, and teams that built on it made a sensible choice at the time. However, a platform primarily designed around a data warehouse isn't built for the full range of what data teams are now expected to deliver. Filling those gaps usually involves adding more services, integrations and operational overhead, which builds up over time.
Migrating to Databricks is one way to address this issue. In this blog we address how to approach Synapse migration and what to keep in mind while executing it.
Across Synapse migration engagements we see with our customers, three business drivers come up consistently:
