Release notes

This page documents production updates to BigQuery ML. We recommend that BigQuery ML developers periodically check this list for any new announcements.

You can see the latest product updates for all of Google Cloud on the Google Cloud release notes page.

To get the latest product updates delivered to you, add the URL of this page to your feed reader, or add the feed URL directly: https://cloud.google.com/feeds/bqml-release-notes.xml

August 06, 2020

BigQuery ML is now available following regions: Oregon (us-west1), Belgium (europe-west1), and Netherlands (europe-west4).

July 15, 2020

Data split and validation options are now available for AutoML Table model training.

July 01, 2020

BigQuery ML now supports time series models as a beta release. For more information, see CREATE MODEL statement for time series models.

June 16, 2020

BigQuery ML now supports beta integration with AI Platform. The following models are supported in beta:

June 08, 2020

BigQuery ML is now available in the Jakarta (asia-southeast2) region.

April 27, 2020

BigQuery ML is now available in the Las Vegas (us-west4) region.

April 22, 2020

BigQuery ML now supports exporting BigQuery ML models to Cloud Storage and using them for online prediction. This feature is in beta. For more information, see Exporting models.

April 17, 2020

BigQuery ML now supports Matrix Factorization models for recommendations, as a beta release. For more information, see The CREATE MODEL statement for Matrix Factorization.

February 24, 2020

BigQuery ML is now available in the Salt Lake City (us-west3) region.

January 24, 2020

BigQuery ML is now available in the Seoul (asia-northeast3) region.

December 19, 2019

BigQuery ML data preprocessing is now Generally Available (GA). Read about the preprocessing functions and walk through how to use the TRANSFORM clause for feature engineering.

December 04, 2019

You can now use KMEANS++ to initialize the clusters of a k-means model. KMEANS++ trains a better model than random cluster initialization.

November 21, 2019

BigQuery ML data preprocessing is now in beta.

BigQuery ML now supports customer-managed encryption keys (CMEK). You can use your own Cloud KMS keys to encrypt ML models.

November 20, 2019

BigQuery ML is now available in the South Carolina (us-east1) region.

September 30, 2019

Importing TensorFlow models is now GA.

September 23, 2019

Support for k-means clustering models is now GA. For more information, see Creating a k-means clustering model.

September 17, 2019

BigQuery ML is now available in the Frankfurt (europe-west3) region.

July 02, 2019

Importing TensorFlow models is now Beta.

May 29, 2019

May 14, 2019

BigQuery ML now supports the DROP MODEL DDL statement for deleting models.

May 06, 2019

BigQuery ML IAM permissions are now available. These permissions take effect on June 6, 2019. Customers with custom roles should migrate to these permissions no later than June 6. Pre-defined IAM roles and primitive roles are not impacted by this change.

April 10, 2019

BigQuery ML now supports the k-means model type for clustering and customer segmentation.

April 04, 2019

During the beta period, Table permissions were automatically applied to models for custom IAM roles. BigQuery ML will begin enforcing several new IAM permissions on June 6, 2019. Customers who used custom IAM roles during the beta period must reconfigure these roles to use the new BigQuery ML permissions. This change will enable you to manage Models permissions separately from BigQuery ML Table permissions. You can begin redefining your custom roles by the end of April, 2019 when the permissions are released. Pre-defined IAM roles and primitive roles are not impacted by this change.

March 18, 2019

BigQuery ML now supports ML.ROC_CURVE and ML.CONFUSION_MATRIX without input data.

The limit on the number of CREATE MODEL queries has increased from 100 to 1,000.

January 29, 2019

BigQuery ML now supports automatic, batch gradient descent, and normal equation optimization strategies for linear regression models.

December 13, 2018

The BigQuery ML ML.WEIGHTS function now supports standardization.

The BigQuery ML ML.PREDICT function now supports thresholds for binary logistic regression models.

November 08, 2018

BigQuery ML pricing is now available.

October 19, 2018

The BigQuery ML CREATE MODEL statement has increased support for unique values in labels from 10 to 50. Multiclass logistic regression models now support up to 50 unique values for labels.

October 11, 2018

When you create a model using the random data split method, the split is now deterministic. Subsequent training runs will produce the same split so long as the underlying input data hasn't changed.

Providing input data to the ML.EVALUATE function is now optional.

September 19, 2018

BigQuery ML is now available in the Tokyo (asia-northeast1) region.

September 13, 2018

July 25, 2018

BigQuery ML is now Beta.