Amazon S3Amazon Athena directly queries data stored in Amazon S3 using standard SQL, enabling you to analyze large-scale datasets without the need for ETL processes.
AWS GlueAWS Glue provides a data catalog that helps Amazon Athena understand the schema and location of your data, making it easier to run queries and maintain metadata.
Amazon QuickSightAmazon QuickSight integrates with Amazon Athena to visualize data and generate business intelligence insights using the queried data.
Amazon CloudWatchAmazon CloudWatch gathers logs, metrics, and events from Amazon Athena, enabling you to monitor query performance and set alarms for operational issues.
AWS LambdaAWS Lambda can be triggered by the completion of Amazon Athena queries, allowing for automation of functions such as data transformation and notification.
Amazon Data FirehoseAmazon Data Firehose can deliver streaming data directly into Amazon S3, allowing Amazon Athena to query real-time data alongside historical data stored in S3.
AWS Identity and Access Management (IAM)AWS IAM provides fine-grained access control policies for Amazon Athena, enabling secure access to your data and protecting sensitive information.
Amazon RedshiftAmazon Athena provides a built-in data source connector for querying data in Amazon Redshift.
Amazon AppFlowAthena can query Amazon AppFlow output in Amazon S3 using tables that AppFlow automatically registers in the AWS Glue Data Catalog. This lets you analyze transferred SaaS records with SQL without manually defining their table schemas.
Amazon AuroraAthena can query Aurora MySQL and Aurora PostgreSQL databases through federated data source connectors. Queries can join operational records in Aurora with datasets stored in Amazon S3.
Amazon Aurora ServerlessAthena can query compatible Aurora Serverless databases through its MySQL and PostgreSQL federated connectors. The connector must have network access and credentials for the database endpoint.
Amazon CloudFrontAthena can query CloudFront access logs delivered to Amazon S3. For example, SQL queries can identify frequently requested objects, geographic traffic patterns, and elevated error rates.
Amazon DataZone
Athena provides SQL querying for data accessed through Amazon DataZone data lake environments. Project members can query subscribed, Glue-cataloged datasets after the required access permissions are granted.
Amazon DocumentDB (with MongoDB compatibility)Athena's DocumentDB connector supports federated SQL queries against documents in Amazon DocumentDB. You can join document data with tables in Amazon S3 without first copying the entire database.
Amazon DynamoDBAthena's DynamoDB connector exposes DynamoDB tables to federated SQL queries. This supports analysis across DynamoDB tables and joins with other Athena data sources.
Amazon ElastiCacheAthena's Redis connector can query supported Redis data in Amazon ElastiCache. It maps supported Redis structures into tables that can be queried and joined with other Athena datasets.
Amazon EMRAthena integrates with the SQL editor in Amazon EMR Studio, allowing users to author and execute Athena queries from the Studio interface. Athena can also use an external Hive metastore hosted on an EMR cluster through its Hive metastore connector.
Amazon EventBridgeAthena sends query execution state-change events to EventBridge. Rules can react when a query succeeds, fails, or is cancelled, such as by starting a downstream workflow.
Amazon GuardDutyAthena can analyze GuardDuty findings exported to Amazon S3. SQL queries can aggregate findings across accounts or identify recurring activity involving particular resources.
Amazon HealthLakeAthena can query HealthLake data exposed through its AWS Glue and Lake Formation integration. This enables SQL analysis of supported FHIR datastore data using the applicable access controls.
Amazon MacieAthena can query Macie's sensitive data discovery results stored in Amazon S3. These detailed results support analyses such as identifying objects containing particular sensitive data types.
Amazon Managed GrafanaAthena is available as a data source for Amazon Managed Grafana. Dashboards can run Athena SQL queries to visualize datasets in Amazon S3 and other supported Athena sources.
Amazon Managed Streaming for Apache KafkaAthena's Kafka connector can query topics in Amazon MSK clusters. It exposes supported topic data for SQL analysis and joins with other Athena data sources.
Amazon Managed Workflows for Apache Airflow (Amazon MWAA)Athena queries can be orchestrated from Amazon MWAA using the Apache Airflow Amazon provider's Athena operators and sensors. A workflow can submit a query, wait for completion, and then process its results.
Amazon NeptuneAthena's Neptune connector supports federated SQL access to supported graph data in Neptune. This allows graph-derived information to be combined with relational and Amazon S3 datasets.
Amazon OpenSearch ServiceAthena's OpenSearch connector lets SQL queries read data from Amazon OpenSearch Service indexes. Queries can combine indexed documents with tables from other Athena data sources.
Amazon Q
Amazon Q Developer can assist with SQL authoring in Athena, including generating queries from natural-language requests. Users can review and edit the generated SQL before executing it.
Amazon RDSAthena can query supported Amazon RDS database engines through federated connectors, including MySQL, PostgreSQL, Oracle, and SQL Server connectors. This enables SQL joins between database records and data in Amazon S3 without a full database export.
Amazon Route 53Athena can analyze Route 53 Resolver query logs delivered to Amazon S3. Queries can identify frequently requested domains, DNS response codes, and the resources making particular DNS requests.
Amazon S3 GlacierAthena can query restored objects from S3 Glacier Flexible Retrieval and S3 Glacier Deep Archive when the table is configured to read restored Glacier objects. The objects must remain restored while the queries run.
Amazon SageMakerAthena SQL queries can invoke models deployed to SageMaker endpoints for machine learning inference. Athena also queries SageMaker Feature Store offline data, enabling SQL-based feature selection and training dataset preparation.
Amazon SageMaker Data Wrangler
Athena is a supported query source for SageMaker Data Wrangler. You can import the results of an Athena SQL query into a Data Wrangler flow for preparation and feature engineering.
Amazon Security Lake
Athena can query Security Lake's security datasets through their Glue catalog tables and Lake Formation permissions. Analysts can correlate normalized security records across accounts, Regions, and source types.
Amazon TimestreamAthena's Timestream connector supports federated queries against Timestream for LiveAnalytics tables. Time-series measurements can be joined with business or reference data available through Athena.
Amazon VPCAthena can query VPC Flow Logs stored in Amazon S3 to analyze network traffic and rejected connections. Athena also supports VPC interface endpoints for private access to its API.
AWS Application Discovery ServiceAthena can analyze discovery data made available in Amazon S3 through Application Discovery Service's data exploration integration. SQL queries can examine server characteristics, utilization, and network connections for migration planning.
AWS Billing and Cost Management
Athena can query billing datasets delivered to Amazon S3 through AWS Billing and Cost Management exports. This supports custom cost allocation, usage analysis, and reporting across accounts and resource tags.
AWS CloudFormationAthena resources can be provisioned with CloudFormation, including workgroups, data catalogs, named queries, prepared statements, and capacity reservations. Templates can standardize query settings and deploy saved SQL alongside other infrastructure.
AWS CloudTrailAthena can query CloudTrail logs stored in Amazon S3, and CloudTrail provides a workflow for creating an Athena table for a trail's logs. CloudTrail also records Athena API activity for auditing.
AWS ConfigAWS Config can record supported Athena resource configurations and evaluate workgroups with Athena-specific managed rules. For example, it can check whether a workgroup requires encryption for query results.
AWS Cost and Usage ReportAthena can query Cost and Usage Reports delivered to Amazon S3 using the report's Athena integration. SQL queries can break down spending by service, account, usage type, and cost allocation tag.
AWS Data ExchangeAthena can query datasets accessed through AWS Data Exchange for Amazon S3 when the required table metadata and permissions are configured. Subscribers can analyze shared data in place rather than maintaining a separate downloaded copy.
AWS IAM Identity Center (AWS Single Sign-On)Athena supports IAM Identity Center authentication and trusted identity propagation for supported query workflows. Identity Center-enabled workgroups can preserve a user's identity when accessing data governed by Lake Formation.
AWS IoT SiteWiseAthena's AWS IoT SiteWise connector enables SQL queries over supported SiteWise industrial asset data. This allows asset information and measurements to be analyzed alongside datasets from other Athena sources.
AWS Key Management Service (AWS KMS)Athena uses AWS KMS keys to protect supported encrypted source data, query results, and other Athena-managed artifacts. Workgroups can enforce KMS encryption for query results, with key permissions controlling access.
AWS Lake FormationAthena enforces Lake Formation permissions when querying registered data lake tables. Supported permissions can restrict access to databases, tables, columns, and filtered rows.
AWS Network FirewallAthena can query Network Firewall flow and alert logs delivered to Amazon S3. SQL analysis can identify traffic matching firewall rules and investigate network security alerts.
AWS PrivateLinkAthena supports AWS PrivateLink through interface VPC endpoints. Applications can reach supported Athena API operations privately without requiring an internet gateway or NAT device.
AWS Secrets ManagerAthena federated connectors can retrieve database credentials and other connection secrets from Secrets Manager. This keeps credentials out of query text and connector configuration values.
AWS Security Token Service (AWS STS)Athena JDBC and ODBC authentication workflows can use STS temporary credentials, including credentials obtained by assuming an IAM role. This enables federated access without distributing long-lived AWS access keys.
AWS Serverless Application RepositoryAthena's Lambda-based federated connectors are available as applications in the Serverless Application Repository. Deploying a connector application creates the resources Athena uses to query its supported external data source.
AWS Step FunctionsAthena has an optimized Step Functions integration for starting queries, retrieving results, and stopping query execution. A workflow can wait for a query to finish before running dependent processing steps.
AWS Systems ManagerAthena can query Systems Manager Inventory data collected into Amazon S3 through resource data sync. This supports fleet-wide SQL analysis of installed software, operating systems, and other collected inventory attributes.
AWS WAFAthena can query AWS WAF traffic logs stored in Amazon S3. Queries can identify blocked requests, frequently matched rules, and request patterns associated with particular clients.
Elastic Load Balancing (ELB)Athena can query supported Elastic Load Balancing access logs delivered to Amazon S3. For example, queries over Application Load Balancer logs can identify slow requests, target errors, and traffic distribution.