CODEWITHSUNDEEP
amazon-s3amazon-dynamodbamazon-athena
auhuman
auhuman

Reputation: 972

Athena Write to DynamoDB

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

Upvotes: 3

Views: 3791

Answers (1)

YinYang16
YinYang16

Reputation: 471

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.

Upvotes: 4

Related Questions