How do I view/select/profile external tables in Redshift?

[KKostroski]

Hi, I successfully connected to Redshift using the jdbc driver. However, the external tables are not loading or expandable to view from "Database Objects/external schemas/ba_*". Anyone know of a config that will allow me to select "external tables" in my Redshift connection and profile columns?

When I right click and "add all schema tables to source" I get the error: "Job error status: No source columns in job".

From command prompt:
13:16:00.516 [AWT-EventQueue-0] INFO o.a.m.jdbc.JdbcMetadataLoader - No table metadata records returned for schema 'ba_...'

You can see that you cannot expand ba_* external schemas to view the associated "external tables" and "columns".

This is what I'm trying to select, seen in PyCharm:

[kaspersorensen]

Hi there,

As the log mentions - No table metadata records returned for schema - there is no metadata delivered to DataCleaner to build up the data structure from. So although you made the JDBC driver "work", it still doesn't work, because the JDBC driver doesn't seem to offer any metadata. I don't know anything about RedShift so I can't help you further than that.