Compare S3 Select and Athena.

Both S3 Select and Athena can be used to run ad hoc SQL-like queries on S3 data. However:

  • Athena requires you to create a table schema and crawl files before you can query the data.
  • S3 Select can only run queries on a single file (like a really large CSV).