The ability to replicate data out of an Amazon Redshift Database into SQL Server (or any other target DB). Where we can read the logs of the Amazon Redshift database and mirror those changes into the target DB (SQL).
What is the use case for replication to an on-premise DB?
If you just need to query the data from SQL, polybase can be used and copies of data do not need to be made.