Optimizations you can make today to power data-intensive apps from your data warehouse
Matan Sarig explores some of the traditional techniques, like indexing, as well as modern techniques that make your queries go from fast to fastest in the cloud.
00:00--What is a data app 07:41--Improve data pruning using clustered indexes 13:09--Eliminate JOIN using arrays 20:50--Accelerate UPSERT using PARTITIONS 28:23--Schema evolution using JSON and LAMBDA