Tables created via Redshift Spectrum are not currently visible via the SQLTables function in the DataDirect Redshift ODBC driver. Redshift Spectrum allows users to query files stored in S3 as if they were regular Redshift tables after they are associated with the CREATE EXTERNAL TABLE command. However, these tables do not appear in the standard system tables, but instead in SVV_EXTERNAL_TABLES and SVV_EXTERNAL_COLUMNS.
Our users would like to see these tables returned in our standard applications, which rely on the result set created from SQLTables for table information. This request is to enhance the Redshift ODBC driver to allow those tables to be discovered via SQLTables.