Connect to Multiple Databases from MariaDb/MySQL connection

Hello Team,

I am using Enterprise Edition. I have multiple databases in my MariaDB connection. However, at the metadata level, I am able to see only 1 database. I want to use tables from multiple databases. How do I do it?

Thank You

1 Like

Hello Navi,

At the metadata level, you can view only the database that you have mentioned while establishing the database connection.

However, you can still use the tables from other databases using the Views section of metadata. You can create a view at the metadata level in which you can use the table by using statements in the following format:
select ‘dbname’.‘tablename’ from 'dbname’

Thank You
From Team Helical