Accessing Redshift Spectrum Tables in Data Virtuality

AWS Redshift allows you to access S3 files as tables by using the Spectrum feature.

For accessing Spectrum tables in Data Virtuality, edit your Redshift data source and replace the data source parameter

importer.tableTypes="TABLE,VIEW"

with

importer.tableTypes="TABLE,VIEW,EXTERNAL TABLE"

If your Spectrum tables do not show up, please check if your Redshift connection points to the correct schema by reviewing the importer.schemaPattern parameter.