Enhance SQLTables for Redshift ODBC driver to return information about Redshift Spectrum external tables. - DataDirect Connect - Products Enhancements - Progress Community

 DataDirect Connect

Enhance SQLTables for Redshift ODBC driver to return information about Redshift Spectrum external tables.

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.

Status update

 Driver builds 07.16.0178 (B0480, U0335) and 08.00.0256 (B0492, U0342) or higher contain this enhacnement.