The Power of Polybase with SQL - True data Virtualisation

on YouTube ↗21m

" summary

PolyBase lets SQL Server query external stores without moving data: uses external tables and OPENROWSET, requires installing PolyBase, and SQL Server 2022 adds REST API for S3/ADLS Gen2 plus Parquet and Delta support. A new optimizer feature, push-down computation, offloads filters/joins to remote sources to cut data movement. Demo creates a credential, external data source and file format, builds an external table, unions it with local table via a view, and the query against the view returns combined results successfully.

AI-written summary · about

" chapters (10)

1. 0:00Intro
2. 0:23Meet the Speakers
3. 2:34Data Virtualisation in SQL Server
4. 3:58Data virtualisation using Polybase
5. 5:34Data lake virtualization and object storage Query any data lake and backup/restore SQL to object storage
6. 8:24Data virtualisation - journey so far SQL Server 2016
7. 12:13Pushdown Computation
8. 14:34Data Virtualization in SQL Managed Instance
9. 16:08Use cases
10. 16:59How do I use Polybase? Demo

" related talks

• 21mThe Power of Polybase with SQL - True data VirtualisationHaider Raza, Manish Kumar · SQLBits 2019
• 51mData tiering using data Virtualization in SQLAjay Jagannathan · SQLBits 2024
• 51mSQL Server 2022 and the Wheel of PowerBob Ward · SQLBits 2023
• 49mAnalytics in SQL Server and Azure SQL Databasechuck heinzelman, Ajay Jagannathan · SQLBits 2023
• 51mThe Microsoft Intelligent Data PlatformBuck Woody · SQLBits 2023
• 52mPower BI + Azure Synapse Analytics. All you need to start creating a unified analytics solutionPawel Potasinski · SQLBits 2023
• 21mReal-Time Connectivity to Snowflake and 100s of Sources from the Power PlatformAshley Brandon, Jerod Johnson, Andre Thompson · Microsoft Build 2023
• 50mOleksandra Bovkun | Data Track | Compass AI & Data Summit 2025Oleksandra Bovkun · Compass AI & Data Summit 2025