Add an Instance and a Cloud Account for Google Cloud BigQuery

Add an instance and a cloud account for Google Cloud BigQuery.

Procedure

1. From the navigation pane, go to Protect > Databases.

   The Overview page appears.

2. In the upper-right corner, click Add instance, and then select Cloud database service.

   The Add Cloud DB Instance page appears.

3. Select vendor as Google Cloud and then click Next.

   The Configure Google Cloud Database page appears.

4. Select database service as BigQuery and click NEXT.

   The Configure Google Cloud Database - BigQuery page appears.

5. In the Select a Plan section, choose whether to use a base plan or create a new backup plan, as follows:

   • Select an existing base plan from the list.

   • To create a new backup plan, do the following:

     1. Click the add button .

        The Create backup plan dialog box appears.

     2. Enter a name for the backup plan in the Plan name field.

     3. Select storage from the Storage list.

     4. Select a retention plan from the Retention rules list.

6. Click Next.

   The Cloud Account page appears.

7. Choose whether to use an existing cloud account or create a new account, as follows:

   1. Select a cloud account from the Cloud Account list.

   2. To create a new cloud account, do the following:

      1. Click the add button .

         The Add cloud account dialog box appears.

      2. Enter a name for the account in the Name field.

      3. Select a saved credential from the Credential list, or click the add button to add a credential, as follows:

         • In Account type, the cloud account is selected by default.

         • In Vendor type, the Google Cloud is selected by default.

         • In Authentication type, the service account is selected by default.

         • In the Credential name field, enter the name of the credential.

         • In the Service Account ID field, enter the Google Cloud Service Account ID.

         • For JSON file path, select the JSON file for service account authentication that you downloaded when you created the GCP service account for the associated project.

         • Click Save.

      4. From the Access node list, select the access node to use for the cloud account.

      5. Click Save.

8. Click Next.

   The Configure Google Cloud Database - BigQuery page appears.

9. In the Instance field, the selected cloud account is displayed.

10. From the Project list, select a project.

11. Optional. Move the Automatically select staging path toggle key to right to define the staging bucket path automatically.

12. If you do not select Automatically select staging path, in the Staging bucket path field, enter the location to use for staging backups of the instance.

13. Click Next.

    The Backup Content page appears.

14. In the Backup Content section, browse and select datasets and tables of the selected cloud project.

15. Click Next.

    The Summary page appears.

16. Click Finish.