I've created connections to various RDS Aurora databases but always get the same problem - when creating a foreign catalog only the information_schema database is shown in Catalog Explorer.
The AI chat agent has made a few ways to specify the database using CREATE FOREIGN CATALOG or CREATE CONNECTION but none work, eg:
CREATE OR REPLACE FOREIGN DATA SOURCE my_db USING mysql OPTIONS
( host "mysql.server.com", port "3306", database "my_db", USER "my_user", password "my_password" ) ;
Any ideas ?
