Query Iceberg Tables already present in Glue

First off, I'd like to let you know that Athena only supports Iceberg tables built against the AWS Glue catalogue using the specifications established by the open source glue catalogue implementation. Additionally, in the TBL PROPERTIES clause, you must specify the 'table type' table property to 'ICEBERG' in order to construct an Iceberg table from Athena [1] : -

" CREATE TABLE [db_name.]table_name (col_name data_type [COMMENT col_comment] [, ...] ) [PARTITIONED BY (col_name | transform, ... )] LOCATION 's3://DOC-EXAMPLE-BUCKET/your-folder/' TBLPROPERTIES ( 'table_type' ='ICEBERG' [, property_name=property_value] ) "

In relation to using Apache Iceberg with Athena, I would also advise you to read over the many considerations and restrictions listed in the document found here [2].

Incase if you still face the issue , there can other backend issue which can only be seen through backend tool. So, I would request you to raise a case to Premium support regarding the same from the concerned account.

References :-

[1]: Creating Iceberg tables - https://docs.aws.amazon.com/athena/latest/ug/querying-iceberg-creating-tables.html

[2]: Considerations and limitations with using Iceberg tables with Athena - https://docs.aws.amazon.com/athena/latest/ug/querying-iceberg.html#querying-iceberg-considerations-and-limitations