≈481 tokens on demand. Your agent reads this file only when SKILL.md points to it.
BigQuery AI.Score
The AI.SCORE function is commonly used with the ORDER BY clause and works well
when you want to rank items. The following are common use cases:
- Retail: Find the top 5 most negative customer reviews about a product.
- Hiring: Find the top 10 resumes that appear most qualified for a job post.
- Customer success: Find the top 20 best customer support interactions.
Syntax Reference
AI.SCORE(
[ prompt => ] 'PROMPT'
[, connection_id => 'CONNECTION_ID' ]
[, endpoint => 'ENDPOINT' ]
)
Input Arguments
| Argument |
Requirement |
Type |
Description |
prompt |
Required |
String/Struct |
The prompt text or a |
| : : : : struct/tuple of : |
|
|
|
: : : : (data, instruction). : |
|
|
|
connection_id |
Optional |
String |
The connection ID to |
| : : : : use for the LLM. : |
|
|
|
endpoint |
Optional |
String |
The model endpoint |
| : : : : (e.g. : |
|
|
|
: : : : 'gemini-2.5-flash'). : |
|
|
|
Output Schema
| Column Name |
Type |
Description |
| (Scalar Result) |
FLOAT64 |
A numerical score representing the degree |
| : : : to which the data matches the instruction. : |
|
|
Examples
Rank rows by semantic relevance
SELECT *
FROM `dataset.table`
ORDER BY AI.SCORE(
(content_column, 'relevance to sports'),
connection_id => 'my-project.us.my-connection'
) DESC
LIMIT 10;
