Readers cannot see "Last refreshed" timestamp for dashboard datasets

Q&A
, ,
1

image
As seen in the screenshot above, all of my users are unable to see the last refresh date of SPICE datasets on any dashboard.

I’m using Enterprise Edition and my users are all QUICKSIGHT users with the role READER.

I’ve tried using an IAM Policy Assignment to specifically give the List* and Describe* permissions for Datasets, Data Sources, and Ingestions, but to no avail. I’ll include the policy I tried below.

Is there any way around this issue?

IAM Policy tested:

{
    "Version": "2012-10-17",
    "Statement": [
        {
            "Sid": "VisualEditor0",
            "Effect": "Allow",
            "Action": [
                "quicksight:DescribeIngestion",
                "quicksight:DescribeDataSet",
                "quicksight:DescribeDataSource"
            ],
            "Resource": [
                "arn:aws:quicksight:*:984145667453:dataset/*/ingestion/*",
                "arn:aws:quicksight:*:984145667453:dataset/*"
            ]
        },
        {
            "Sid": "VisualEditor1",
            "Effect": "Allow",
            "Action": [
                "quicksight:ListDataSources",
                "quicksight:ListDataSets",
                "quicksight:ListIngestions"
            ],
            "Resource": "*"
        }
    ]
}
2
  1. Reader can’t see datasets.
  2. For “info unavailable”, only owner/co-owner of the dataset can see these information of datasets.
  3. If you are using custom SQL to build the dataset, You can add one more column in the dataset said get_date() as last_refresh_datetime. And then display this column in dashboard based on this dataset.
1 Like