How to Store multiple projects cost and usage data to single bigquery.

[Mounika-7]

Hii
How to store  multiple projects cost and usage data which were available  in the same  organization or billing account id in a single big query table of any project of that organization.

[caryna]

Hi @Mounika-7,

Welcome to Google Cloud Community!

From what I understand, you're aiming to centralize billing data from multiple projects into one BigQuery dataset under a single billing account and the same organization.

For you to accomplish this, below are the steps:

1. Select or create your project where you will store your exported Cloud Billing data and ensure if the Billing is enabled. You need to make sure that your project is linked to the same Billing account that you plan to export to BigQuery.
2. Enable your BigQuery Data Transfer Service API.
3. Create your dataset in Bigquery where you will store your data.
4. On the Billing export, select your Billing account and click “Edit Settings” to select the project and the dataset that you set up.
5. Click "Save".

For detailed instructions, refer to this documentation, which provides step-by-step guidance. This also outlines the limitations and required permissions to ensure you have the necessary access to complete this process.

You may also find this YouTube tutorial helpful, as it offers a step-by-step walkthrough on exporting Cloud Billing data to BigQuery.

I hope the above information is helpful.