The Power of Polybase with SQL - True data Virtualisation
summary
PolyBase lets SQL Server query remote stores (Oracle, MongoDB, Teradata, another SQL, S3, Azure Blob, ADLS Gen2) using T-SQL without copying data by creating external tables, or ad-hoc with OPENROWSET. SQL Server 2022 adds a REST API path, pushdown computation to filter and join at source (reducing data movement), Parquet/Delta file support, and a trace flag (66408) to see remote work. Demo builds an external sales table, unions it with local sales, and exposes a view so archive data appears local.
AI-written summary · about
chapters (10)
- 0:00Intro
- 0:23Meet the Speakers
- 2:34Data Virtualisation in SQL Server
- 3:58Data virtualisation using Polybase
- 5:34Data lake virtualization and object storage Query any data lake and backup/restore SQL to object storage
- 8:24Data virtualisation - journey so far SQL Server 2016
- 12:13Pushdown Computation
- 14:34Data Virtualization in SQL Managed Instance
- 16:08Use cases
- 16:59How do I use Polybase? Demo
related talks
21mThe Power of Polybase with SQL - True data Virtualisation
51mData tiering using data Virtualization in SQL- 51mData tiering using data Virtualization in SQL
50mSQL 2022 and S3 – Dell’s overview of consuming object data via Microsoft SQL
51mSQL Server 2022 and the Wheel of Power
49mAnalytics in SQL Server and Azure SQL Database
01h 02mNot your Father's SQL Server: Developer Innovations in Data Storage
52mPower BI + Azure Synapse Analytics. All you need to start creating a unified analytics solution