visualize the AWS CUR into Amazon QuickSight

0

I am following up on my previous question regarding CUR, how do I send CUR data to Quicksight to create dashboards?

Julian
已提問 4 個月前檢視次數 2160 次
3 個答案
2
已接受的答案

Hi, this information is available in our knowledge centre.

  1. Create a Cost and Usage Report.

  2. Authorize QuickSight to access your Amazon S3 bucket.

  3. Open the QuickSight console.

  4. Choose Manage Data.

  5. Choose New Data Set.

  6. Choose S3. This opens the Amazon S3 data source dialog box.

  7. In the Amazon S3 data source dialog box, enter a data source name.

Important: Make sure that you've set the proper permissions for QuickSight to access the S3 bucket. Otherwise, you can't access any data in QuickSight.

  1. In the Upload a Manifest field, choose Upload, or enter the URL of your AWS Cost and Usage Report manifest file like this:

s3://awscostusagereport-quicksight/report_path_example/QuickSight/AWS_CUR_QS_ReportName-20200601-20200701-QuickSightManifest.json Replace the following variables to indicate the S3 folder and JSON file that you created in Step 1:

awscostusagereport-quicksight: Your S3 bucket report_path_example: The CUR Report path prefix AWS_CUR_QS_ReportName: Your CUR Report name 20200601-20200701: The date range of your CUR Report

  1. Choose Connect. This creates and opens the new dataset.

  2. After you create the new dataset, choose Visualize to display all the data fields in your AWS Cost and Usage Report. For more information about the CUR data field definitions, see the Data dictionary.

Additional troubleshooting If you can't find the QuickSight folder under your S3 bucket, try the following:

Allow 24 hours before attempting to regenerate the CUR report and manifest file. Verify that you selected QuickSight for the Enable report data integration for field. If you get a "We can't parse the manifest file as a valid JSON" error message, try the following:

Check whether you've correctly authorized QuickSight to access your S3 bucket. Verify that the URL of the manifest file that was copied over is located in the QuickSight folder. Each service folder must have its own manifest file. If you have multiple AWS accounts under the same organization, make sure that you have proper access rights from the management account. This report is available only to the management account owner and any users who are granted access by the management account. For more information, see Consolidated billing for AWS Organizations.

AWS
已回答 4 個月前
profile picture
專家
已審閱 2 個月前
0

There is also a workshop for CUR + Quicksight

And you may want to consider looking at CUDOS and CID

profile pictureAWS
專家
已回答 4 個月前
0

I would highly recommend considering the new Data Exports feature with the new Cost and Usage Dashboards. Check this out - https://aws.amazon.com/blogs/aws-cloud-financial-management/new-cost-and-usage-dashboard-powered-by-amazon-quicksight/

This new feature allows you to easily implement QuickSight dashboard from your CUR. Instead of setting this up manually, the Cost and Usage Dashboard will be created for you with some pre-defined, and pre-setup visualizations using your CUR. Much easier setup than doing it manually.

You can later edit the dashboard and make custom visuals if you want.

profile pictureAWS
專家
已回答 4 個月前

您尚未登入。 登入 去張貼答案。

一個好的回答可以清楚地回答問題並提供建設性的意見回饋,同時有助於提問者的專業成長。

回答問題指南