OK, the problem is with how you define the source s3.
The s3 can not be a single file, but a dir.
refer to this doc for using Glue Crawlers: https://docs.aws.amazon.com/glue/latest/dg/crawler-s3-folder-table-partition.html
Can an Glue Crawler use a S3 Lambda Access Point as a data store?asked 3 months ago
How to create simple Athena table from simple JSON data?asked 4 days ago
Include request_datetime from S3 file in Athena table - table made by Glueasked a month ago
AWS Glue crawler creating multiple tablesasked 8 months ago
crawled data can not be queried in athenaAccepted Answerasked 5 years ago
Glue: Using S3 ObjectCreated events with Crawler Catalog Targetasked 6 days ago
Can Glue crawler be configured to include only the most recent partition in a table?asked 4 months ago
Can I use aws glue crawlers to create master data in delta lake tables?asked 4 months ago
Cannot query Athena tables as the Glue crawler generated data having = instead of : in the column valuesasked 2 months ago
Delete partitions in Glue Data Catalog using crawler not working.asked 4 months ago