Dataset TABLE_NOT_FOUND even with permissions and athena containing the data

Question & Answer
, ,
1

I’m facing the following error in this dataset:

image
image2672×734 75.8 KB

I’ve tried to check in Athena to see if I have some errors, however, it’s working normally
image
image1336×1494 55 KB

I’ve found some topics related to the permissions, however, mine seems ok.
My QS Role:

{
    "Version": "2012-10-17",
    "Statement": [
        {
            "Sid": "VisualEditor0",
            "Effect": "Allow",
            "Action": [
                "s3:*",
                "quicksight:*",
                "athena:*",
                "glue:*",
                "rds:DescribeDBInstances",
                "rds:DescribeDBProxies",
                "rds:DescribeDBProxyEndpoints",
                "rds:DescribeAccountAttributes",
                "rds:DescribeCertificates",
                "rds:DescribeDBClusterEndpoints",
                "rds:DescribeDBClusterParameterGroups",
                "rds:DescribeDBClusterParameters",
                "rds:DescribeDBClusters",
                "rds:DescribeDBEngineVersions",
                "rds:DescribeDBParameterGroups",
                "rds:DescribeDBParameters",
                "rds:DescribeDBProxyTargetGroups",
                "rds:DescribeDBProxyTargets",
                "rds:DescribeDBSecurityGroups",
                "rds:DescribeDBShardGroups",
                "rds:DescribeDBSubnetGroups",
                "rds:DescribeEngineDefaultClusterParameters",
                "rds:DescribeEngineDefaultParameters",
                "rds:DescribeEventCategories",
                "rds:DescribeEvents",
                "rds:DescribeEventSubscriptions",
                "rds:DescribeGlobalClusters",
                "rds:DescribeIntegrations",
                "rds:DescribeOptionGroupOptions",
                "rds:DescribeOptionGroups",
                "rds:DescribeOrderableDBInstanceOptions",
                "rds:DescribePendingMaintenanceActions",
                "rds:DescribeReservedDBInstances",
                "rds:DescribeReservedDBInstancesOfferings",
                "rds:DescribeSourceRegions",
                "rds:DescribeTenantDatabases",
                "rds:DescribeValidDBInstanceModifications",
                "rds:DescribeRecommendationGroups",
                "rds:DescribeRecommendations",
                "rds:DownloadCompleteDBLogFile",
                "rds:DownloadDBLogFilePortion",
                "rds:ListTagsForResource"
            ],
            "Resource": "*"
        }
    ]
}

Any ideas?

2

Hello @wakeupmh !

I think this could be that when you created your Athena connection in QuickSight you may have selected the wrong database. I would double check that your table is available in the database that you chose.

image
image585×480 17 KB

1 Like
3

Hey @wakeupmh !

Were you able to look into what I mentioned above?

1 Like
4

In fact, the error was where I was creating the glue schema in fact, when I adjusted passing explicitly the columns everything worked, thanks a lot

1 Like
5

Hey @wakeupmh

Thank you for following up with how were able to get this solved, this is good to know!