When you use BigQuery BI Engine, your charges are based on the BI Engine capacity you purchased for your project. There are two ways to purchase BI Engine capacity:
- Purchasing capacity on-demand
- Bundling BI Engine capacity when you enroll in BigQuery flat-rate pricing
BI Engine stores BigQuery metadata and table data in memory. The amount of data stored is constrained by the amount of capacity you purchase. When you run a query that retrieves results from data that is stored in BI Engine, you are not charged for reading the data.
If you run a query that produces query results larger than the size of your BI Engine capacity, the BI Engine self-tuning feature uses BigQuery slots to run the query. When BigQuery slots are used to run a query, you are charged based on BigQuery on-demand query pricing for the query job. When slots are used to run a query, all BigQuery quotas and limits on query jobs apply.
On-demand capacity pricing
BI Engine on-demand capacity pricing is as follows:
Flat-rate capacity pricing
BigQuery offers flat-rate pricing for high-volume or enterprise customers who prefer a stable monthly cost for queries rather than paying the on-demand price per GB of data processed. If you enroll in BigQuery flat-rate pricing, the cost of your BI Engine capacity is bundled in the monthly flat-rate price.
For more information on BigQuery flat-rate pricing, see the BigQuery Pricing page.
BI Engine capacity is bundled with your flat rate plan at no additional cost as shown in the following table.
|Number of slots||Bundled BI Engine capacity (GB)|
You can bundle a maximum of 100 GB of BI Engine capacity. If you need more than 100 GB of capacity, it must be purchased at the on-demand rate.