Creating a Cost and Usage Reports status table - Amazon Data Exports
Services or capabilities described in Amazon Web Services documentation might vary by Region. To see the differences applicable to the China Regions, see Getting Started with Amazon Web Services in China (PDF).

Creating a Cost and Usage Reports status table

Amazon refreshes your Amazon CUR multiple times a day. There isn't a way for Athena to tell when Amazon is in the process of refreshing your report, which can lead to query results with a combination of old and new data. To mitigate this, create a table to track whether Amazon is refreshing your Cost and Usage Reports and query that table to see if Amazon is refreshing your data. You only need to create this table once. After that, Amazon keeps the table up to date.

To create your refresh table

  1. Open the Athena console at https://console.amazonaws.cn/athena/.

  2. In the New query 1 query pane, paste the following SQL. 

    CREATE EXTERNAL TABLE IF NOT EXISTS cost_and_usage_data_status(
  status STRING)
ROW FORMAT SERDE
  'org.apache.hadoop.hive.ql.io.parquet.serde.ParquetHiveSerDe'
WITH SERDEPROPERTIES (
 'serialization.format' = '1'
)
LOCATION 's3://{S3_Bucket_Name}/{Report_Key}/cost_and_usage_data_status/'

  3. Choose Run query.

To check whether Amazon is refreshing your data, use the Athena console to run the following SQL query.

select status from cost_and_usage_data_status