This page explains how to view view reports in Google connected sheets. It also explains how to download reports to a local file.
After you set up prebuilt reports, if you have access to Google Workspace, you can view the results in Google connected sheets. For more information, see Using Connected Sheets.
If you don't have access to Google Workspace, you can view the reports in Looker Studio or download prebuilt reports in a CSV file. For instructions, see Download prebuilt reports.
To view prebuilt reports in Google connected sheets, do the following:
- In the Google Cloud console, go to the BigQuery Studio page:
- In the Explorer panel, click the expander arrow to expand a dataset.
- Select a prebuilt report. For example,
Backup Jobs Summary. From Export, click Explore with sheets.
A new tab opens in connected sheet with the report data.
Download prebuilt reports
After you set up the prebuilt reports, you can download them to a local file. For more information, see Downloading and saving query results from the Google Cloud console.
To download prebuilt reports in BigQuery, do the following:
- In the Google Cloud console, go to the BigQuery Studio page:
- In the Explorer panel, click the expander arrow to expand a dataset.
- Select a prebuilt report. For example,
Backup Jobs Summary. Click Query and select either In new tab or In split tab.
A new tab opens with a sample query.
Write a query based on the field names that are populated in the Schema tab. For example, you can use the following query to download the entire report.
SELECT * FROM `PROJECT_ID.BackupandDR_reports.Backup Jobs Summary`.Click Run to display the preview of the query results.
From Save results, select CSV (local file) to download report to a local file.