Introdução ao Azure Synapse Analytics - Comunidade Solidaria Microsoft 2020

Nessa sessão apresentei uma introdução ao serviço e as novidades do Azure Synapse Analystics já disponíveis para utilização no Azure que foram lançadas no Microsoft Build de 2020. Também fiz um rapido um hands-on percorrendo as principais features que tornam esse novo serviço uma das ferramentas mais robustas do Micrososft Azure.

Gravação disponível no Youtube: https://www.youtube.com/watch?v=lKXab_vGH6s

Transcript

3. DATA ANALYST (Data & AI) at LANLINK About Me Sidney Oliveira Cirqueira BIG DATA & MACHINE LEARNING ENTHUSIAST
4. Agenda What is Azure Synapse Analytics? Synapse Analytics (GA) (formerly SQL DW) – “v1” Synapse Analytics (Preview) – “v2” Synapse Analytics Key Features (GA & Preview) Synapse Analytics Link for Azure Cosmos DB (Preview)
5. What is Azure Synapse Analytics? Limitless analytics service that brings together enterprise data warehousing and Big Data analytics with a unified experience to ingest, prepare, manage, and serve data for immediate BI and machine learning needs.
6. Azure Synapse Analytics (formerly SQL DW) – “v1” MPP – Massively Parallel Processing
7. Key component of Modern Data Warehouse Azure Data Factory Azure Databricks (Prep-only) Azure Data Lake Storage Power BI Ingest & Prep Store Model & Serve Visualize Azure SQL Data Warehouse
8. Azure Synapse Analytics – Data Lakehouse Azure Data Lake Storage Power BI Store Visualize Azure Synapse Analytics
9. Azure Synapse Analytics Azure Data Lake Storage Store Azure Synapse Analytics
10. Azure Synapse Analytics – “v2”
11. Azure Synapse Analytics – “v2”
12. Azure Synapse Analytics Features Limitless Scale GA Provisioned Compute Materialized views Result-set cache Workload importance Workload isolation Preview Serverless data lake Exploration Powerful insights Preview Power BI integration Azure Machine Learning integration Stream analytics (data warehouse) Apache Spark integration Unified experience Preview Hybrid data ingestion Azure Synapse Studio Instant Clarity Preview Azure Synapse Link Unmatched security GA Column and row-level security Dynamic data masking Private endpoints
13. Azure Synapse Link for Cosmos DB (Preview)
14. DEMO
15. Step1 Register Micrososft.Synapse Resource providers Tópico3 Tópico4 Tópico2
16. Step1 Tópico3 Tópico4 Step 2 Provision your data lake with Hierarchical namespace
17. Step1 Tópico4 Step 3 Create your Azure Synapse workspace using Azure portal
18. Step1 Step 4 Access Azure Synapse Studio web.azuresynapse.net Step 3 Provision your data lake with Hierarchical namespace
19. Questions
20. Links • Synapse Analytics(workspaces): https://docs.microsoft.com/en-us/azure/synapse-analytics/overview-what-is • Synapse Analytics(SQL DW): https://docs.microsoft.com/en-us/azure/synapse-analytics/sql-data-warehouse/ • Modern Data Warehouse: https://azure.microsoft.com/en-in/solutions/architecture/modern-data-warehouse/ • MPP Architecture: https://docs.microsoft.com/en-us/azure/synapse-analytics/sql-data-warehouse/massively-parallel- processing-mpp-architecture • Product: https://azure.microsoft.com/en-us/services/synapse-analytics/ • Synapse Link: https://docs.microsoft.com/en-us/azure/cosmos-db/synapse-link