How do I ingest and visualize the AWS Cost and Usage Report (CUR) into Amazon QuickSight?

Last updated: 2020-08-11

I want to ingest the AWS Cost and Usage Report (CUR) from Amazon Simple Storage Service (Amazon S3) into Amazon QuickSight. How do I import and visualize my monthly CUR results?

Resolution

You can ingest and visualize your AWS Cost and Usage Report (CUR) by doing the following:

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 S3 data source dialog.

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

Important: Be sure that you have the proper permissions to access the Amazon S3 bucket. Otherwise, you won't be able to access any data in QuickSight.

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

s3://s3_example_bucket/report_path_prefix/QuickSight/example_report_name-date_range-QuickSightManifest.json

Note: Replace the following variables to indicate the S3 folder and JSON file that you created in Step 1:
s3_example_bucket
report_path_prefix
example_report_name
date_range

9.    Choose Connect. This creates and opens the new data set.

10.    After you create the new data set, choose Visualize to display all the data fields in your AWS Cost & Usage Report. For more information about the CUR data field definitions, see the Cost and Usage Report 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 under the Enable report data integration for setting.

If you get a "We can't parse the manifest file as a valid JSON" error message, try the following:

  • Check whether you have correctly authorized QuickSight to access your S3 bucket.
  • Check that the URL of the manifest file that you 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 only available to the management account owner and any users that are granted access by the management account. For more information, see Consolidated billing for AWS Organizations.


Did this article help?


Do you need billing or technical support?