View prebuilt reports in Looker Studio

This page explains how to view Backup and DR Service reports in Looker Studio.

After you set up prebuilt reports in BigQuery, you can view them in Looker Studio. Looker Studio is a cloud-based business intelligence and data visualization tool that lets you to view, modify, and create reports and dashboards.

You can use the Looker Studio template to connect to your BigQuery dataset and view the prebuilt Backup and DR Service reports. The Looker Studio template is a pre-designed report or dashboard that gives you a head start for visualizing your data.

Prerequisite

View Backup and DR Service reports in Looker Studio

To view reports in Looker Studio, you must use the same dataset name and project ID where logs are routed to BigQuery.

Use the following instructions to view Backup and DR Service reports in Looker Studio.

  1. Copy and paste the following URL based on your backup/recovery appliance version in the address bar of a web browser after replacing the project ID and dataset.

    • If your backup/recovery appliance is on 11.0.10, use the following URL.

      https://lookerstudio.google.com/reporting/create
?c.reportId=a00296dc-1687-41b5-be52-ab55cd805744
&r.reportName=Backup%20and%20DR%20-%20Report%20&%20Insights
&ds.ds1.datasourceName=Job%20Details
&ds.ds1.connector=bigQuery
&ds.ds1.projectId=PROJECT_ID
&ds.ds1.type=TABLE
&ds.ds1.datasetId=DATASET
&ds.ds1.tableId=Job%20Details
&ds.ds2.datasourceName=Protected%20Data%20Resource
&ds.ds2.connector=bigQuery
&ds.ds2.projectId=PROJECT_ID
&ds.ds2.type=TABLE
&ds.ds2.datasetId=DATASET
&ds.ds2.tableId=Protected%20Data%20Resource
&ds.ds3.datasourceName=Recovery%20Jobs%20Summary
&ds.ds3.connector=bigQuery
&ds.ds3.projectId=PROJECT_ID
&ds.ds3.type=TABLE
&ds.ds3.datasetId=DATASET
&ds.ds3.tableId=Recovery%20Jobs%20Summary
&ds.ds4.datasourceName=Daily%20Schedule%20Compliance
&ds.ds4.connector=bigQuery
&ds.ds4.projectId=PROJECT_ID
&ds.ds4.type=TABLE
&ds.ds4.datasetId=DATASET
&ds.ds4.tableId=Daily%20Schedule%20Compliance
&ds.ds5.datasourceName=Backup%20Jobs%20Summary
&ds.ds5.connector=bigQuery
&ds.ds5.projectId=PROJECT_ID
&ds.ds5.type=TABLE
&ds.ds5.datasetId=DATASET
&ds.ds5.tableId=Backup%20Jobs%20Summary
&ds.ds6.datasourceName=Failed%20Jobs
&ds.ds6.connector=bigQuery
&ds.ds6.projectId=PROJECT_ID
&ds.ds6.type=TABLE
&ds.ds6.datasetId=DATASET
&ds.ds6.tableId=Failed%20Jobs
&ds.ds7.datasourceName=Unresolved%20Failures
&ds.ds7.connector=bigQuery
&ds.ds7.projectId=PROJECT_ID
&ds.ds7.type=TABLE
&ds.ds7.datasetId=DATASET
&ds.ds7.tableId=Unresolved%20Failures

    • If your backup/recovery appliance is on 11.0.9, use the following URL.

      https://lookerstudio.google.com/reporting/create
?c.reportId=a00296dc-1687-41b5-be52-ab55cd805744
&r.reportName=Backup%20and%20DR%20-%20Report%20&%20Insights
&ds.ds1.datasourceName=Job%20Details
&ds.ds1.connector=bigQuery
&ds.ds1.projectId=PROJECT_ID
&ds.ds1.type=TABLE
&ds.ds1.datasetId=DATASET
&ds.ds1.tableId=Job%20Details
&ds.ds3.datasourceName=Recovery%20Jobs%20Summary
&ds.ds3.connector=bigQuery
&ds.ds3.projectId=PROJECT_ID
&ds.ds3.type=TABLE
&ds.ds3.datasetId=DATASET
&ds.ds3.tableId=Recovery%20Jobs%20Summary
&ds.ds5.datasourceName=Backup%20Jobs%20Summary
&ds.ds5.connector=bigQuery
&ds.ds5.projectId=PROJECT_ID
&ds.ds5.type=TABLE
&ds.ds5.datasetId=DATASET
&ds.ds5.tableId=Backup%20Jobs%20Summary
&ds.ds6.datasourceName=Failed%20Jobs
&ds.ds6.connector=bigQuery
&ds.ds6.projectId=PROJECT_ID
&ds.ds6.type=TABLE
&ds.ds6.datasetId=DATASET
&ds.ds6.tableId=Failed%20Jobs
&ds.ds7.datasourceName=Unresolved%20Failures
&ds.ds7.connector=bigQuery
&ds.ds7.projectId=PROJECT_ID
&ds.ds7.type=TABLE
&ds.ds7.datasetId=DATASET
&ds.ds7.tableId=Unresolved%20Failures

    Replace the following:

    • PROJECT_ID: the name of your project.
    • DATASET: the name of your BigQuery dataset. The default BigQuery dataset name for Backup and DR Service reports is BackupandDR_reports. In case you have set a different name for your BigQuery dataset for Backup and DR Service reports, modify the dataset name to match your BigQuery dataset.

  2. Click Authorize.

  3. Sign in with your Google Cloud account.

    You are directed to Looker Studio, where you can view Job reports, Daily Schedule Compliance reports, and Protected Resource reports. These reports are available with view-only access. You can export reports to a CSV file or as individual sheets. You can save this URL for quick access to Backup and DR Service prebuilt reports.

    Looker Studio automatically refreshes your report at certain intervals. To change the default data refresh rate, see Manage data freshness.

For advanced use cases, such as scheduling, emailing, customizing, and sharing, you can make your own copy of the report using the Edit and share button.

Pricing

Looker Studio is available at no charge for viewing and creating reports. However, BigQuery is a paid product and you will incur charges for using it when you access BigQuery datasets through the Looker Studio. There are no charges for the first 1 TiB BigQuery data processed per month. For detailed pricing information, see BigQuery pricing and Looker Studio pricing.

What's next