surfaceextractionparse_address_llm
Extractionscalar · returns json

PARSE_ADDRESS_LLM

LLM-backed address parsing (escape hatch for PARSE_ADDRESS)

Per-row — runs once for each row.

extractionllmllm-escape-hatchtext

Syntax

PARSE_ADDRESS_LLM({{ address }})

Arguments

nametypedescription
addressVARCHAR

About

LLM-backed escape hatch for address parsing. Use when the canonical `usaddress` path (PARSE_ADDRESS) falls short — typically international addresses, unusual formats, or cases where the LLM's world knowledge about cities and regions helps resolve ambiguity. For US addresses in standard formats, prefer PARSE_ADDRESS — it's faster and deterministic.

Examples

LLM escape hatch handles international addresses

SELECT
  parse_address_llm ('221B Baker Street, London NW1 6XE, UK')

Nearby rabbit holes

same domain
Climb back to The Looking Glass