the current design of Spotfire does not provide a way to display tables when working with Amazon Redshift Spectrum

In working with TIBCO:  

We checked with our Engineering team on this use case. During their investigation, our Engineering team found that the current design of Spotfire does not provide a way to display tables when working with Amazon Redshift Spectrum.

 The reason why Spotfire is not able to display the table names from Spectrum is because it can not get column schema from the external system, as the types returned from SVV_EXTERNAL_COLUMNS are the names of the external types, and Spotfire doesn't know what they might be. When evaluating a custom query, on the other hand, the .NET ODBC framework gets the actual types from the result set. This allows Spotfire to map the .NET types to our internal types.

 The workaround suggested by our Engineering team is to read data from these tables through custom queries. Spotfire doesn't list the tables in the "views in connection" dialog, so if one knows the Spectrum schema (lets says schema is "spectrum1") and the table (assuming table name is "table1") then you can query the table as "select * from spectrum1.table1".