Theme ARN not specified in dashboard description

Question & Answer
,
1

Hello,

I have a number of dashboards that include some visuals. I describe all of them to get the Theme ARN in order to update dashboards in other region. One of the dashboards does not contain this Theme ARN inside its description and I cannot find why. It only contains a tabular visual but still shouldn’t it provide me with the Theme ARN? Its description is as follows:

{
    "Status": 200,
    "Dashboard": {
        "DashboardId": "a09b933d-2cdf-40a2-887b-0cabd11074fd",
        "Arn": "arn:aws:quicksight:us-east-1:974477465398:dashboard/a09b933d-2cdf-40a2-887b-0cabd11074fd",
        "Name": "Dispatch Reports STAGE",
        "Version": {
            "CreatedTime": "2024-04-24T10:16:14.778000+03:00",
            "Errors": [],
            "VersionNumber": 1,
            "Status": "CREATION_SUCCESSFUL",
            "SourceEntityArn": "arn:aws:quicksight:us-east-1:974477465398:analysis/1c21322a-99f2-41d2-8063-d7151150047a",
            "DataSetArns": [
                "arn:aws:quicksight:us-east-1:974477465398:dataset/a6843d1c-8933-4e7d-ac49-4f399e57544a"
            ],
            "Sheets": [
                {
                    "SheetId": "a09b933d-2cdf-40a2-887b-0cabd11074fd_bc26cd18-8094-42a4-b68d-7024a693bf5e",
                    "Name": "FRAT Report"
                }
            ]
        },
        "CreatedTime": "2024-04-24T10:16:14.784000+03:00",
        "LastPublishedTime": "2024-04-24T10:16:14.784000+03:00",
        "LastUpdatedTime": "2024-04-24T10:16:14.778000+03:00"
    },
    "RequestId": "4cea5647-b8ac-45e5-b2ba-67c81fa6d9c0"
}
2

Hi @Fotis_flex - Did you use describe_dashboard_definition for extracting the details. It should contain the theme arn in the response json. Please see the documentation below.

https://boto3.amazonaws.com/v1/documentation/api/latest/reference/services/quicksight/client/describe_dashboard_definition.html

Regards - Sanjeeb

3

@Sanjeeb2022 I initially used the describe_dashboard plain. Now I tried with describe_dashboard_definition and I still don’t get the Theme ARN. Strange, I get it for the other dashboards. Any ideas?

{
    "Status": 200,
    "DashboardId": "a09b933d-2cdf-40a2-887b-0cabd11074fd",
    "Name": "Dispatch Reports STAGE",
    "ResourceStatus": "CREATION_SUCCESSFUL",
    "Definition": {
        "DataSetIdentifierDeclarations": [
            {
                "Identifier": "US_prod_flight",
                "DataSetArn": "arn:aws:quicksight:us-east-1:974477465398:dataset/a6843d1c-8933-4e7d-ac49-4f399e57544a"
            }
        ],
        "Sheets": [
            {
                "SheetId": "a09b933d-2cdf-40a2-887b-0cabd11074fd_bc26cd18-8094-42a4-b68d-7024a693bf5e",
                "Name": "FRAT Report",
                "Visuals": [
                    {
                        "TableVisual": {
                            "VisualId": "a09b933d-2cdf-40a2-887b-0cabd11074fd_80687f4e-53c0-411e-83e2-e30fd74f953d",
                            "Title": {
                                "Visibility": "VISIBLE",
                                "FormatText": {
                                    "RichText": "<visual-title>\n  <inline color=\"#277982\" font-size=\"14px\">\n    <b>FRAT </b>\n  </inline>\n  <inline color=\"#050404\" font-size=\"14px\">Report</inline>\n</visual-title>"
                                }
                            },
                            "Subtitle": {
                                "Visibility": "VISIBLE"
                            },
                            "ChartConfiguration": {
                                "FieldWells": {
                                    "TableAggregatedFieldWells": {
                                        "GroupBy": [
                                            {
                                                "CategoricalDimensionField": {
                                                    "FieldId": "5b56eb4d-24e7-422e-a2d8-4338620ad704.ColumnId-16.0.1713942403560",
                                                    "Column": {
                                                        "DataSetIdentifier": "US_prod_flight",
                                                        "ColumnName": "Booking ID"
                                                    }
                                                }
                                            },
                                            {
                                                "NumericalDimensionField": {
                                                    "FieldId": "5b56eb4d-24e7-422e-a2d8-4338620ad704.ColumnId-55.1.1713942419130",
                                                    "Column": {
                                                        "DataSetIdentifier": "US_prod_flight",
                                                        "ColumnName": "Leg Number"
                                                    }
                                                }
                                            },
                                            {
                                                "CategoricalDimensionField": {
                                                    "FieldId": "5b56eb4d-24e7-422e-a2d8-4338620ad704.ColumnId-9.2.1713942433662",
                                                    "Column": {
                                                        "DataSetIdentifier": "US_prod_flight",
                                                        "ColumnName": "Flight Number"
                                                    }
                                                }
                                            },
                                            {
                                                "CategoricalDimensionField": {
                                                    "FieldId": "5b56eb4d-24e7-422e-a2d8-4338620ad704.ColumnId-30.3.1713942445902",
                                                    "Column": {
                                                        "DataSetIdentifier": "US_prod_flight",
                                                        "ColumnName": "Tail Number"
                                                    }
                                                }
                                            },
                                            {
                                                "DateDimensionField": {
                                                    "FieldId": "5b56eb4d-24e7-422e-a2d8-4338620ad704.ColumnId-4.4.1713942463545",
                                                    "Column": {
                                                        "DataSetIdentifier": "US_prod_flight",
                                                        "ColumnName": "Off-Block (Est)"
                                                    }
                                                }
                                            },
                                            {
                                                "DateDimensionField": {
                                                    "FieldId": "5b56eb4d-24e7-422e-a2d8-4338620ad704.ColumnId-3.5.1713942474638",
                                                    "Column": {
                                                        "DataSetIdentifier": "US_prod_flight",
                                                        "ColumnName": "On-Block (Est)"
                                                    }
                                                }
                                            },
                                            {
                                                "DateDimensionField": {
                                                    "FieldId": "5b56eb4d-24e7-422e-a2d8-4338620ad704.ColumnId-2.6.1713942488810",
                                                    "Column": {
                                                        "DataSetIdentifier": "US_prod_flight",
                                                        "ColumnName": "Off-Block (Act)"
                                                    }
                                                }
                                            },
                                            {
                                                "DateDimensionField": {
                                                    "FieldId": "5b56eb4d-24e7-422e-a2d8-4338620ad704.ColumnId-1.7.1713942496050",
                                                    "Column": {
                                                        "DataSetIdentifier": "US_prod_flight",
                                                        "ColumnName": "On-Block (Act)"
                                                    }
                                                }
                                            },
                                            {
                                                "CategoricalDimensionField": {
                                                    "FieldId": "5b56eb4d-24e7-422e-a2d8-4338620ad704.ColumnId-17.8.1713942515847",
                                                    "Column": {
                                                        "DataSetIdentifier": "US_prod_flight",
                                                        "ColumnName": "Departure Airport (ICAO)"
                                                    }
                                                }
                                            },
                                            {
                                                "CategoricalDimensionField": {
                                                    "FieldId": "5b56eb4d-24e7-422e-a2d8-4338620ad704.ColumnId-18.9.1713942516967",
                                                    "Column": {
                                                        "DataSetIdentifier": "US_prod_flight",
                                                        "ColumnName": "Departure Airport (IATA)"
                                                    }
                                                }
                                            },
                                            {
                                                "CategoricalDimensionField": {
                                                    "FieldId": "5b56eb4d-24e7-422e-a2d8-4338620ad704.ColumnId-20.10.1713942534998",
                                                    "Column": {
                                                        "DataSetIdentifier": "US_prod_flight",
                                                        "ColumnName": "Arrival Airport (ICAO)"
                                                    }
                                                }
                                            },
                                            {
                                                "CategoricalDimensionField": {
                                                    "FieldId": "5b56eb4d-24e7-422e-a2d8-4338620ad704.ColumnId-21.11.1713942535918",
                                                    "Column": {
                                                        "DataSetIdentifier": "US_prod_flight",
                                                        "ColumnName": "Arrival Airport (IATA)"
                                                    }
                                                }
                                            },
                                            {
                                                "CategoricalDimensionField": {
                                                    "FieldId": "5b56eb4d-24e7-422e-a2d8-4338620ad704.ColumnId-47.12.1713942551702",
                                                    "Column": {
                                                        "DataSetIdentifier": "US_prod_flight",
                                                        "ColumnName": "PIC"
                                                    }
                                                }
                                            },
                                            {
                                                "CategoricalDimensionField": {
                                                    "FieldId": "5b56eb4d-24e7-422e-a2d8-4338620ad704.ColumnId-49.13.1713942556094",
                                                    "Column": {
                                                        "DataSetIdentifier": "US_prod_flight",
                                                        "ColumnName": "SIC"
                                                    }
                                                }
                                            },
                                            {
                                                "CategoricalDimensionField": {
                                                    "FieldId": "5b56eb4d-24e7-422e-a2d8-4338620ad704.ColumnId-146.14.1713942569138",
                                                    "Column": {
                                                        "DataSetIdentifier": "US_prod_flight",
                                                        "ColumnName": "AUG1"
                                                    }
                                                }
                                            },
                                            {
                                                "CategoricalDimensionField": {
                                                    "FieldId": "5b56eb4d-24e7-422e-a2d8-4338620ad704.ColumnId-147.15.1713942569806",
                                                    "Column": {
                                                        "DataSetIdentifier": "US_prod_flight",
                                                        "ColumnName": "AUG2"
                                                    }
                                                }
                                            },
                                            {
                                                "CategoricalDimensionField": {
                                                    "FieldId": "5b56eb4d-24e7-422e-a2d8-4338620ad704.ColumnId-66.16.1713942590919",
                                                    "Column": {
                                                        "DataSetIdentifier": "US_prod_flight",
                                                        "ColumnName": "Workflow"
                                                    }
                                                }
                                            },
                                            {
                                                "CategoricalDimensionField": {
                                                    "FieldId": "5b56eb4d-24e7-422e-a2d8-4338620ad704.ColumnId-143.17.1713942606242",
                                                    "Column": {
                                                        "DataSetIdentifier": "US_prod_flight",
                                                        "ColumnName": "FRAT Score"
                                                    }
                                                }
                                            },
                                            {
                                                "CategoricalDimensionField": {
                                                    "FieldId": "5b56eb4d-24e7-422e-a2d8-4338620ad704.ColumnId-145.18.1713942607042",
                                                    "Column": {
                                                        "DataSetIdentifier": "US_prod_flight",
                                                        "ColumnName": "FRAT Status"
                                                    }
                                                }
                                            },
                                            {
                                                "CategoricalDimensionField": {
                                                    "FieldId": "5b56eb4d-24e7-422e-a2d8-4338620ad704.ColumnId-144.19.1713942619134",
                                                    "Column": {
                                                        "DataSetIdentifier": "US_prod_flight",
                                                        "ColumnName": "Authorized by"
                                                    }
                                                }
                                            },
                                            {
                                                "CategoricalDimensionField": {
                                                    "FieldId": "5b56eb4d-24e7-422e-a2d8-4338620ad704.ColumnId-142.20.1713942624614",
                                                    "Column": {
                                                        "DataSetIdentifier": "US_prod_flight",
                                                        "ColumnName": "Flight Mitigation Notes"
                                                    }
                                                }
                                            }
                                        ],
                                        "Values": []
                                    }
                                },
                                "SortConfiguration": {},
                                "TableOptions": {
                                    "HeaderStyle": {
                                        "TextWrap": "WRAP",
                                        "Height": 25
                                    }
                                },
                                "FieldOptions": {
                                    "SelectedFieldOptions": [
                                        {
                                            "FieldId": "5b56eb4d-24e7-422e-a2d8-4338620ad704.ColumnId-16.0.1713942403560",
                                            "Width": "120px"
                                        },
                                        {
                                            "FieldId": "5b56eb4d-24e7-422e-a2d8-4338620ad704.ColumnId-49.13.1713942556094",
                                            "Width": "142px"
                                        }
                                    ],
                                    "Order": []
                                }
                            },
                            "Actions": []
                        }
                    }
                ],
                "Layouts": [
                    {
                        "Configuration": {
                            "GridLayout": {
                                "Elements": [
                                    {
                                        "ElementId": "a09b933d-2cdf-40a2-887b-0cabd11074fd_80687f4e-53c0-411e-83e2-e30fd74f953d",
                                        "ElementType": "VISUAL",
                                        "ColumnIndex": 0,
                                        "ColumnSpan": 35,
                                        "RowIndex": 0,
                                        "RowSpan": 12
                                    }
                                ],
                                "CanvasSizeOptions": {
                                    "ScreenCanvasSizeOptions": {
                                        "ResizeOption": "RESPONSIVE"
                                    }
                                }
                            }
                        }
                    }
                ],
                "ContentType": "INTERACTIVE"
            }
        ],
        "CalculatedFields": [],
        "ParameterDeclarations": [],
        "FilterGroups": [],
        "AnalysisDefaults": {
            "DefaultNewSheetConfiguration": {
                "InteractiveLayoutConfiguration": {
                    "Grid": {
                        "CanvasSizeOptions": {
                            "ScreenCanvasSizeOptions": {
                                "ResizeOption": "FIXED",
                                "OptimizedViewPortWidth": "1600px"
                            }
                        }
                    }
                },
                "SheetContentType": "INTERACTIVE"
            }
        }
    },
    "RequestId": "9542ae29-1461-49a0-b42e-63d2174efc1e",
4

Hi @Fotis_flex - Thanks for the details. Can you please run the update permission for theme… check the below details below. Hope after update the permission,check the description of the dashboard again.

https://boto3.amazonaws.com/v1/documentation/api/latest/reference/services/quicksight/client/update_theme_permissions.html

Regards - Sanjeeb

5

Hi @Sanjeeb2022 . Ok, that sounds like a solution. I am not sure though how to specify the “Grand Permissions” under the “Actions” key. Can you maybe provide the syntax of the actions I should specify? Or provide a link to documentation that lists these actions?

6

Hi @Fotis_flex - Can you please try below steps.

Step -1: Get the theme id :

aws quicksight list-themes --aws-account-id <<aws account id>> --type ALL

Step -2: Update the theme permission

aws quicksight update-theme-permissions --aws-account-id <<account id>> --theme-id <<theme id>>--grant-permissions Principal="<<Give user/group arn>>",Actions=quicksight:DescribeTheme,quicksight:DescribeThemeAlias,quicksight:ListThemeAliases,quicksight:ListThemeVersions

Regards - Sanjeeb