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.
Comments
0 comments
Please sign in to leave a comment.