surfaceextractionparse_phone_llm
Extractionscalar · returns json

PARSE_PHONE_LLM

LLM-backed phone parsing (escape hatch for PARSE_PHONE)

Per-row — runs once for each row.

extractionllmllm-escape-hatchtext

Syntax

PARSE_PHONE_LLM({{ phone }})
PARSE_PHONE_LLM({{ phone }}, '{{ default_country }}')

Arguments

nametypedescription
phoneVARCHAR
default_country(optional)VARCHAR

About

LLM-backed escape hatch for phone number parsing. Use when the canonical `phonenumbers` path (PARSE_PHONE) can't help — typically heavily mangled input or vanity numbers like "1-800-FLOWERS" where the LLM can interpret the letters. For standard input, prefer PARSE_PHONE — it uses Google's official phone number library, knows every country's numbering plan, and is much faster.

Examples

LLM escape hatch extracts phone from text

SELECT
  parse_phone_llm ('Call me at (555) 123-4567')

Nearby rabbit holes

same domain
Climb back to The Looking Glass