Can a cross account Lake Formation resource be used in QuickSight

Posting a Customer question along with answer to it.

Can a cross account Lake Formation resource be used in QuickSight?
(Facing issues in trying to set permissions in Lake Formation)

Yes. Cross account database and table resource links in Lake Formation can be used in QuickSight via Athena connector.

Ensure the following permissions are configured in Lake Formation (in account where resource links have been created.)

  1. Grant describe (permission + grantable) on the resource link to QuickSight user/group arn.
    Ensure that you are using QuickSight arn and not iam arn.

  2. Grant on target on the resource link with select (permission + grantable) for QuickSight user/group arn. (Selecting all tables option is causing error in LF; Selecting needed tables explicitly works.)

Cross check the following in source account’s Lake Formation.

  1. Ensure that the s3 bucket is registered as a data location in Lake Formation.
    (Usually will already be done; Cross check for public buckets as they would work from Athena even without this, but will work from QuickSight only if explicitly registered in Lake Formation)

Regards,
Arun Santhosh

1 Like