An engineer wants to export billing cost data to BigQuery for custom reporting. They have created a BigQuery dataset and linked it to the billing account. However, the billing export tables are not being populated. What is the most likely cause?
Trap 1: The billing export has not been enabled in the Cloud Console
Export is enabled when the dataset is linked; tables should populate after a few hours.
Trap 2: The engineer does not have the Billing Administrator IAM role
Billing Account Administrator is needed to set up export, but the engineer already linked the dataset, so permissions are likely sufficient.
Trap 3: The billing account is not linked to the project containing the…
Linking is required, but the issue is dataset location.
- A
The billing export has not been enabled in the Cloud Console
Why it fails: Export is enabled when the dataset is linked; tables should populate after a few hours.
- B
The engineer does not have the Billing Administrator IAM role
Why it fails: Billing Account Administrator is needed to set up export, but the engineer already linked the dataset, so permissions are likely sufficient.
- C
The BigQuery dataset is in a different location from the billing account's default region
Billing export requires the dataset to be in the same multi-regional location (US or EU) as the billing account.
- D
The billing account is not linked to the project containing the BigQuery dataset
Why it fails: Linking is required, but the issue is dataset location.