Athena Write to DynamoDB

Question

What are my options to programmatically run a SQL query on Athena and store the result set in DynamoDB as items or views.

I am looking for a built-in AWS Athena function/API which takes a Query as input and outputs the result set into DynamoDB.

Today Athena API can run given query and store the result set to S3. I am looking for Athena to DynamoDB API

Answer 1

There is no built-in AWS functionality that allows you to get data from Athena to DynamoDB directly.

What you can do instead is to have AWS Data Pipeline running Python script that uses boto3 package to connect to Athena, get the data - and maybe do some pre-processing - and then post it to DynamoDB.