How do you authenticate to AWS? ie - are you already authenticated to your AWS via cli? If so you can run startquery and getquery.
https://docs.aws.amazon.com/cli/latest/reference/logs/start-query.html
if not - it's probably easiest to back these up to an s3 and then query via athena.
to be clear - this involves a solid amount of AWS and Alteryx know how. You can't just drop a connect in-db, run a query and be done.