Answers: <p>I don't think any database services "internal traffic" is available to AWS services directly.</p>
  
  <p>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.</p>
  
  <p>It then becomes a text processing exercise that you can possibly solve with AWS Athena</p>
  
Answers: CC BY-SA 4.0
Answers: 2019-11-03T00:59:25.853Z
Answers: 2019-11-03T00:59:25.853Z
Answers: jdog
Body: <p>Is it possible to have AWS-RDS (or another aws service) generate a report on databases that haven't been interacted with (write/read) after a certain period of time?</p>
  
  <p>My background is in QA and I'm relatively new to the DevOps game, sorry if this is a basic question, couldn't find it in search.</p>
  
Comments: CC BY-SA 4.0
Comments: 2019-11-03T12:10:42.237Z
Comments: What about checking AWS CloudWatch? If there is no activity then there is no interaction.
Comments: 030
Tags: <databases><amazon-cloudwatch><amazon-rds>
Title: AWS RDS- Determine what Database Tables aren't interacted with?
UserDisplayName: TinCan
ThreadText: # AWS RDS- Determine what Database Tables aren't interacted with?
  
  (Asked by: username_0 on 2019-11-01)
  
  Is it possible to have AWS-RDS (or another aws service) generate a report on databases that haven't been interacted with (write/read) after a certain period of time?
  
  My background is in QA and I'm relatively new to the DevOps game, sorry if this is a basic question, couldn't find it in search.
  
  **Tags:** databases, amazon-cloudwatch, amazon-rds
  
  > **Comments:**
  > **username_1**: What about checking AWS CloudWatch? If there is no activity then there is no interaction.  
  
  ---
  
  ## 1 answers
  
  ### Answer by username_2 on 2019-11-03. Score: 1
  
  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
  
  
  ---
  
  