Enable Billing Export to BigQuery

Google offers a way of controlling and analyzing your costs through Reports module and BigQuery.

BigQuery enables you to export your daily usage and cost estimates automatically. One of the biggest advantages is that you will be able to filter separate projects, dates, products, services, etc.

How to enable billing export to BigQuery

Before you start make sure that you have an internal Project in Google that you can use so any charges will be billed to your account and not the client's. There is a free tier for BigQuery but for more information about billing, click here. As an example of charges from our experience: three months and 46 projects have costed about $0.4 in BigQuery cost.

3. If you have more billing accounts, choose the option Go to linked billing account to manage the billing of the project you have selected. To select a different billing account, click Manage billing accounts.

4. Click on the account you will be exporting

And then click Billing export

5. Select BigQuery export.

6. Select the project where your BigQuery dataset is stored from the Project list. If you don't have any BigQuery dataset yet, you'll be prompted to create one (step 7 below).

7. To create a new dataset (if you don't have any): In the BigQuery web UI, on the left navigation, click the down arrow next to your project name, then click Create new dataset.

8. In the console, select your internal project from the Project dropdown (if not selected already). Then choose a dataset to export data to from the Billing export dataset list. If you just created a new dataset, select it's name.Note: you only need to do this once per billing account, NOT per project.

9. Click Enable BigQuery export.

After you enable BigQuery export, the system may take a few hours to update your data and make them visible to you. Your data are automatically exported to BigQuery on regular basis, but the frequency of updates in BigQuery can vary depending on the services you're using.

Note: Google starts exporting the data when you configure the export to BigQuery so you will not be able to see the data previous to the day of configuration.