Table: aws_costexplorer_cost_30d

This table shows data for AWS Cost Explorer costs for the last 30 days.

https://docs.aws.amazon.com/aws-cost-management/latest/APIReference/API_GetCostAndUsage.html (opens in a new tab) To sync this table you must set the 'use_paid_apis' option to 'true' in the AWS provider configuration.

The composite primary key for this table is (account_id, start_date, end_date).

Columns

Name	Type
_cq_source_name	`utf8`
_cq_sync_time	`timestamp[us, tz=UTC]`
_cq_id	`uuid`
_cq_parent_id	`uuid`
account_id (PK)	`utf8`
start_date (PK)	`utf8`
end_date (PK)	`utf8`
estimated	`bool`
groups	`json`
time_period	`json`
total	`json`