Common Room supports importing data from Amazon Redshift via S3. Importing data from Redshift may be suitable for you if you're interested in setting up a recurring import of data from Redshift into Common Room.
Setup
Load data from Redshift into S3. Instructions from Amazon can be found here.