AWS Athena

Ask about the logs and events in your S3 data lake.

Try Dot with AWS AthenaRead the docs

Dot writes Athena SQL for each question and shows every query.

Threadanalytics

Lisa Park9:41 AM

@Dot Which endpoints returned the most server errors yesterday?

1 reply

DotAPP9:42 AM

7 steps · 44s · Access Online

/checkout/confirm, almost all of them 504 timeouts.

Source: AWS Athena’s alb_logs.

Here is the data.

EndpointServer errorsShare
/checkout/confirm1,24061%
/api/cart31015%
/search1889%

Threadanalytics

David Mensah9:41 AM

@Dot Did any of our refrigerated trucks go above 8°C this week? For how long?

1 reply

DotAPP9:42 AM

4 steps · 30s · Access Online

Yes, 7 of 420 trucks, almost six hours in all.

Source: AWS Athena’s sensor_readings.

Here is the data.

TruckAbove 8°CDay
Truck 883 hTuesday
Truck 21352 minThursday
Truck 4135 minMonday

Threadanalytics

Sarah Chen9:41 AM

@Dot Which help articles do people read right before contacting us?

1 reply

DotAPP9:42 AM

10 steps · 52s · Access Online

‘Reset your password’: 2,300 visits ended in a ticket.

Sources: AWS Athena’s web_events and tickets.

Chart

Connect AWS Athena

  • IAM user with access keys
  • Runs in the workgroup you choose
  • Results saved to your S3 path
  • Tables defined in AWS Glue

More in Databases & spreadsheets

Connect your data.

Start for Free