What are the main components of Azure Synapse Analytics?

Ramya Harinarthini_MSFT 2,591 Reputation points Microsoft Employee
2020-05-14T07:30:35.533+00:00

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
Accepted answer
  1. PRADEEPCHEEKATLA-MSFT 59,331 Reputation points Microsoft Employee
    2020-05-14T07:37:55.16+00:00

    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
Most helpful Newest Oldest
  1. Marri, Ananda Krishna [ITSSG] 1 Reputation point
    2022-07-14T11:03:02.107+00:00

    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)
      pipelines/dataflow
      datawarehouse (Component - dedicated SQLPool)
    3. Persona - Administrator
      Spool creations
      Linked services
      security
    0 comments