Where to view the backend table of the spend analysis dashboard in cloud cost management workspace?

Lisa71 · ‎04-19-2025

Where to view the backend table of the spend analysis dashboard in cloud cost management workspace? I opened the cloud cost management workspace in UI builder, however the table is grey with "task", however I'm pretty sure the backend table of the dashboard is not task as task table doesn't have cost billing data.

Robert H · ‎04-20-2025

Hello @Lisa71 ,

There are multiple tables involved.

For example, the data for the graph in the "Cloud Spend Analytics" tab is pulled from the sn_cld_spend_core_monthly_provider_agg_cost table, while the "Record view" list below is based on sn_cld_spend_core_monthly_aggregated_cost.

You can see the list of all tables with daily and monthly cost data by filtering for Application = Cloud Spend Reports Core AND Name Ends with "cost":

PS: How to find out which element of the Workspace is backed by which table:

For "Record view" it's relatively easy to find out, as the table is shown in the "Data" section when selecting the element.

For the graph it's a bit more difficult:

Regards,

Robert

View solution in original post

Lisa71 · ‎04-20-2025

This is exactly what I need, thank you very much for your comments and detailed screenshots!