Creating Athena Data Source : Table not found, Please make another selection

Question & Answer
,
1

I am trying to create a new data source, but I am getting the following error. (Connection validation is successful and SSL is enabled)

image
image748×613 26.5 KB

I can see the DB but not the tables. My region is “us-east-1” for both quicksight and athena tables. I am assuming a role that has administrator access policy attached and DataLakeAdmin Access (AmazonAthenaFullAccess, AmazonS3FullAccess, AWSGlueSchemaRegistryReadonlyAccess, AWSLakeFormationCrossAccountManager, AWSLakeFormationDataAdmin, CloudWatchLogsReadOnlyAccess) via IAM identity center. I have also given the role grant permissions to database and list all tables via aws LakeFormation.

Please note that I am able to see tables and run queries on Athena Tables via AWS Console successfully.

1 Like
2

Update : Is it necessary for me to Give DB and Tables access to IAMAllowedPrincipals group in AWS Lake Formation ? I seem to figured it out. I just allowed access to IAMAllowedPrincipals group and that resolved my issue.

1 Like