Amazon Redshift Spectrum allows users to run queries against exabytes of data in S3 without having to duplicate the data into a Redshift cluster, making it cost-effective for sporadic query access.