Cross account access from Athena to S3

With Lake formation, it is super easy to granting/manage centralize access to various AWS services which include Athena, RS-S, EMR, etc.

In order to build cross account Data Lake -

1. Grant access to your cross account bucket by following below doc

   https://docs.aws.amazon.com/lake-formation/latest/dg/register-cross-account.html

2. Register your bucket in Lake formation

3. Create database

4. Grant access to registered bucket and database

5. Crawl you registered bucket

6. Start granting access to different Personas

https://docs.aws.amazon.com/lake-formation/latest/dg/permissions-reference.html

You can follow below doc to learn how to build it.

https://aws.amazon.com/blogs/big-data/access-and-manage-data-from-multiple-accounts-from-a-central-aws-lake-formation-account/