I am using Athena Federated Query, with a connection to Amazon RDS. When setting up the connection, in the section for the lambda function for JdbcConnectorConfig, DefaultConnectionString I use:
postgres://jdbc:postgresql://xxxxx.xxxxxxx.ap-southeast-2.rds.amazonaws.com:5432/postgres?user=myUser&password=myPassword
This works well, However I notice in Athena that when I use this connection I get 2 databases:
- pg_catalog: is empty
- public: where the desire tables are
Do i need to amend this connection string and how? in order to have only the tables within public been display. I have review the following documentation: PostgreSQL JDBC Driver
I tried unsuccessfully, and following similar question in stackoverflow (Similar question)
postgres://jdbc:postgresql://xxxxx.xxxxxxx.ap-southeast-2.rds.amazonaws.com:5432/postgres?user=myUser&password=myPassword¤tSchema=public
and also
postgres://jdbc:postgresql://xxxxx.xxxxxxx.ap-southeast-2.rds.amazonaws.com:5432/postgres?user=myUser&password=myPassword&searchpath=public
and also
postgres://jdbc:postgresql://xxxxx.xxxxxxx.ap-southeast-2.rds.amazonaws.com:5432/postgres?user=myUser&password=myPassword&options=--search_path=public
