How do I ingest the AWS Cost and Usage Report (CUR) into Amazon Quick Suite and then visualize it?

Resolution

To ingest and visualize your Cost and Usage Report (CUR), complete the following steps:

1. Create a Cost and Usage Report.

2. Authorize Quick Suite to access your Amazon S3 bucket.

3. Open the Quick Suite console.

4. Choose Manage Data.

5. Choose New Data Set.

6. Choose S3 to open 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 set the proper permissions for Quick Suite to access the S3 bucket. Otherwise, you can't access any data in Quick Suite.

8. In the Upload a Manifest field, choose Upload, or enter the URL of your AWS Cost and Usage Report manifest. For example:

   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 with your S3 bucket name
   report_path_example with your CUR Report path prefix
   AWS_CUR_QS_ReportName with your CUR Report name
   20200601-20200701 with the date range of your CUR Report

9. Choose Connect to create and then open the new dataset.

10. 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.

Troubleshoot CUR ingestion issues

Resolve Quick Suite folder errors

If you can't find the Quick Suite folder under your S3 bucket, then complete the following actions:

• Wait 24 hours before you regenerate the CUR report and manifest file.
• Verify that you selected Quick Suite for the Enable report data integration for field.

Resolve manifest file parsing errors

If you receive the "We can't parse the manifest file as a valid JSON" error message, then complete the following actions:

• Check whether you correctly authorized Quick Suite to access your S3 bucket.
• Verify that the URL of the manifest file that you copied over is located in the Quick Suite folder. Each service folder must have its own manifest file.

Configure access for multiple AWS accounts

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 Consolidating billing for AWS Organizations.

Related information

What are AWS Cost and Usage Reports?

I can't connect to Amazon S3

Creating a cost and usage dashboard