BigQuery billing Export dataset table not exporting the data

[venkatesh314]

Hello everyone

From 1st july onwards the Bigquery not exporting billing data in dataset has stopped.but in Activity dashboard it shows updated table.but in my dataset it showing last modified 1st july...i didn't understand why it is stopped.

reffer the follwing screenshots 

[lsolatorio]

Hi @venkatesh314,

There are few possible reasons why BigQuery stopped exporting your billing data.

Here are some things to look into:

1. The Cloud Billing export must be kept enabled for your project
2. The BigQuery dataset must be configured correctly, it should be in the same region as the Cloud Billing account that you are exporting data from
3. The schema for the BigQuery table should be matched with the schema for the Cloud Billing export data
4. Make sure that your dataset and exported data are still within the BigQuery quota and limits 

For further troubleshooting, you can also check your Cloud Billing export logs to see if there are any errors, try restarting the export job, try changing your dataset location or create a new BigQuery table with the right schema configuration.

In case all of these items are checked and the data is still not exporting, you can contact Google Cloud support for help.

I hope this helps.

Usable resources:
 - Export Cloud Billing data to BigQuery
 - Limitations | Export Cloud Billing data to BigQuery
 - Export Jobs | BigQuery Quotas and limits