0
votes

I am new to AWS Athena and I'm having trouble with it. Basically, I have a dynamodb table that I'd like to be queryable. I created an AWS Glue crawler for this purpose. It seems that it should show up in Athena automatically, but it isn't. Do I have to create a Glue Job to manually dump the data into an S3 bucket and then configure Athena to use that bucket? I feel like there should be a way for me to skip all of that and just configure Athena to listen/check the crawler?

Thanks Hassan

1
Can you see the table in gluw catalog?Shubham Jain

1 Answers

1
votes

You need to crawl data in Dyanamo db using Glue Crawler. Then create an Glue job to store the data in S3 bucket to query with Athena. Check this link for more details: https://aws.amazon.com/blogs/database/simplify-amazon-dynamodb-data-extraction-and-analysis-by-using-aws-glue-and-amazon-athena/