*New* Query Usage and Spending Dashboard

Have you ever wondered how much money you’re spending on your queries? Do you ever worry that all of your budget is being spent by running SELECT * queries on your largest tables? Do you want insight into how much queries cost so that you can find opportunities to write better queries that run faster and save money? With a Query Usage and Spend dashboard, you can have this information at your fingertips!

How does the Query Usage and Spending Dashboard work? Google Cloud Platform makes it easy to gather logs about BigQuery usage and collect them in a table in BigQuery. (If you’re eager to get into the weeds, check out Google’s documentation to read more about how to route logs into BigQuery and then query them.) Once that usage information is in BigQuery, we connect it to a Looker Studio report with views of spend per user, most expensive queries, and spend trends over time. You can filter these views based on date range, user, or dataset ID. And of course, you can take the data source connected to the Looker Studio report and go wild building whatever tables, charts, and graphs you want!

Example of the Usage and Spending Dashboard in Looker Studio

If this dashboard sounds like something helpful for you or your team, don’t hesitate to reach out to CTA. We would be happy to provide you with this tooling to help you make the most of running queries in PAD!