Querying the Database in AWS
This document describes how to run queries against the Aurora database in AWS environments (staging, production).
AWS Aurora and RDS Query Editor
- Log in to our AWS account for (prod or staging) e.g revenue-conversion-xxx
- Go to Secrets Manager and search for
acquisition_registration_aurora_credentials - Copy the Secret ARN
- Search for Aurora and RDS
- Click on Aurora and RDS
- Click on Query Editor
- Select an Aurora database instance
- Under Database username, choose Connect with a Secrets Manager ARN
- Paste the ARN copied in step 3
- Enter the database name:
acquisition_registration_db - Click Connect and run your queries