Microsoft Docs

Azure Synapse Analytics

Synapse Analytics Tutorials

Learn how to build end‑to‑end analytics solutions with Azure Synapse. Follow step‑by‑step guides, code samples, and best‑practice recommendations.

Ingest Parquet
Data Ingestion

Ingest Parquet files using COPY

Learn how to use the COPY statement to efficiently load Parquet data from Azure Data Lake Storage into a dedicated SQL pool.

Start tutorial
Orchestrate pipelines
Data Transformation

Orchestrate data pipelines with Synapse Studio

Create, schedule, and monitor pipelines that move and transform data using data flows and activities.

Start tutorial
Power BI Integration
Visualization

Connect Power BI to Synapse Serverless

Build interactive reports directly on serverless SQL pools without moving data.

Start tutorial
Column level security
Security & Governance

Implement column‑level security

Protect sensitive data by configuring row‑level and column‑level security in Synapse SQL.

Start tutorial
Stream Analytics
Data Ingestion

Stream real‑time data with Azure Stream Analytics

Connect a Stream Analytics job to Synapse and process events in real time.

Start tutorial
Spark Notebook
Data Transformation

Run Spark notebooks for ETL

Use Synapse Spark pools to transform large datasets with PySpark notebooks.

Start tutorial