You can run something like
select count(key) from <your_table> where key like 'your_prefix%'
Lets say you have 3 objects
select count(key) from <your_table> where key like 'prefix1/prefix2/%'
This would return 2
Check out this blog post for more examples
Query Id: ddfe7caf-be98-4c33-a2f1-b50502a22961asked 7 months ago
Can I use the ID of my saved query to start query execution in Athena SDK?asked 3 months ago
Amazon Athena query outputting all columns in the csv as VARCHARsAccepted Answerasked 2 years ago
S3 Inventory Performance ExpectationsAccepted Answerasked 4 years ago
Aws athena- query both s3 and rdsasked 3 years ago
Athena Query Resultasked 2 months ago
s3 inventory Atena queryasked 21 days ago
Retrieving Athena Query History dataasked 3 years ago
S3 Inventory : Is there a limit to the number of objects in a bucket that will show up in the inventory?Accepted Answerasked 4 years ago
I cannot use current_date + interval in Athena boto3 query in LambdaAccepted Answerasked 6 months ago