data-engineer video for an IT company has built a custom data warehousing solution for a retail organization by using Amazon Redshift. As part of the cost
An IT company has built a custom data warehousing solution for a retail organization by using Amazon Redshift. As part of the cost optimizations, the company wants to move any historical data (any data older than a year) into Amazon S3, as the daily analytical reports consume data for just the last year. However, the analysts want to retain the ability to cross-reference this historical data along with the daily reports. The company wants to develop a solution with the LEAST amount of effort and MINIMUM cost. Which option would you recommend to facilitate this use-case?