Setting up Billing Exports: BigQuery

Previously, GCP used to also support file export options, but it is now deprecated by GCP.

In this lesson, we will create a sink to export billing data into the BigQuery dataset. This will allow us to query our billing data. For a smaller dataset, this doesn’t make much sense. However, when an organization is large enough to generate more than GBs of billing data, BQ analytics make much more sense to learn the costs and spending patterns.

Exporting billing data

To enable the export, follow the steps given below.

1. Main menu > Billing

2. Select the primary billing account. Click on Billing export.

3. Select the “Bigquery export” option.