I am logging a certain set of session information about the skill in the CloudWatch logs.
I want to extract this textual information from CloudWatch logs into structured information per session preferably into RDS database. Is there any easy way to perform this.
Currently best way I can think of is:
1. Extract the logs into S3 buckets.
2. Through Python module of EC2 instances read the text information from S3 buckets to populate schema objects in RDS.
My question is that, is there better ways to obtain data from cloud watch to EC2 or any specific database directly. The final objective is to extract information from unstructured textual data from cloudwatch files to some relational database.