I have a bucket 'X' in account 'A', I want to create a copy of the bucket in account 'B' using Athena. I already have a mapping defined in Athena of account 'B' where I can already access another bucket 'Y' of account 'A'.
Now, when I'm using the query editor and running a new query ( where I have specified the location of the buckets of account 'A' & 'B') I'm getting errors and the table isn't getting created.
Also, is there any other way in which I can do this?
Errors: FAILED: IllegalStateException Unxpected Exception thrown: Unable to fetch table fifadatacompare. Insufficient Lake Formation permission(s) on fifadatacompare (Service: AmazonDataCatalog; Status Code: 400; Error Code: AccessDeniedException