Set up Cloud Billing data export to BigQuery

Prerequisites

To enable and configure the export of Google Cloud billing usage cost data to a BigQuery dataset, you need the following permissions:

• For Cloud Billing, you need either the Billing Account Costs Manager role or the Billing Account Administrator role on the target Cloud Billing account.

• For BigQuery, you need the BigQuery User role for the Google Cloud project that contains the BigQuery dataset to be used to store the Cloud Billing data.

For more information about Google Cloud permissions, see GCP | Set up Cloud Billing data export to BigQuery

Steps To Follow

1. Open Billing page in GCP Console. Click on the Billing Account which you want to export billing data.

2. In the Billing navigation menu, click Billing Export. Under Detailed usage cost section, click the EDIT SETTINGS button.

   

3. You need to fill the required fields:

Field	Description
Projects	Select the specific project that you want to make it contain your billing data.
Dataset	Select an existing dataset or create a new one to contain your exported Cloud Billing data.

1. Finally, click the SAVE button to finish the process. After a few hours, you will see a table automatically created under your entered Dataset.

• When you first enable the standard or detailed usage cost export to BigQuery, it might take a few hours to start seeing Google Cloud cost data propagate to your BigQuery dataset. Data is exported in chronological order. If your export is configured to include data retroactively for the current and previous month, it might take up to 5 days for the exported data to fully catch up to your current usage data.

• For more information, see: Set up Cloud Billing data export to BigQuery