DynamoDB data crawled using glue not showing in the AWSDataCatalogue under Athena

0

I have crawled the schema of my DynamoDB table using AWS Glue crawler and the table is now shown under the tables section in AWS Glue. However, the table is not being shown under Athena database section although Glue crawler successfully crawled and added the DynamoDB table to the database. Please help me load the data to Athena.

1개 답변
0

To load the DynamoDB table data into Athena:

  • Ensure the Glue crawler successfully crawled the DynamoDB table and added it to the Glue database with the correct schema.
  • Check that the Glue table properties include
  •    classification: dynamodb
    
  • which indicates to Athena this table contains supplemental metadata.
  • If the DynamoDB table or attribute names contain capital letters, edit the Glue table properties to map these to lowercase names which Athena supports.
  • Refresh the Athena database to sync with any changes from Glue.
  • Within Athena, select the database containing the DynamoDB table. The table should now be visible for querying.
profile picture
전문가
답변함 3달 전
  • Are you sure this works?, my understanding is that the way Glue DynamoDB tables and the Athena DynamoDB connector are different and incompatible

로그인하지 않았습니다. 로그인해야 답변을 게시할 수 있습니다.

좋은 답변은 질문에 명확하게 답하고 건설적인 피드백을 제공하며 질문자의 전문적인 성장을 장려합니다.

질문 답변하기에 대한 가이드라인

관련 콘텐츠