[Bug]: DuckDB - Explorer shows multiple entries for schemas. Tables and Views not populated in their sections.

[usbrandon]

Apache Hop version?

2.8-SNAPSHOT

Java version?

11

Operating system

Windows

What happened?

Issue Priority

Priority: 3

Issue Component

Component: Database

[sramazzina]

@usbrandon we are going to see three different entries per schema name because we have the same set of schema for every catalog defined in DuckDB. In this case, we have 3 catalogs (because is a brand new DuckDB installation) and each catalog has 3 identically named schemas. THis is the reason why you are seeing 3 entries per schema name.

Therefore, apart from an overall improvement to the Database Explorer dialog, in this case a very quick solution could be to disambiguate the schema name by prepending the catalog name. That could be an easy option to better contextualize the things. Let me know what you thing about this.

@hansva @bamaer

[sramazzina]

@usbrandon @hansva @bamaer something like this?

[sramazzina]

@usbrandon @hansva @bamaer Further refinement...

I think thiw way is quick and cleaner enough. What do you think?

[hansva]

LGTM!