Add support for `RedshiftCache` backend

[aaronsteers]

A few users have requested Redshift as a cache backend and/or as a readable destination option.

I'm logging this issue for tracking purposes, and adding the labels accepting pull requests and good first issue.