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

book

Article ID: KB0076091

calendar_today

Updated On:

Products	Versions
Spotfire Server	All Versions

Description

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.

Issue/Introduction

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

Resolution

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.