BigQuery Launches Administrative Jobs Explorer for Enhanced MonitoringBigQuery has introduced a new feature called the administrative jobs explorer, now generally available (GA). This tool aims to simplify job monitoring and troubleshooting across organizations for BigQuery administrators.

Key Features of Administrative Jobs Explorer

1. Comprehensive Monitoring: Allows administrators to quickly view job activity across their entire organization.

2. User-Friendly Interface: Eliminates the need for deep understanding of INFORMATION_SCHEMA views.

3. Advanced Filtering: Offers various filters and sorting options to identify and troubleshoot problematic jobs.

4. Detailed Job Information: Provides quick access to job details such as owner, project, slot usage, and duration.

Access and Permissions

To use the administrative jobs explorer, administrators need the BigQuery Resource Viewer (roles/bigquery.resourceViewer) IAM role. This role can be granted at the organization or project level.

Underlying Technology

The jobs explorer leverages information from existing INFORMATION_SCHEMA views, including:

• INFORMATION_SCHEMA.JOBS_BY_PROJECT
• INFORMATION_SCHEMA.JOBS_BY_ORGANIZATION
• INFORMATION_SCHEMA.JOBS_BY_USER

How to View Query Execution Details

Administrators can easily access detailed information about specific jobs:

1. Navigate to the Jobs explorer page.
2. Click Jobs explorer to view jobs.
3. Apply filters to narrow down the job list.
4. Select a specific job to view its details.
5. In the Query results pane, click the Execution graph tab to see the execution details of the job.

This new feature streamlines the process of monitoring and managing BigQuery jobs, potentially saving administrators time and improving efficiency in identifying and resolving issues across their BigQuery environments.