I have been playing with Amazon Redshift Spectrum and noticed that all external tables are listed in svv_tables and svv_columns. Redash currently uses Postgres’ information_schema.columns and pg_class for getting tables and views for Redshift. svv_columns provides both internal (local) & external tables and views.
Any help in testing and code reviewing would be appreciated.