Table creation using Athena and cross account S3 bucket access

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