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.

PR: https://github.com/getredash/redash/pull/2038

1 Like