BigQuery offers a set of native metadata tables called BigQuery Information Schema, which provide comprehensive data on consumption and performance across the entire organization. Make the most of your investment in BigQuery using the BigQuery Performance Monitoring block, to identify several opportunities to optimize performance and slot consumption:
The Block is built off of the
_JOBS_TIMELINE_BY_ORGANIZATION_ tables, to provide a complete picture of usage across all projects. This block requires a Service Account with the following BigQuery permissions:
_bigquery.jobs.listAll_ for the organization and is available to the organization
_bigquery.resourceAdmin_, Organization Owner and Organization Admin roles. Note that
_JOBS_BY_ORGANIZATION_ is only available to users with defined Google Cloud organizations. More information on permissions and access control in BigQuery can be found here.
Due to potential query costs, this Block is currently intended only for customers with Committed Slots Flat-Rate customers, not On-Demand customers.