Preprocess and stage the data in BigQuery prior to feeding it to the model during training and inference.

Use the TRANSFORM clause in the CREATE MODEL statement in the SQL query to calculate the required statistics.

Create a component in the Vertex AI Pipelines directed acyclic graph (DAG) to calculate the required statistics, and pass the statistics on to subsequent components.

Create SQL queries to calculate and store the required statistics in separate BigQuery tables that are referenced in the CREATE MODEL statement.