Amazon Athena
User Guide

AWS Service Integrations with Athena

You can query data from other AWS services in Athena. Athena leverages several AWS services. For more information, see the following table.

Note

To see the list of supported regions for each service, see Regions and Endpoints in the Amazon Web Services General Reference.

Topics

    AWS Service Topic Description
    AWS CloudTrail Querying AWS CloudTrail Logs

    Using Athena with CloudTrail logs is a powerful way to enhance your analysis of AWS service activity. For example, you can use queries to identify trends and further isolate activity by attribute, such as source IP address or user.

    You can automatically create tables for querying logs directly from the CloudTrail console, and use those tables to run queries in Athena. For more information, seeCreating a Table for CloudTrail Logs in the CloudTrail Console.

    Amazon CloudFront Querying Amazon CloudFront Logs Use Athena to query Amazon CloudFront.
    Elastic Load Balancing

    Querying Application Load Balancer logs allows you to see the source of traffic, latency, and bytes transferred to and from Elastic Load Balancing instances and backend applications. See Creating the Table for ALB Logs

    Query Classic Load Balancer logs to analyze and understand traffic patterns to and from Elastic Load Balancing instances and backend applications. You can see the source of traffic, latency, and bytes transferred. See Creating the Table for ELB Logs.

    Amazon Virtual Private Cloud Querying Amazon VPC Flow Logs Amazon Virtual Private Cloud flow logs capture information about the IP traffic going to and from network interfaces in a VPC. Query the logs in Athena to investigate network traffic patterns and identify threats and risks across your Amazon VPC network.
    AWS CloudFormation AWS::Athena::NamedQuery in the AWS CloudFormation User Guide.

    Create named queries with AWS CloudFormation and run them in Athena. Named queries allow you to map a query name to a query and then call the query multiple times referencing it by its name. For information, see CreateNamedQuery in the Amazon Athena API Reference, and AWS::Athena::NamedQuery in the AWS CloudFormation User Guide.

    AWS Glue Data Catalog Integration with AWS Glue

    Athena integrates with the AWS Glue Data Catalog, which offers a persistent metadata store for your data in Amazon S3. This allows you to create tables and query data in Athena based on a central metadata store available throughout your AWS account and integrated with the ETL and data discovery features of AWS Glue. For more information, see Integration with AWS Glue and What is AWS Glue in the AWS Glue Developer Guide.

    Amazon QuickSight Connecting to Amazon Athena with ODBC and JDBC Drivers

    Athena integrates with Amazon QuickSight for easy data visualization. You can use Athena to generate reports or to explore data with business intelligence tools or SQL clients connected with a JDBC or an ODBC driver. For more information, see What is Amazon QuickSight in the Amazon QuickSight User Guide and Connecting to Amazon Athena with ODBC and JDBC Drivers.

    IAM Actions for Amazon Athena You can use Athena API actions in IAM permission policies. See Actions for Amazon Athena and Access Control Policies.