Cloud Intelligence Dashboards - Trusted Advisor - How to add Priority data to Athena table and view?

Hello,

I understand your concern regarding adding the Trusted Advisory Priority data to the Athena table and view so that it can be used in querying from the QuickSight dashboard to analyze the data.

Unfortunately, this is currently not supported. However, the concerned team is working on this feature, and it is already in the pipeline. While we are ensuring this feature's support, we cannot provide an ETA for this change right now.

Thank you for your understanding and have a great day!

To integrate Trusted Advisor Priority data into your Cloud Intelligence Dashboards and make it usable in QuickSight analysis, you'll need to follow these steps:

1. Ensure you have an Enterprise Support plan, as Trusted Advisor Priority is only available to Enterprise Support customers.

2. Verify that Trusted Advisor Priority has been activated for your organization. If it hasn't been enabled, you'll need to work with your AWS account team to activate this feature.

3. Once Trusted Advisor Priority is enabled, you'll need to modify your existing data collection process to include the new Priority recommendations. This will likely involve updating your Lambda function to call additional Trusted Advisor APIs specifically for Priority recommendations. The relevant APIs include:

   • ListOrganizationRecommendations
   • GetOrganizationRecommendation
   • ListOrganizationRecommendationResources
   • ListOrganizationRecommendationAccounts

4. Update your Lambda function to write the responses from these new API calls to your designated S3 bucket, following the same structure as your existing Trusted Advisor data.

5. Modify your AWS Glue crawler configuration to include the new data you've added to S3. This will ensure that the Glue Data Catalog is updated with the new Priority recommendation data.

6. Once the Glue crawler has run and updated the Data Catalog, you may need to modify your existing Athena views or create new ones to incorporate the Priority data.

7. After the data is available in Athena, update your QuickSight datasets to include the new Priority data. You might need to create new datasets or modify existing ones to incorporate this information.

8. Finally, update your QuickSight analyses and dashboards to visualize the new Trusted Advisor Priority data alongside your existing Trusted Advisor information.

Remember that it may take up to 24-48 hours for the initial data to appear after making these changes. If you encounter any issues during this process, you may need to troubleshoot by checking CloudWatch logs for your Lambda function, verifying S3 bucket permissions, and ensuring that your IAM roles have the necessary permissions to access and process the new data.
Sources
Optimize your cloud deployments with Prioritized Trusted Advisor recommendations in your operational workflows | AWS Cloud Operations Blog
Data collection for dashboards | AWS re:Post
Trusted Advisor Priority Feature | AWS re:Post