This page provides an overview of Spanner Vertex AI integration.
Spanner Vertex AI integration helps you to access classifier and regression ML models hosted on Vertex AI through the GoogleSQL interface. This helps to seamlessly integrate ML predictions serving functionality with general Cloud Spanner data access operations performed using DQL/DML queries.
Spanner Vertex AI integration shares the same SQL syntax with BigQuery ML, even though only a subset of BigQuery ML syntax is supported.
Benefits of Spanner Vertex AI integration
Generating ML predictions using Spanner Vertex AI integration provides multiple benefits compared to the approach where Cloud Spanner data access and access to the Vertex AI prediction endpoint are performed separately:
- Better latency: Spanner Vertex AI integration talking to the Vertex AI service directly eliminates additional round-trips between a compute node running a Cloud Spanner's client and the Vertex AI service.
- Better throughput/parallelism: Spanner Vertex AI integration runs on top of Cloud Spanner's distributed query processing infrastructure, which supports highly parallelizable query execution.
- User experience:
- Ability to use a single, simple, coherent, and familiar SQL interface to facilitate both data transformation and ML serving scenarios on Cloud Spanner level of scale lowers the ML entry barrier and allows for a much smoother user experience.
- Spanner Vertex AI integration uses Cloud Spanner compute capacity to merge the results of ML computations and SQL query execution, which eliminates the need to provision an additional compute (for example, in Compute Engine or Google Kubernetes Engine) for that.
How does Spanner Vertex AI integration work?
Spanner Vertex AI integration doesn't host ML models, but relies on the Vertex AI service infrastructure instead. For a model to be used with Spanner Vertex AI integration, it should be already trained and deployed to Vertex AI.
Spanner Vertex AI integration also doesn't provide any special ML training functionality. To train models on data stored in Cloud Spanner, you can use either of the following:
BigQuery Federated queries together with BigQuery ML.
Dataflow to export data from Cloud Spanner into CSV format and import the CSV data source into Vertex AI.
As soon as a model is deployed in the Vertex AI service, a database owner can
register this model using the
CREATE MODEL DDL statement. After
that, the model can be referenced from the ML.PREDICT functions
to produce predictions.
See Generate ML predictions using SQL for a tutorial on using Spanner Vertex AI integration.
There are no additional charges from Cloud Spanner for use of Spanner Vertex AI integration. However, there are other potential charges associated with this feature:
You pay the standard rates for Vertex AI online prediction. The total charge depends on the model type you use. Some model types have a flat per hour rate, depending on the machine type and number of nodes that you use. Some model types have per call rates. We recommend you deploy the latter in a dedicated project where you have set explicit prediction quotas.
You pay the standard rates for network egress between Cloud Spanner and Vertex AI. The total charge depends on the region hosting the server executing the query and the region hosting the called endpoint. To minimize charges, deploy your Vertex AI endpoints in the same region as your Cloud Spanner instance. When using multi-regional instance configurations or multiple Vertex AI endpoints, deploy your endpoints on the same continent.
Due to Vertex AI online prediction availability being lower, you must properly configure Cloud Spanner ML models to maintain Cloud Spanner's high availability while using Spanner Vertex AI integration:
- Cloud Spanner ML models must use multiple Vertex AI endpoints on the backend to enable failover.
- Vertex AI endpoints must conform to the Vertex AI SLA.
- Vertex AI endpoints must provision enough capacity to handle incoming traffic.
- Vertex AI endpoints must use separate regions close to the Cloud Spanner database to avoid regional outages.
- Vertex AI endpoints should use separate projects to avoid issues with per-project prediction quotas.
The number of redundant Vertex AI endpoints depends on their SLA, and the number of rows in Cloud Spanner queries:
|Spanner SLA||VertexAI SLA||1 row||10 rows||100 rows||1000 rows|
Vertex AI endpoints don't need to host exactly the same model. We recommend that you configure the Cloud Spanner ML model to have a primary, complex and compute intensive model as its first endpoint. Subsequent failover endpoints can point to simplified models that are less compute intensive, scale better and can absorb traffic spikes.