I have connected to Athena-AWS datasource thorugh JDBC using presto adapter. Connection is successful and I am able to see the datbase and schemas under it. But for my bad luck, I am not able to see any tables under the schema were I am supposed to see table. Souce team confirmed that, with the user that I connected, they have tested and they are able to see/execute the tables within Athena. But Athena ueses external tables from S3 bucket or datlake.
Is there any settings change that I have to do in Denodo to make it work? Waiting for a reply at the earliest.