Spotfire: Amazon Redshift Spectrum tables are not visible when connected from Information Designer in TIBCO Spotfire

Add EXTERNAL TABLE to the in the Amazon Redshift template to view Spectrum tables

Details:

When a data source for Amazon Redshift is created in the TIBCO Spotfire Information Designer tool, some of the tables which are external, i.e Spectrum tables, may not be visible in the tree view of the created data source.

In the Amazon Redshift data source template if table types are listed as only TABLE and VIEW as follows:

<table-types>TABLE, VIEW</table-types>

then spectrum tables will not be listed as data resides in S3 buckets which is external to Redshift Data Warehouse. Add 'EXTERNAL TABLE' to the <table-types> in the Amazon Redshift Template in order to view the Spectrum tables in the data source tree view:

<table-types>TABLE, VIEW, EXTERNAL TABLE</table-types>

After changing the data source template, re-save any existing data sources in the Information Designer for the changes to take effect. Any new data sources created will use this template by default.

Reference:

External: Querying External Data Using Amazon Redshift Spectrum

• https://docs.aws.amazon.com/redshift/latest/dg/c-using-spectrum.html

Wiki: Example Templates 

•  https://community.tibco.com/wiki/tibco-spotfire-jdbc-data-access-connectivity-details#toc-12

Doc: Adding a data source template in the configuration tool

• https://docs.tibco.com/pub/spotfire_server/10.3.6/doc/html/TIB_sfire_server_tsas_admin_help/GUID-CC0AF293-611A-4D0E-A437-B52039A3BE44.html