Publish RisingWave Database and Schema along with metrics

[edeesis]

Is your feature request related to a problem? Please describe.

Currently, there's no way to distinguish table metrics in Grafana dashboards if the tables, sources, and sinks share the same name across different schemas or databases. this makes it difficult to track individual database performance

Describe the solution you'd like

Ideally, all metrics would be published tagged with database name and schema name, but if not, then the Actor/Table Id Info table should have this information to refer to

Describe alternatives you've considered

No response

Additional context

No response

[github-actions]

This issue has been open for 60 days with no activity.

If you think it is still relevant today, and needs to be done in the near future, you can comment to update the status, or just manually remove the no-issue-activity label.

You can also confidently close this issue as not planned to keep our backlog clean.
Don't worry if you think the issue is still valuable to continue in the future.
It's searchable and can be reopened when it's time. 😄