If you are a BigQuery user and you visualise your data with Data Studio then you might want to answer the following questions:

  • What was the cost of each Data Studio report for yesterday?
  • How many times each query/report was run and who ran it?
  • What was the cost of queries for tables, datasets (e.g. production/staging/ analytics) with label X?
  • Can I be notified in case of a sudden surge in billed bytes amount?

Standard Google Billing dashboard won’t answer these questions.

According to official Google docs at the moment you can’t use labels for BigQuery jobs.

#analytics #data-engineering #data-visualization #data-science #big-data

Monitoring your BigQuery costs and reports usage with Data Studio
7.00 GEEK