Hi Brett, Am Sonntag, den 23.06.2019, 22:18 +1000 schrieb Brett Ryan: > I’d like to add external table support for amazon redshift using > amazon spectrum tables stored on s3. One easy fix is to add EXTERNAL > TABLE to JDBCSchema which I’ve tested and is working as expected. > > It might be noted that we may want to either > > - have these under a seperate node, though note that system tables > don’t > - have an augmented icon? > > I can provide a PR with the change if we’re happy to just return the > tables which is the same behaviour for system tables.
the proposed change sounds sane. I'm not sure if I understand your options. The system tables can be separatedly displayed. In the properties of the connection there is a boolean option "Show system tables separately". If I remember correctly I implemented it this way to be compatible with the behaviour before the change. In the above mentioned changeset the tables gained a "system" attribute. In review it would have been better to report the jdbc type of the table. If you add EXTERNAL tables, adding SYNONYMS (informix allows mapping tables from foreign DBs into the local namespace) would be a logical next step. It would be great if that could be prepared, if not implemented. Greetings Matthias --------------------------------------------------------------------- To unsubscribe, e-mail: [email protected] For additional commands, e-mail: [email protected] For further information about the NetBeans mailing lists, visit: https://cwiki.apache.org/confluence/display/NETBEANS/Mailing+lists
