Amazon connect - Schedule contact search report to S3 daily

Here are some options for your consideration:

1. AWS Lambda and Amazon EventBridge

   • Create a Lambda function to generate the report and upload to S3
   • Use EventBridge to schedule the Lambda function to run daily

2. AWS Glue

   • Use Glue crawler to extract report data
   • Create a Glue job to transform and load data into S3
   • Schedule the Glue job to run daily using Glue triggers or EventBridge

3. AWS Step Functions

   • Create a Step Functions state machine to extract report and upload to S3
   • Use EventBridge to schedule the state machine execution daily

In terms of cost, the most expensive solution is likely to be AWS Glue, as it involves both data extraction and transformation, which can consume significant resources. The least expensive solution is likely to be AWS Lambda and Amazon EventBridge, as Lambda functions are billed based on the actual time and resources consumed, which can be minimal for a simple report generation task.

Leverage Connect API for extraction: https://docs.aws.amazon.com/connect/latest/APIReference/API_GetCurrentUserData.html and use one of above methods.

If list is not huge, go for eventbridge + lambda, by far the cheapest non streaming option