Cloudquery sync for azure cost tables returns no resources found

For the Azure cost-related table, I only found these tables:

  • azure_costmanagement_views
  • azure_costmanagement_view_queries

However, when I sync the data, there are no resources. What could be the problem?

Starting sync for: azure-cost (azure@v9.0.2) -> [postgresql (v5.0.1)]
Sync completed successfully. Resources: 0, Errors: 0, Warnings: 0, Time: 5s

Hi @calm-walrus, I believe this is because a view is a saved query in Cost Management. If there are no saved queries, the resulting table will be empty.

Learn more about saving and sharing views.

There is a blog post about this topic that might be useful to you: Azure Cost Optimization with CloudQuery.