DynamoDB Connector

For detailed information about Amazon Athena DynamoDB Connector, refer here.

Install Athena DynamoDB Connector

To install Athena DynamoDB Connector, search for "Serverless Application Repository" in your aws account and click on "Available applications": Make sure "Show apps that create custom IAM roles or resource policies" is marked. Search for "athena federation" and locate "AthenaDynamoDBConnector" and click on that: For this Athena DynamoDB Connector, there are a few fields that we need to complete:

  • Application name: Leave it as default name - AthenaDynamoDBConnector
  • SpillBucket: Put S3Bucket value from the cloudformation outputs here
  • AthenaCatalogName: Put dynamo
  • DisableSpillEncryption: leave it as default value of false
  • LambdaMemory: leave it as default value of 3008
  • LambdaTimeout: leave it as default value of 900
  • SpillPrefix: Put athena-spill-dynamo

  • Mark "I acknowledge that this app creates custom IAM roles" and click deploy: This will deploy Athena DynamoDB connector and you can refer to this lambda function in your queries as "lambda:dynamo"