Starrocks external catalog schema metadata in Metabase UI

[williamho123]

Hello! I have deployed a shared-data Starrocks cluster, created an external Hive catalog (AWS Glue), and am linking it with Metabase (BI tool). My understanding is that I can use the MySQL connection to link Metabase with Starrocks. When I setup the connection, I setup the database to be like <catalog_name>.<db_name>. With this, I can run queries perfectly in a raw Metabase SQL editor.

However, I would like Metabase to be able to display the tables in the database using the visual editor — currently, it shows a blank page like this:

• I’m not sure if there’s something I am missing for this to happen?
• Does it have to do with where the schema metadata is stored by Starrocks and where MySQL clients try to retrieve that information?

My guess is BI tools like Metabase query the information_schema database to get the metadata about db's and tables, and external catalog metadata is not stored there currently.

[imay]

https://github.com/StarRocks/starrocks/pull/27359 This has been fixed in the main branch, and will be released in version 3.2

[github-actions[bot]]

We have marked this issue as stale because it has been inactive for 6 months. If this issue is still relevant, removing the stale label or adding a comment will keep it active. Otherwise, we'll close it in 10 days to keep the issue queue tidy. Thank you for your contribution to StarRocks!