What are the main components of Azure Synapse Analytics?

Ramya Harinarthini_MSFT 5,366 Reputation points Microsoft Employee Moderator
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.
5,378 questions
0 comments No comments
{count} votes

Accepted answer
  1. PRADEEPCHEEKATLA 90,651 Reputation points Moderator
    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
  1. Marri, Ananda Krishna 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 No comments

Your answer

Answers can be marked as Accepted Answers by the question author, which helps users to know the answer solved the author's problem.