Maintained with ☕️ by
IcePanel logo

Amazon Athena announces cross-account federated query

Share

Services

If you have data in sources other than [Amazon S3](/s3/), you can use [Amazon Athena](/athena/) [federated query](https://docs.aws.amazon.com/athena/latest/ug/connect-to-a-data-source.html) to analyze the data in-place or build pipelines that extract and store data in Amazon S3\. Until today, querying this data required the data source and its connector to use the same AWS account as the user querying the data. Athena now supports cross-account federated query to enable teams of analysts, data scientists, and data engineers to query data stored in other AWS accounts. Enabling cross-account federated query is simple with [Athena’s upgraded console](https://docs.aws.amazon.com/athena/latest/ug/release-note-2021-09-15.html). Using an AWS account with administrator privileges, deploy and configure one of [Athena’s pre-built connectors](https://docs.aws.amazon.com/athena/latest/ug/athena-prebuilt-data-connectors.html), or a custom connector developed with [Athena’s connector SDK](https://github.com/awslabs/aws-athena-query-federation), by selecting **Data sources** from the Athena console and then choosing **Connect data source**. Once the connector is [configured for cross-account access](https://docs.aws.amazon.com/athena/latest/ug/xacct-fed-query-enable.html), navigate to the Athena console from your AWS account and select **Data sources** followed by **Custom or shared connector** to add the connector as a new data source. You can now query the data using the Athena console, compatible SQL clients, business intelligence applications, and AWS SDK. To learn more about querying federated sources see [Using Amazon Athena Federated Query](https://docs.aws.amazon.com/athena/latest/ug/connect-to-a-data-source.html) and [Writing Federated Queries](https://docs.aws.amazon.com/athena/latest/ug/writing-federated-queries.html). There are no new charges for querying connectors in another account, but Athena’s standard rates for data scanned, Lambda usage, and other services apply. For more information on Athena pricing, visit the [pricing page](/athena/pricing/).