Missing full cost explorer tables in CloudQuery for AWS

After syncing all tables I picked from CloudQuery Documentation, I realized there is no table related to cost.

Then I went through the tables one by one, and the only two cost-related tables in AWS are:

  • aws_costexplorer_cost_30d
  • aws_costexplorer_cost_forecast_30d

Do we have full Cost Explorer tables?

There aws_alpha_costexplorer_cost_custom table takes inputs from table_options to enable you to specify whatever dimensions or time range you want.

Hey @calm-walrus, to add on to what Ben mentioned above, it’s possible to also sync from AWS Cost and Usage Reports via the file plugin and then correlate information from Cost and Usage Reports to information synced via the AWS plugin.

An example for loading the AWS Cost and Usage Reports to Athena: How to Query AWS Cost and Usage in Athena

File Plugin: File Plugin Overview