Azure Synapse Analytics terminology

This document guides you through the basic concepts of Azure Synapse Analytics.

Basics

A Synapse workspace is a securable collaboration boundary for doing cloud-based enterprise analytics in Azure. A workspace is deployed in a specific region and has an associated ADLS Gen2 account and file system (for storing temporary data). A workspace is under a resource group.

A workspace allows you to perform analytics with SQL and Apache spark. Resources available for SQL and Spark analytics are organized into SQL and Spark pools.

Linked services

A workspace can contain any number of Linked service, essentially connection strings that define the connection information needed for the workspace to connect to external resources.

Synapse SQL

Synapse SQL is the ability to do T-SQL based analytics in Synapse workspace. Synapse SQL has two consumption models: dedicated and serverless. For the dedicated model, use dedicated SQL pools. A workspace can have any number of these pools. To use the serverless model, use the serverless SQL pools. Every workspace has one of these pools.

Inside Synapse Studio, you can work with SQL pools by creating and running SQL scripts .

Apache Spark for Synapse

To use Spark analytics, create and use serverless Apache Spark pools in your Synapse workspace. When you start using a Spark pool, the workspaces creates a spark session to handle the resources associated with that session.

There are two ways within Synapse to use Spark:

  • Spark Notebooks for doing data Data Science and Engineering use Scala, PySpark, C#, and SparkSQL
  • Spark job definitions for running batch Spark jobs using jar files.

Pipelines

Pipelines are how Azure Synapse provides Data Integration - allowing you to move data between services and orchestrate activities.

  • Pipeline are logical grouping of activities that perform a task together.
  • Activities defines actions within a Pipeline to perform on data such as copying data, running a Notebook or a SQL script.
  • Data Flows are a specific kind of activity that provide a no-code experience for doing data transformation that uses Synapse Spark under-the-covers.
  • Trigger - Executes a pipeline. It can be run manually or automatically (schedule, tumbling window or event-based)
  • Integration dataset - Named view of data that simply points or references the data to be used in an activity as input and output. It belongs to a Linked Service.

Next steps