Analyzing Data

Getting answers out: Athena over the lake and what makes a query cheap or ruinous, Redshift Spectrum and the federated query story, materialised views and result caching, OpenSearch for search and log analytics, and QuickSight as the consumer whose needs shape everything upstream.

Content current as of 2026-10.

Lessons

  1. Athena: cost is a function of bytes scanned
  2. Redshift query patterns and Spectrum
  3. Materialised views and caching
  4. OpenSearch for search and logs
  5. QuickSight and the consumer end

Sources