SQLBits 2023

Azure Data Factory, Azure Databricks, or Azure Synapse Analytics? When to use what.

Have you ever found yourself at the start of an Azure data engineering project, unsure about what tool to choose? Speak no more! In this session we will discuss three often used data engineering tools on Azure: - Azure Data Factory - Azure Databricks - Azure Synapse Analytics
Have you ever found yourself at the start of an Azure data engineering project, unsure about what tool to choose? Speak no more! In this session we will discuss three often used data engineering tools on Azure:

- Azure Data Factory
- Azure Databricks
- Azure Synapse Analytics

First, I will give a brief introduction to each tool. In discovering these tools together, we will find out for what use cases they are commonly used. Think of use cases like data ingestion, transformation, data streaming, data analysis, and visualization. Next, we will talk about what makes these tools different, and where they overlap (believe me, they do). Lastly, we will arrive at our conclusion: when to use what. Of course, a slide on differences in costs and performance will be included as well.