Azure Synapse Analytics
summary
Azure Synapse Analytics shows an integrated workspace tying data lake Gen2 files, provisioned SQL pools and Apache Spark so you can right‑click a Parquet file, run serverless SQL on‑demand via OPENROWSET with automatic schema and preview rows, or launch a Spark notebook. COPY INTO moves billions of rows quickly into distributed tables, materialized views plus result caching deliver millisecond answers, workload classes throttle heavy queries, and snapshot restores complete in minutes for disaster recovery.
AI-written summary · about
chapters (28)
- 0:00Start
- 5:17Sql on Demand
- 5:51Apache Spark
- 7:02Sql on Demand Pools
- 7:53Features of Serverless
- 14:47Demo
- 15:11Set Up Sql Pools
- 16:04Auto Costs
- 16:43Sql Pools
- 17:00Endpoints
- 17:30Launch Synapse Studio
- 17:54Copy Data Wizard
- 19:13Mapping Data Flow
- 19:57Visual Builder
- 23:15Create a New Notebook
- 24:07Workspace
- 24:40Save Scripts
- 27:24Spark Notebooks
- 28:23Power Bi
- 31:52Monitor Tab
- 32:58Key Features
- 33:58Database Views
- 36:18Caching
- 37:03Resource Classes
- 38:17Workload Management
- 39:52Workload Isolation
- 42:55Advisor Recommendations
- 44:33Snapshots and Restores
related talks
58mAzure Data Lake & Synapse Server less Architecture
50mPower BI + Azure Synapse Analytics: Beginning your journey
51mSupercharge Power BI with Azure Synapse Analytics
46mThe Ultimate Jigsaw - Architecting Azure Synapse Analytics
52mConnect your data artifacts with Azure Synapse Analytics and Azure Purview
55mAzure SQL database, Azure Synapse Analytics, Azure Databricks?
43mAnalyzing Big Data in Azure cloud using Spark and Databricks
40mData Lake House in the Cloud: The Azure Solutions