Azure Synapse Analytics

Azure Synapse is a limitless analytics service that brings together enterprise data warehousing and Big Data analytics. It gives you the freedom to query data on your terms, using either serverless or dedicated resources—at scale.

Azure Synapse Analytics
Switch to dedicated SQL pool formerly SQL DW >
Overview
Quickstarts
Workspace
- What's the difference between Azure Synapse formerly SQL DW and Azure Synapse Analytics workspaces?
- Quickstarts
  - Create a workspace
  - Link a Power BI workspace
  - Read ADLS Gen2 into Pandas dataframe
  - Connect to Azure Data Explorer
  - Partner solutions
- Concepts
  - Shared metadata management
    - Overview
    - Metadata objects
      - Shared databases
      - Shared tables
    - Code artifacts
  - Maintenance schedule
  - Source control
  - Continuous integration and delivery
  - Security
    - Security baseline
    - Security Controls by Azure Policy
    - Encryption
    - Network Security
    - Authentication and pass-through
    - Access control
- How-to guides
  - Manage and Monitor
    - Monitor Synapse Analytics
    - Monitoring data reference
  - Secure
    - Manage access control
    - Data exfiltration protection
      - Create and manage a workspace with data exfiltration protection
    - Manage private endpoints
  - Troubleshoot
  - Move workspace to new region
  - Move workspace to another tenant
Database templates
- Overview
  - Database templates overview
  - Map data overview
- Quickstarts
  - Create a lake database
- Concepts
  - Database templates
  - Lake database
- How-to guides
Synapse SQL
- Overview
- Quickstarts
  - Use serverless SQL pool
  - Create a dedicated SQL pool using Synapse Studio
  - Create a dedicated SQL pool using Azure portal
  - Pause and resume using PowerShell
  - Pause and resume using Azure portal
  - Load data with dedicated SQL pools
  - Workload management
    - Scale compute using the Azure portal
    - Scale compute using PowerShell
    - Scale compute using T-SQL
    - Create workload classifier
      - Portal
      - T-SQL
    - Create workload isolation
      - Portal
      - T-SQL
- Tutorials
- Concepts
  - Back up and restore
  - Data ingestion and preparation
  - Development
    - Overview
    - Best practices serverless SQL pool
    - Best practices dedicated SQL pools
    - Distribution Advisor
    - Materialized view
    - Ordered clustered columnstore index
      - Performance tuning guidance
    - Result set caching
    - Machine learning predictions
    - Tables
    - T-SQL language elements
      - Loops
      - Stored procedures
      - Transactions
        
        Dedicated SQL pool transactions
        
        Dedicated SQL pool best practices transactions
      - User-defined schemas
      - Variable assignment
      - Views
    - Querying
      - Dynamic SQL
      - Group by options
      - Labels
      - Storage files
        
        Overview
        
        Storage Access Control
        
        Apache Spark for Azure Synapse external tables
  - Monitoring
  - Security
    - Database access control
    - Shared database access control
    - Data security
      - Column-level security
      - Row-level security
    - Data Encryption
      - Transparent Data Encryption overview
      - TDE with bring your own key
  - Workload management
- How-to guides
  - Back up and restore
  - Manage and monitor
  - Ingest and prepare data
    - Into the data warehouse
    - Into the Data Lake
      - With the copy activity
  - Change management and deployment
  - Query external data
  - Integrate
    - Build data pipelines
      - Add an Azure Stream Analytics job
  - Connect with tools and applications
  - Troubleshoot serverless SQL pools
    - Troubleshoot serverless SQL pools
Data Explorer
- Overview
  - Data Explorer overview
  - Compare with Azure Data Explorer
  - Data ingestion
- Quickstarts
  - Create a Data Explorer pool using the Azure portal
  - Create a Data Explorer pool using the Synapse Studio
  - Ingest data
    - Overview
    - One-click ingestion
    - Streaming ingestion
    - Event Hubs
    - Event Grid
      - Event Grid data connection
      - Azure portal
    - Ingest data using pipelines
  - Monitor and diagnose pools
- Kusto Query Language
- Management commands
- Reference
  - API
  - Functions library
Apache Spark
Synapse Link
- Overview
- Quickstarts
  - Connect to Synapse Link for Azure Cosmos DB
- Concepts
  - Azure Cosmos DB
  - SQL Database
    - Synapse Link for Azure SQL Database
    - SQL FAQ
  - SQL Server 2022
    - Synapse Link for SQL Server 2022
    - SQL FAQ
  - Dataverse
- How-to guides
Pipeline and data flow
- Quickstarts
- Concepts
  - Pipeline and activity
  - Linked services
  - Datasets
  - Execution and trigger
  - Integration runtime
  - Differences from Azure Data Factory
  - Data flows
    - Data flow overview
    - Debug mode
    - Schema drift
    - Column patterns
    - Data flow monitoring
    - Data flow performance
    - Integration Runtime performance
    - Manage graph
    - Expression builder
    - Expression language
- How-to guides
Machine Learning
- Overview
  - What is machine learning in Azure Synapse?
- Quickstarts
  - Use a sample notebook from the gallery
  - Use the Retail AI solution
  - Create a linked service
    - Azure Machine Learning
    - Azure AI services
- Concepts
- Tutorials
  - Data access and preparation
    - Visualize data with Apache Spark
    - Access ADLSg2 from Azure ML
  - Train a model
    - With Apache Spark MLlib
    - With automated machine learning deprecated
      - Code-free deprecated
      - In Python deprecated
    - With Horovod and Petastorm deprecated
  - Score a model
Data Catalog and Governance
- Quickstarts
  - Connect a Microsoft Purview Account
- How-to guides
  - Access a secured Microsoft Purview account
  - Discover, connect and explore data in Synapse using Microsoft Purview
How-to
Guidance
- Azure Synapse Success by Design
  - Introduction
  - Synapse proof of concept playbook
  - Synapse implementation success methodology
- Migration guides
- Security white paper
Reference
Resources

Azure Docs Links

Azure Synapse Analytics