BigQuery ML and Vertex AI Model Registry

Stay organized with collections Save and categorize content based on your preferences.

BigQuery ML is a Google Cloud service which enables you to create and execute machine learning models in BigQuery ML by using standard SQL queries. With Vertex AI, you can use pre-trained and custom tooling all within a unified platform. When you register your BigQuery ML models with the Vertex AI Model Registry you can manage them alongside your other ML models to easily version, evaluate, and deploy for prediction.

With this integration, you can choose which BigQuery ML models to register to the Vertex AI Model Registry. Once registered, you can deploy your BigQuery ML model to an endpoint for online prediction.

From BigQuery ML you can register:

  • BigQuery ML built-in models
  • BigQuery ML TensorFlow models

At this time BigQuery ML XGboost and ARIMA_PLUS models can be registered in Vertex AI Model Registry but not deployed.

To learn how to integrate your BigQuery ML models with Vertex AI Model Registry see BigQuery ML and Vertex AI Model Registry.

Notebook for Vertex AI Model Registry and BigQuery ML

This Notebook, describes how to use Vertex AI Model Registry and BigQuery ML to deploy and make predictions on your models.

This tutorial uses the following Google Cloud ML services and resources:

  • Vertex AI model
  • Vertex AI Model Registry resources
  • Vertex AI endpoint resources
  • Vertex AI Prediction
  • BigQuery ML

The steps performed include:

  • Train a new model using BigQuery ML.
  • Upload the model to Vertex AI Model Registry
  • Create a Vertex AI endpoint resource
  • Deploy the model resource to the endpoint resource.
  • Make prediction requests to the model endpoint.