Create a workspace
Start with an Azure Synapse workspace, connect it to storage, and configure access through Microsoft Entra ID and role-based permissions.
How it is used
Typical Azure Synapse workflow
Synapse is usually used as an analytics workspace where data engineers, analysts, and BI developers move from raw data to trusted insights.
Connect data sources
Link services such as Azure Data Lake Storage, Azure SQL Database, Blob Storage, or external systems that provide operational data.
Ingest and transform
Use Synapse pipelines, Spark notebooks, SQL scripts, or mapping data flows to clean, enrich, and structure data.
Query and publish
Analyze data with serverless SQL, dedicated SQL pools, or Spark, then publish curated datasets to BI tools and downstream applications.
Best fit
Common use cases
- Enterprise data warehousing and reporting
- Lakehouse-style analytics on files in data lakes
- Batch data engineering pipelines
- Exploratory analytics with SQL and Apache Spark
- Business intelligence datasets for Power BI