Release notes

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

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

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.