Registering Vertex AI Remote Models in BigQuery

What BigQuery Remote Model DDL Is

A remote model in BigQuery ML acts as a reference to a machine learning model or service hosted outside BigQuery's native execution engine, such as a foundation model deployed on Vertex AI or a Cloud AI service. Defining a remote model allows SQL developers and data analysts to run inference directly against powerful external models using standard BigQuery SQL statements without extracting data or writing bespoke Python client code.

How It Meets the Requirements

• Remote model declaration (✓): Uses the standard syntax CREATE OR REPLACE MODEL followed by the dataset and model resource name.
• Connection clause (✓): Explicitly specifies REMOTE WITH CONNECTION paired with the fully qualified connection path (my_project.us.my_connection), allowing BigQuery to use the connection's delegated service account credentials.
• Target model specification (✓): The OPTIONS clause specifies the ENDPOINT (or model name) pointing to the corresponding Vertex AI service endpoint in the designated location.

Key Advantages and Capabilities

• Zero data processing costs during creation: Creating a remote model metadata definition processes 0 bytes in BigQuery and incurs no query compute costs.
• Unified governance: Access to Vertex AI is mediated through a single delegated BigQuery Cloud resource connection service account rather than managing individual user keys.
• In-place SQL inference: Once defined, users can invoke the remote model directly inside SQL queries using functions like ML.GENERATE_TEXT or ML.PREDICT.
• Cross-region compatibility: Supports regional and multi-regional datasets pointing to Vertex AI regional endpoints.

Why This Is Optimal

This statement uses the exact GoogleSQL DDL syntax designed for registering external and remote models. It encapsulates the connection identifier and target endpoint parameters cleanly within the standard REMOTE WITH CONNECTION definition.