To read a OneTable synced target table (regardless of the table format) in Amazon Athena, you can create the table either by:

• Using a DDL statement as mentioned in the following AWS docs:
  • Example for Hudi
  • Example for Delta Lake
  • Example for Iceberg
• Or maintain the tables in Glue Data Catalog

For an end to end tutorial that walks through S3, Glue Data Catalog and Athena to query a OneTable synced table, you can refer to the OneTable Glue Data Catalog Guide.