Our use-case is probably a little different, but I've found CloudWatch logs too clunky to be useful. Instead we send logs to Papertrail and then use their S3 integration to automatically archive them. It was relatively straightforward to set up Athena on top of that.
We haven't needed the logs in the warehouse, but if we did we could just use an S3 tap or perhaps an Athena tap