Aurora Connector

With Athena Jdbc Connector, the following databases are supported:
  • MySQL
  • PostgreSQL
  • Redshift

  • For detailed information about Amazon Athena Jdbc Connector, refer here.

    Install Athena JDBC connector for Aurora MySQL

    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 "AthenaJdbcConnector" and click on that: For this Athena Jdbc Connector for Aurora MySQL, there are a few fields that we need to complete. You should be able to get details for the fields from the CloudFormation Outputs tab as shown here:
  • Application name: Leave it as default name - AthenaJdbcConnector
  • SecretNamePrefix: Put AthenaJdbcFederation
  • SpillBucket: Put S3Bucket value from the cloudformation outputs here
  • DefaultConnectionString: Put RDSConnectionString value from cloudformation outputs here
  • DisableSpillEncryption: leave it as default value of false
  • LambdaFunctionName: Put mysql
  • LambdaMemory: leave it as default value of 3008
  • LambdaTimeout: leave it as default value of 900
  • SecurityGroupIds: Put WorkshopSecurityGroup value from cloudformation outputs here
  • SpillPrefix: Put athena-spill/jdbc
  • SubnetIds: Put Subnets value from cloudformation outputs here

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