Reference queries for the Connect Customer data lake

Publisher

Amazon Web Services

URL

https://docs.aws.amazon.com/connect/latest/adminguide/data-lake-reference-queries.html

Published

unknown

Updated

unknown

Accessed

2026-10-02

HTTP status

200

License

AWS documentation; all rights reserved by AWS; no-redistribution; short excerpts and locators only

Source notes citing this source

• The Amazon Connect data lake reference query for Contacts abandoned in X seconds counts contacts with is_abandoned = 1 and queue time at or under X, which is how a short-abandon bucket can be derived since abandonment rate itself has no short-abandon exclusion. in context
• The Amazon Connect data lake reference query defines average handle time as the time from contact connection to ACW completion, averaging handle_time_ms over handled contacts only. in context
• Amazon Connect delivers contact records at least once, so exact counts from the data lake need de-duplication on primary keys. in context
• The Amazon Connect data lake reference query for service level counts contacts that were handled with queue answer time at or under X and divides by all queued contacts, so abandoned contacts sit in the denominator and never in the numerator. in context
• A contact answered exactly at the threshold counts as within service level in the Amazon Connect data lake sample query (<=) but not under the GetMetricData LT comparison, so the two can differ slightly at the boundary. inferred in context
• All Amazon Connect data lake timestamps are UTC and the reference queries bucket contact metrics by disconnect timestamp. in context
• The Amazon Connect data lake reports contacts transferred out of a queue with separate internal and external transferred-out flags. in context

Cite this source record

APA

WarmTransfer. (2026, October 2). Reference queries for the Connect Customer data lake. WarmTransfer. https://warmtransfer.net/knowledge/sources/aws-connect-data-lake-reference-queries

BibTeX

@misc{warmtransfer-aws-connect-data-lake-reference-queries,
  title  = {Reference queries for the Connect Customer data lake},
  author = {{WarmTransfer}},
  year   = {2026},
  url    = {https://warmtransfer.net/knowledge/sources/aws-connect-data-lake-reference-queries},
  note   = {Amazon Web Services, accessed 2026-10-02}
}