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.
aws_alpha_costexplorer_cost_custom
table_options
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