Scribd Logo
Upload

Welcome to Scribd!

  • 4 views

    Analytics and DWH With Azure Synapse

    Uploaded by

    Suresh Kumar
    Analytics and DWH with Azure Synapse

    Copyright:

    © All Rights Reserved
    Download as PDF, TXT or read online from Scribd

    Analytics and DWH With Azure Synapse

    Uploaded by

    Suresh Kumar
    4 views5 pages
    Analytics and DWH with Azure Synapse

    Original Title

    Analytics and DWH with Azure Synapse

    Copyright

    © © All Rights Reserved

    Available Formats

    PDF, TXT or read online from Scribd

    Did you find this document useful?

    Is this content inappropriate?

    Analytics and DWH with Azure Synapse

    Copyright:

    © All Rights Reserved
    Download as PDF, TXT or read online from Scribd
    Download as pdf or txt
    4 views5 pages

    Analytics and DWH With Azure Synapse

    Uploaded by

    Suresh Kumar
    Analytics and DWH with Azure Synapse

    Copyright:

    © All Rights Reserved
    Download as PDF, TXT or read online from Scribd
    Download as pdf or txt
    of 5

    Azure Synapse

    Analytics and DWH with Azure Synapse


    This short document will give you an overview on
    Azure Synapse

    Introduction

    You can find the complete recorded session and live event details on 5thIR.

    What is 5thir?

    5thIR gives technologists and startups an easy option to host their events, build community
    and distribute their talks and sessions in the form of self paced as well as instructor led
    courses.

    A life of a session starts with the live event if it's free or batch based events, if it's paid and
    further the recording document and contents remain at the same location so that
    engineers participating in the events can any time easily navigate to the page, watch
    recordings, take certificates and download resources.

    How to RSVP, Download Calendar Invite, Take certificates and watch recordings?
    https://www.5thir.com/eventportal/eventproductlisting.aspx?eid=1558d4468fec4d429b6b2
    694d3b0ASAA

    To navigate to the speakers profile?

    https://www.5thir.com/eventportal/speaker.aspx?spid=257484F2591D4BDF91012A37F9D3
    20FE

    What is Azure Synapse

    Azure Synapse is an 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 on-demand or provisioned resources—at scale. Azure Synapse brings
    these two worlds together with a unified experience to ingest, prepare, manage, and
    serve data for immediate BI and machine learning needs.

    Azure Synapse has four components:

    ● Synapse SQL: Complete T-SQL based analytics – Generally Available


    ○ Dedicated SQL pool (pay per DWU provisioned)
    ○ Serverless SQL pool (pay per TB processed) (preview)
    ● Spark: Deeply integrated Apache Spark (preview)
    ● Synapse Pipelines: Hybrid data integration (preview)
    ● Studio: Unified user experience. (preview)

    2
    Typical data warehouse architecture (As per Microsoft)

    Azure Synapse Architecture (As per Microsoft)

    3
    How to start with?

    Obviously Arshad from Microsoft in the session on 29th of November (recording


    available in the same link after the event has happened))will be talking in detail about
    that but to still be ready? Best is this 15-20 minute read in the following sequence.

    Read1:-

    https://docs.microsoft.com/en-us/azure/synapse-analytics/sql-data-warehouse/sql-data-wa
    rehouse-overview-what-is

    https://docs.microsoft.com/en-us/azure/synapse-analytics/sql-data-warehouse/sql-data-wa
    rehouse-overview-faq

    Read2:- (Load data .. Hello world)

    https://docs.microsoft.com/en-us/azure/synapse-analytics/sql-data-warehouse/create-data-
    warehouse-portal

    https://docs.microsoft.com/en-us/azure/synapse-analytics/sql-data-warehouse/quickstart-b
    ulk-load-copy-tsql

    https://docs.microsoft.com/en-us/azure/data-factory/load-azure-sql-data-warehouse?toc=/
    azure/synapse-analytics/sql-data-warehouse/toc.json&bc=/azure/synapse-analytics/sql-dat
    a-warehouse/breadcrumb/toc.json

    Read3:-

    https://docs.microsoft.com/en-us/azure/synapse-analytics/sql-data-warehouse/massively-p
    arallel-processing-mpp-architecture

    4
    Any questions? ask to Arshad in the event

    See you in the event or on dashboard for watching the event enrolling to further
    sessions.

    You might also like