Redshift Spectrum Partitioning Underlying S3 Folders to Improve Performance and Reduce Cost

Redshift Spectrum can do partition pruning if you create partitioned tables and you partition the underlying s3 data into folders. Taking advantage of this feature can both reduce cost (by reducing the amount of data that must be scanned), and increase performance (again by scanning less data).

Here is some AWS Redshift documentation on the subject.

https://docs.aws.amazon.com/redshift/latest/dg/c-spectrum-external-tables.html#c-spectrum-external-tables-partitioning

Scroll to Top