Skip to content
Dave Rix
  • Home
  • Projects
  • Blog
  • About
  • Contact

Amazon Athena

Serverless SQL queries over S3 data with Amazon Athena (Trino engine v3).

Amazon Athena SQL Cheat Sheet

2026-06-29 by Dave

A practical Amazon Athena SQL cheat sheet: partition projection, CTAS, JSON, window functions, and the cost and quoting gotchas that bite in Trino engine v3.

Categories Cheat Sheets Tags Amazon Athena, AWS, Cheat Sheet, SQL, Trino Leave a comment
Dave

Dave

Senior AWS Cloud Architect, platform engineer and MySQL/Aurora DBA. 30+ years building production infrastructure, now with AI-assisted engineering in the daily toolkit. Available Outside-IR35 via Analysis by Design Ltd.

Verified Services

View Full Profile →

The articles here are my own thoughts, based on many years of working with a variety of technologies. I'm not saying these are the best ways of doing various tasks, but they work for me.

This is also a good way for me to remember processes that are only done on occasion, but saves having to Google and draw from various sources if they are all here in one place!

Recent Posts

  • Amazon Athena SQL Cheat Sheet 2026-06-29
  • Vibe-coding AnalyseMy.Golf: a series 2026-06-24
  • AI Terminology Demystified: Agents, MCPs, and Skills – How They Fit Together 2026-06-23
  • Adding and extending storage on Linux 2026-06-19
  • Setting up MySQL replication in Docker and Multipass test environments 2026-06-17

Archives

  • June 2026

Categories

  • AI & Agents
  • AWS & Cloud Architecture
  • Cheat Sheets
  • Databases
  • Linux & Automation
  • Projects
Privacy & Cookies: This site uses cookies. By continuing to use this website, you agree to their use.

To find out more, including how to control cookies, see here: Cookie Policy
  • Twitter/X
  • LinkedIn
© 2026 Dave Rix • Built with GeneratePress