Partition Pruning
Use partition values to exclude locations, distinguish pruning from row filtering, and avoid changing the answer just to reduce scanning.
-
-
External Tables and the Lake/Warehouse Boundary
An external table exposes files to SQL. Learn when to load a managed copy and how registration, updates, and snapshots affect correctness.