I just created a feature request for this but I thought I'd make it visible for community to see in the forum too. The feature request is: https://support.aginity.com/hc/en-us/request/19456
Redshift recently added support for querying external tables in AWS S3 as described by an external "Hive like" catalog that is serviced either by the AWS Athena Data Catalog Service (based on the Hive Metastore Service) or an actual Hive Metastore Service, like on an AWS EMR cluster.
When declaring an external schema in Redshift, the schema itself does not show up and the external tables in the schema are not showing up in the Aginity Workbench "Object Browser" tree control.
I suspect Aginity Workbench does not yet know how to query the contents of the Redshift external catalog to see the external tables.
Currently the only way to view the external schemata and tables are to run queries against the new Redshift catalog tables and views, or to query the SQL-92 compliant information_schema views.
Please sign in to leave a comment.