View prebuilt reports in Looker Studio for vaulted backups

This page explains how to view Backup and DR Service prebuilt reports in Looker Studio for vaulted backups.

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 reports for vaulted backups that are protected using backup plans. 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 prebuilt reports in Looker Studio

To view reports in Looker Studio for vaulted backups, you must use the same project ID where logs are routed to BigQuery.

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

  1. Copy and paste the following URL in the address bar of a web browser after replacing the project ID.

        https://lookerstudio.google.com/c/reporting/create
    ?c.reportId=2ccd44e7-5c1e-4858-9111-2594d785ea58
    &r.reportName=Backup%20and%20DR%20Reports
    &ds.ds4.datasourceName=successful_backup_jobs
    &ds.ds4.projectId=PROJECT_ID
    &ds.ds4.type=CUSTOM_QUERY
    &ds.ds4.datasetId=bdr_reports
    &ds.ds4.sql=SELECT%20*%20FROM%20%60PROJECT_ID.bdr_reports.successful_backup_jobs%60(@DS_START_DATE,%20@DS_END_DATE);
    &ds.ds2.datasourceName=backup_jobs_summary
    &ds.ds2.projectId=PROJECT_ID
    &ds.ds2.type=CUSTOM_QUERY
    &ds.ds2.datasetId=bdr_reports
    &ds.ds2.sql=SELECT%20*%20FROM%20%60PROJECT_ID.bdr_reports.backup_jobs_summary%60(@DS_START_DATE,%20@DS_END_DATE);
    &ds.ds10.datasourceName=protected_resource_details
    &ds.ds10.projectId=PROJECT_ID
    &ds.ds10.type=CUSTOM_QUERY
    &ds.ds10.datasetId=bdr_reports
    &ds.ds10.sql=SELECT%20*%20FROM%20%60PROJECT_ID.bdr_reports.protected_resource_details%60(@DS_START_DATE,%20@DS_END_DATE);
    &ds.ds11.datasourceName=backup_vault_consumption
    &ds.ds11.projectId=PROJECT_ID
    &ds.ds11.type=CUSTOM_QUERY
    &ds.ds11.datasetId=bdr_reports
    &ds.ds11.sql=SELECT%20*%20FROM%20%60PROJECT_ID.bdr_reports.backup_vault_consumption%60(@DS_START_DATE,%20@DS_END_DATE);
    &ds.ds9.datasourceName=restore_jobs_details
    &ds.ds9.projectId=PROJECT_ID
    &ds.ds9.type=CUSTOM_QUERY
    &ds.ds9.datasetId=bdr_reports
    &ds.ds9.sql=SELECT%20*%20FROM%20%60PROJECT_ID.bdr_reports.restore_jobs_details%60(@DS_START_DATE,%20@DS_END_DATE);
    &ds.ds7.datasourceName=skipped_backup_jobs
    &ds.ds7.projectId=PROJECT_ID
    &ds.ds7.type=CUSTOM_QUERY
    &ds.ds7.datasetId=bdr_reports
    &ds.ds7.datasetId=bdr_reports
    &ds.ds7.sql=SELECT%20*%20FROM%20%60PROJECT_ID.bdr_reports.skipped_backup_jobs%60(@DS_START_DATE,%20@DS_END_DATE);
    &ds.ds8.datasourceName=restore_jobs_summary
    &ds.ds8.projectId=PROJECT_ID
    &ds.ds8.type=CUSTOM_QUERY
    &ds.ds8.sql=SELECT%20*%20FROM%20%60PROJECT_ID.bdr_reports.restore_jobs_summary%60(@DS_START_DATE,%20@DS_END_DATE);
    &ds.ds12.datasourceName=daily_scheduled_compliance
    &ds.ds12.projectId=PROJECT_ID
    &ds.ds12.type=CUSTOM_QUERY
    &ds.ds12.datasetId=bdr_reports
    &ds.ds12.sql=SELECT%20*%20FROM%20%60PROJECT_ID.bdr_reports.daily_scheduled_compliance%60(@DS_START_DATE,%20@DS_END_DATE);
    &ds.ds6.datasourceName=failed_backup_jobs
    &ds.ds6.projectId=PROJECT_ID
    &ds.ds6.type=CUSTOM_QUERY
    &ds.ds6.datasetId=bdr_reports
    &ds.ds6.sql=SELECT%20*%20FROM%20%60PROJECT_ID.bdr_reports.failed_backup_jobs%60(@DS_START_DATE,%20@DS_END_DATE);
    &ds.ds42.datasourceName=backup_jobs_details
    &ds.ds42.projectId=PROJECT_ID
    &ds.ds42.type=CUSTOM_QUERY
    &ds.ds42.datasetId=bdr_reports
    &ds.ds42.sql=SELECT%20*%20FROM%20%60PROJECT_ID.bdr_reports.backup_jobs_details%60(@DS_START_DATE,%20@DS_END_DATE);

    Replace the following:

    • PROJECT_ID: the name of your project.

  2. Click Authorize.

  3. Sign in with your Google Cloud account.

    You are directed to Looker Studio, where you can view Backup and restore job logs for vaulted backups, Protected resource reports for vaulted backups, and Backup vault consumption logs for vaulted backups. 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 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