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 |
