Athena Data Souce connected through JDBC but no objects found to create base views!

Hi Team, 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. Thank you, Manju
user
12-06-2019 10:21:22 -0400

1 Answer

Hi, The com.denodo.util.jdbc.introspection.allTypes property will allow all JDBC adapters in VDP (including the Presto one) to show structures in the metadata discovery tree during the "create base views" phase. I would recommend you to set this property to true by using the SET ‘com.denodo.util.jdbc.introspection.allTypes’ =’true’ command in the VQL Shell. For more details, you can refer to the knowledge-based article on Athena connection here https://community.denodo.com/kb/view/document/How%20to%20connect%20to%20Amazon%20Athena%20from%20Denodo?category=Data+Sources Hope this helps!
Denodo Team
12-06-2019 17:23:16 -0400
You must sign in to add an answer. If you do not have an account, you can register here