Using pre-built Connectors
As part of our first hands-on experience with Athena Query Federation, we'll deploy and query one of Athena's 14+ pre-built Connectors. The Athena team has published these Connectors to the Athena Query Federation GitHub repository (https://bit.ly/3vXmm9j) and the AWS Serverless Application Repository. The AWS Serverless Application Repository offers a one-click experience for deploying Lambda-based serverless applications. This section will show you how to use the AWS Serverless Application Repository to search for and deploy an instance of the Athena CMDB Connector.
The Athena CMDB Connector allows you to query various AWS resources using standard Athena SQL. For example, you can SELECT
all EC2 instances in a specific VPC or search for all S3 objects greater than a particular size and residing in the most expensive storage tier. At the time of writing, the Connector exposes the following AWS services and resources as databases and tables,...