Generate a SQL query to BigQuery from your Cloud Billing Reports (in preview)

## Feature **Generate a SQL query to BigQuery from your Cloud Billing Reports (in preview)** In the cloud console, on the Billing **Reports** page, you use the [report settings and filters](https://cloud.google.com/billing/docs/how-to/reports#filtering%5Fand%5Fgrouping) to refine the data returned to your report. If you have enabled [**Cloud Billing data export to BigQuery**](https://cloud.google.com/billing/docs/how-to/export-data-bigquery), you can analyze your[exported billing data](https://cloud.google.com/billing/docs/how-to/export-data-bigquery-tables) using SQL queries. In Billing Reports, you can now click a button to [**generate a SQL query**](https://cloud.google.com/billing/docs/how-to/reports#generate-query) in BigQuery that is configured to use the equivalent Billing Report settings and filters to query your exported billing data. When run against your exported billing data, the generated query returns the _equivalent results_ in BigQuery as the results in the Billing Report. * [Learn more about Billing Reports](https://cloud.google.com/billing/docs/how-to/reports) * [Learn more about Billing data export to BigQuery](https://cloud.google.com/billing/docs/how-to/export-data-bigquery) * [Learn more about generating a SQL query from a billing report](https://cloud.google.com/billing/docs/how-to/reports#generate-query)