Regarding the Athena documentation, we cas use the Avro SerDe to query Avro files, which work for me ( CREATE EXTERNAL TABLE).
But regarding their documentation, Athena does only support Parquet and ORC format when dealing with snappy compression.. I don't understand, why should it be a dependency between the format and the compression for Athena
Is snappy compressed Avro files are not queryable by Athena , or this is just something not defined in their doc ?
I tested it and it does work fine. You can query s3 snappy compressed avro files with Athena