Google previews ai.classify and ai.extract SQL functions for AlloyDB AI
Overview
Google announces the preview of two SQL functions, ai.classify and ai.extract, in AlloyDB AI. ai.classify assigns text to one or more user-defined categories, and ai.extract turns unstructured text into JSON that matches a target schema.
Both run inside the database using standard SQL.
The functions require version 1.6.1 or later of the google_ml_integration extension and PostgreSQL 18. Google says smart batching groups inputs into micro-batches when queries run.
Written by AI from the articles below · updated Nov 11, 12:29 PM ET
Check the sources:
Article timeline
The articles in this story. Times are ET.
- Google Cloud · AI & Machine LearningOfficialGoogle previews ai.classify and ai.extract SQL functions for AlloyDB AI
AIGoogle announces the preview of two SQL functions, ai.classify and ai.extract, in AlloyDB AI, available in the google_ml_integration extension version 1.6.1 or later on PostgreSQL 18. ai.classify assigns text to single or multiple user-defined categories, and ai.extract turns unstructured text into JSON matching a target schema. The functions run inside the database with standard SQL, and smart batching groups inputs into micro-batches for queries.
Heat Trend
- Current comparable heat
- 6
- Peak comparable heat
- 10Nov 11, 1:00 PM ET
- Change in past 24 hours
- –
The trend compares only continuously observed participants, so its scope may be smaller than the current heat total. Hover or tap for hourly heat; use arrow keys with a keyboard.