Hi Folks,
We are building looker dashboards for BigQuery cost monitoring purposes and tracking all the query costs for all 50+ gcp projects. we want to use information schema but can anyone help me how to aggregate all the 50 gcp projects info schema into one table so that we can holistic view all data. we want this project info schema to be retained for 1 year.
Hi @pankaj_cloud
Have you explored under Billing → Cost Breakdown page which provides dashboards costs across organisations/projects and at resource levels too? let me know.
based on your response, I can further explain how you potentially co do this if Billing → Cost Breakdown is not a viable option for you
hey @bihagkashikar
i am aware of the Billing Breakdown, but i think it does not show per query cost that the user has executed for that we have to leverage BQ JOBS_BY_ORG org PROJ schema to calculate query cost. we want to aggregate JOBS_BY_PROJ schema data from across all projects because “query” column is not visible in ORG schema. I need a strategy to aggregate this data.
Hi @pankaj_cloud , @bihagkashikar ,
I have some what same requirement, I need to calculate query cost at as dry run before actual query execution in Java program.
Did you get any solution on this?