Fetching data from SAP Datasphere to Redshift

How much data are we talking about? I would suggest you visit the AWS pricing calculator (https://calculator.aws/#/createCalculator/S3) and determine with a few keystrokes just how much it will cost you to use S3 as a landing zone (spoiler alert: S3 Standard storage costs about $25 per TB per month), after which loading the data from S3 to redshift in the same AWS region incurs no data transfer charges. S3 can serve as your landing zone today, but can eventually become your historical data lake and single source of truth that powers your data projects of the future.