For BigQuery ML (BQML), the following components are now available:
BigQuery ML
Category
Component
Description
Core
BigqueryCreateModelJobOp
Allow users to submit a DDL statement to create a BigQuery ML model.
BigqueryEvaluateModelJobOp
Allows users to evaluate a BigQuery ML model.
BigqueryPredictModelJobOp
Allows users to make predictions using a BigQuery ML model.
BigqueryExportModelJobOp
Allows users to export a BigQuery ML model to a Google Cloud Storage bucket
New Components
Forecasting
BigqueryForecastModelJobOp
Launches a BigQuery ML.FORECAST job and lets you forecast an ARIMA_PLUS or ARIMA model.
BigqueryExplainForecastModelJobOp
Launches a BigQuery ML.EXPLAIN_FORECAST job and let you forecast an ARIMA_PLUS or ARIMA model
BigqueryMLArimaEvaluateJobOp
Launches a BigQuery ML.ARIMA_EVALUATE job and waits for it to finish.
Anomaly
Detection
BigqueryDetectAnomaliesModelJobOp
Launches a BigQuery detect anomaly model job and waits for it to finish.
Model Evaluation
BigqueryMLConfusionMatrixJobOp
Launches a BigQuery confusion matrix job and waits for it to finish.
BigqueryMLCentroidsJobOp
Launches a BigQuery ML.CENTROIDS job and waits for it to finish
BigqueryMLTrainingInfoJobOp
Launches a BigQuery ml training info fetching job and waits for it to finish.
BigqueryMLTrialInfoJobOp
Launches a BigQuery ml trial info job and waits for it to finish.
BigqueryMLRocCurveJobOp
Launches a BigQuery roc curve job and waits for it to finish.
Explainable AI
BigqueryMLGlobalExplainJobOp
Launches a BigQuery global explain fetching job and waits for it to finish.
BigqueryMLFeatureInfoJobOp
Launches a BigQuery feature info job and waits for it to finish.
BigqueryMLFeatureImportanceJobOp
Launches a BigQuery feature importance fetch job and waits for it to finish.
Model Weights
BigqueryMLWeightsJobOp
Launches a BigQuery ml weights job and waits for it to finish.
BigqueryMLAdvancedWeightsJobOp
Launches a BigQuery ml advanced weights job and waits for it to finish.
BigqueryMLPrincipalComponentsJobOp
Launches a BigQuery ML.PRINCIPAL_COMPONENTS job and waits for it to finish.
BigqueryMLPrincipalComponentInfoJobOp
Launches a BigQuery ML.principal_component_info job and waits for it to finish.
BigqueryMLArimaCoefficientsJobOp
Launches a BigQuery ML.ARIMA_COEFFICIENTS job and lets you see the ARIMA coefficients.
Model Inference
BigqueryMLReconstructionLossJobOp
Launches a BigQuery ML reconstruction loss job and waits for it to finish.
BigqueryExplainPredictModelJobOp
Launches a BigQuery explain predict model job and waits for it to finish
BigqueryMLRecommendJobOp
Launches a BigQuery ML.Recommend job and waits for it to finish.
Other
BigqueryDropModelJobOp
Launches a BigQuery drop model job and waits for it to finish.
Now that you have a broad overview of all pipeline operators for BQML available, let’s see how to use forecasting ones in the end-to-end example of building demand forecast predictions. You will find the code in the Vertex AI samples repo on Github.
Example of a demand forecast predictions pipeline in BigQuery ML
In this section, we’ll show an end-to-end example of using BigQuery and BQML components in a Vertex AI Pipeline for demand forecasting. The pipeline is based on the solving for food waste with data analytics blog post. In this scenario, a fictitious grocer, FastFresh, specialized in selling fresh food distribution, wants to minimize food waste and optimize stock levels across all stores. Due to the frequency of inventory updates (by minute of every single item), they want to train a demand forecasting model on an hourly basis. With 24 training jobs per day, they want to automate model training using an ML pipeline using pipeline operators for BQML ARIMA_PLUS, the forecasting model type in BQML.
Below you can see a high level picture of the pipeline flow