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

Answered
Avatar
Shayruvio
Created

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

Votes

1

Share

1 comment
Avatar
Alexander Kass
Created

There is a note about that in documentation https://docs.aws.amazon.com/athena/latest/ug/connect-with-jdbc.html
```
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

0

Please sign in to leave a comment.