Setting up Billing Data Export to BigQuery

The Channel Services Billing Export is a dataset offered to resellers via BigQuery. To export Channel Services Billing data to BigQuery, you need to take the following steps:

1. Create a project in Google Platform Console.

   

2. Link the project to the billing account. For further details on the steps to follow, refer to Google Cloud documentation.

   

3. Create a BigQuery dataset in the project. To do this, follow the instructions provided in the links below:

   • Set up Channel Services data export to BigQuery

   • Set up Cloud Billing data export to BigQuery (step 5 is not required).

4. Add the service account cloud-channel-billing-reporting-rebilling@system.gserviceaccount.com with the following predefined BigQuery Data Editor role in the project. To do this, complete these steps:

   1. Go to your project.

   2. Click Go to project settings.

   3. Click IAM and click Add.

   4. Add cloud-channel-billing-reporting-rebilling@system.gserviceaccount.com and assign it the BigQuery Data Editor role.

   
   The service account (cloud-channel-billing-reporting-rebilling@system.gserviceaccount.com) is owned and managed by Google, so the permissions required to create a table and to write Channel Services Billing records to such table are also provided by Google.

   

5. Enable customer rebilling in the Partner Sales Console. To do this, you need to specify the a fully qualified dataset ID in the following format: project_name:dataset_name. Then, click Update.

   

   Once this is done and the permissions are granted, a table will be automatically created in BigQuery, where data will be exported.

Related Topics

• Enabling APIs and Creating and Configuring a Service Account