DataGrip - Athena: cant see all data catalogs except the default AwsDataCatalog Follow
Our Athena account have 2 data catalogs:
- AwsDataCatalog - the default one
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
Please sign in to leave a comment.
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=ProxyAPIin your JDBC connection string.
Appending it helps