Creating a standard export

You can create a standard data export that you can analyze using other processing tools (Amazon Athena, for example).

To create a standard data export

1. Sign in to the AWS Billing and Cost Management console at https://console.aws.amazon.com/costmanagement/home#.

2. In the navigation pane, choose Data Exports.

3. Choose Create.

4. On the Create page, under Export type, choose Standard data export.

5. For Export name, enter a name for your export.

   Export names can have up to 128 characters and must be unique. Valid characters are a-z, A-Z, 0-9, - (hyphen), and _ (underscore).

6. Under Data table content settings, you can specify the data and columns to be contained within your export.

   1. For Additional export content, you can add additional data to your CUR 2.0 export.

      • Select Include resource IDs to include the IDs of each individual resource in the export.

        Note

        Including resource IDs creates individual line items for each of your resources. This might increase the size of your export significantly, based on your AWS usage.

      • Select Split cost allocation data to include detailed cost and usage for shared resources (Amazon ECS only).

        Note

        Including split cost allocation data creates individual line items for each of your resources (that is, ECS tasks). This might increase the size of your Cost and Usage Report significantly, based on your AWS usage.

      • Select Enable manual discount format to convert your discounts so that they appear in the Cost and Usage Report in the manual discount format instead of the standard automated format.

        Note

        This option only appears if you are on the discount automation program.

   2. For Time granularity, choose one of the following:

      • Hourly if you want the line items in the export to be aggregated by the hour.

      • Daily if you want the line items in the export to be aggregated by the day.

      • Monthly if you want the line items in the export to be aggregated by month.

   3. For Column selection, select the columns you want to include in your export. If unsure, select all columns by selecting the first check box at the top of the table. Selecting more columns may increase the file size of your export.

7. Under Data table delivery options, for Data export refresh cadence, the only option available is Daily - refresh at least once per day.

8. For Compression type and file format, choose between the following for your export:

   • Parquet – Parquet

   • gzip – text/csv

9. For File versioning, choose between the following which determines whether your export is overwritten with each update:

   • Overwrite existing data export file: Each export refresh overwrites the previous delivery within the data partition (for example, billing periods). Overwriting exports can save on Amazon S3 storage costs.

   • Create new data export file: Each export refresh is written to a separate directory, even for deliveries of the same partition (for example, billing period). Creating new export versions allows you to track the changes in cost and usage data over time.

10. Under Data export storage settings, for S3 bucket name, choose Configure.

11. In the Configure S3 bucket dialog box, do one of the following:

    • Select existing bucket.

    • Choose Create a bucket, enter an S3 bucket name, and then choose the Region where you want to create a new bucket.

12. Review the Bucket policy. If you're selecting an existing bucket, you need to acknowledge that Data Exports will overwrite you existing S3 bucket policy. The new policy will allow both CUR and Data Exports to deliver exports.

13. For S3 path prefix, enter a name for the directory that will be created in your S3 bucket to store all the export data.

14. Under Tags, you can choose to add up to 50 tags in order to search and filter your resources or track your AWS costs.

    Note

    Adding tags is optional.

15. Choose Create.