Foreign catalogs aren't populated.

liefeld — Tue, 16 Jan 2024 10:37:31 GMT

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 ?

topic Foreign catalogs aren't populated. in Get Started Discussions

Foreign catalogs aren't populated.