AWS RDS- Determine what Database Tables aren't interacted with?
I don't think any database services "internal traffic" is available to AWS services directly.

That being said, you should be able to dump all sql queries to a log file on S3 and also extract all database/table combinations to a text file as well.

It then becomes a text processing exercise that you can possibly solve with AWS Athena