I have a scenario in which I have a rootSchema that holds multiple datasource schemas There's a tool I'd like to integrate it with, but it can't handle (catalog -> schema -> schema) structure
I figured an easy way around this would be to iterate the names of the datasource schemas, and then and then make a clone of the current CalciteConnection with the defaultSchema set to <db name> I can't seem to figure out how to do this, though. Calling .setSchema() doesn't seem to work (probably no impact on the JDBC metadata) and if I create a new connection with the "schema" property set, then it's a fresh/empty Calcite source. Is there any way to do this? Or some craft hack? Thank you =)
