DataGrip - Athena: cant see all data catalogs except the default AwsDataCatalog


Our Athena account have 2 data catalogs:

  1. AwsDataCatalog - the default one
  2. dlprd

when trying to see or select the dlprd schema, I cant see it on the UI.
I can run query like this:

select * from dlprd.sms.labels

but cant see it.
using the AthenaJDBC41.jar

1 comment

There is a note about that in documentation
To use the JDBC driver for multiple data catalogs with Athena (for example, when using an external Hive metastore or federated queries), include MetadataRetrievalMethod=ProxyAPI in your JDBC connection string.
Appending it helps


Please sign in to leave a comment.