What are the main components of Azure Synapse Analytics?

Ramya Harinarthini_MSFT 2,591 Reputation points Microsoft Employee

What are the main components of Azure Synapse Analytics?

[Note: As we migrate from MSDN, this question has been posted by an Azure Cloud Engineer as a frequently asked question]

Sourced from Azure Synapse FAQ

Azure Synapse Analytics
Azure Synapse Analytics
An Azure analytics service that brings together data integration, enterprise data warehousing, and big data analytics. Previously known as Azure SQL Data Warehouse.
3,106 questions
0 comments No comments
{count} votes

Accepted answer
  1. PRADEEPCHEEKATLA-MSFT 59,331 Reputation points Microsoft Employee

    Welcome to the Microsoft Q&A platform.

    Happy to answer your questions.

    Azure Synapse has the following capabilities:

      • Analytics capabilities are offered through SQL pool or SQL on-demand (preview) (Serverless).
    • Apache Spark pool (preview) with full support for Scala, Python, SparkSQL, and C#
    • Data Flow offering a code-free big data transformation experience
    • Data Integration & Orchestration to integrate your data and operationalize all of your code development
    • Studio to access all of these capabilities through a single Web UI

    Hope this helps.

    Sourced from Azure Synapse FAQ

1 additional answer

Sort by: Most helpful
  1. Marri, Ananda Krishna [ITSSG] 1 Reputation point

    You need to classify your use cases. Below are some examples

    1. Personas - Data Analyst/Scientists/ML/AI
      Performs SQL/Spark queries on data. (Components - Spark Spool , Serverless SQL Pool)
      Typically readonly database objects
      Power BI integration
    2. Persona - Data Engineers
      Database creations (lake database/serverless/SQL DW)
      datawarehouse (Component - dedicated SQLPool)
    3. Persona - Administrator
      Spool creations
      Linked services
    0 comments No comments