Always free usage limits
As part of the Google Cloud Platform Free Tier, BigQuery offers some resources free of charge up to a specific limit. These free usage limits are available during and after the free trial period. If you go over these usage limits and are no longer in the free trial period, you will be charged according to the pricing on this page.
|Resource||Monthly Free Usage Limits||Details|
|Storage||The first 10 GB per month is free.||BigQuery ML models and training data stored in BigQuery are included in the BigQuery storage free tier.|
|Queries (analysis)||The first 1 TB of query data processed per month is free.||Queries that use BigQuery ML prediction, inspection, and evaluation
functions are included in the BigQuery analysis free tier.
BigQuery ML queries
BigQuery flat-rate pricing is also available for high-volume customers that prefer a stable, monthly cost.
||The first 10 GB of data processed by queries that contain
BigQuery ML pricing
BigQuery ML pricing applies to all currently supported models. BigQuery ML pricing is based on your usage pattern: flat-rate or on-demand.
BigQuery ML flat-rate pricing
BigQuery offers flat-rate pricing for high-volume or enterprise customers who prefer a stable monthly cost rather than paying the on-demand price for model creation, evaluation, inspection, and prediction.
Currently, there are no additional flat-rate charges for BigQuery ML. If you choose flat-rate pricing, BigQuery ML costs are included in the monthly BigQuery flat-rate price until December 31, 2019.
BigQuery ML on-demand pricing
BigQuery ML pricing for on-demand queries depends on the type of operation: model creation, model evaluation, model inspection, or model prediction.
BigQuery ML on-demand pricing is as follows:
|Model creation||Limited to 50 iterations.
The first 10 GB of data processed by
|Evaluation, inspection, and prediction||Charges from evaluation, inspection, and prediction queries
are included in the 1 TB of data per month under the
BigQuery analysis free tier.
If you pay in a currency other than USD, the prices listed in your currency on Cloud Platform SKUs apply.
BigQuery ML pricing example
BigQuery ML charges are not itemized separately on your billing statement. If you have a BigQuery flat-rate plan, BigQuery ML charges are included in your flat-rate charges until December 31, 2019.
If you are using on-demand pricing, BigQuery ML charges are included in the BigQuery analysis (query) charges.
BigQuery ML jobs that perform inspection, evaluation, and prediction
operations incur the same charges as on-demand query jobs. Because
queries incur different charges, you must calculate
CREATE MODEL job costs
independently by using the Stackdriver audit logs. Using the audit logs, you can
determine the bytes billed by the BigQuery ML service for each BigQuery ML
CREATE MODEL job. Then, multiply the bytes billed by the appropriate cost for
CREATE MODEL queries in your regional or multi-regional location.
For example, to determine the cost of a query job in the
US that includes a
CREATE MODEL statement:
Open the Stackdriver Logging page in the GCP console.
Verify that the product is set to BigQuery.
Click the drop-down arrow in the "Filter by label or text search" box and choose Convert to advanced filter. This adds the following text to the filter:
Add the following text on line two below the
To the right of the Submit Filter button, choose the appropriate time frame from the drop-down list. For example, choosing Last 24 hours would display BigQuery ML
CREATE MODELjobs completed in the past 24 hours.
Click Submit Filter to display the jobs completed in the given time window.
After the data is populated, click View Options and choose Modify custom fields.
In the Add custom fields dialog, enter:
Click Save to update the results.
After the page is updated, the bytes billed by each BigQuery ML job appear to the right of the job's timestamp. If the bytes billed are included in the free tier, no value appears. For example:
To calculate the charges for the BigQuery ML
CREATE MODELjob, multiply the bytes billed by the BigQuery ML on-demand price. In this example, the
CREATE MODELjob processed 100873011200 bytes. To calculate the cost of this job in the
USmulti-regional location, divide the billed bytes by the number of bytes per TB, and multiply it by the model creation cost:
100873011200/1099511627776 x $250.00 = $22.94