BigQuery added two AI functions this autumn that bring document and language work into plain SQL: AI.TRANSLATE became generally available on 22 October 2026, and AI.PARSE_DOCUMENT on 2 November.
What's new
- AI.PARSE_DOCUMENT: uses Document AI's layout parser to pull titles, headings, paragraphs, lists, tables and images out of documents and return them as structured JSON.
- AI.TRANSLATE: translates text between languages, using either standard neural machine translation or a translation LLM.
Is BigQuery costing more than it should?
We review your queries, storage, slots and cost controls, then give you quick wins and a plan.
Why it matters for your business
Many businesses keep their most useful information in PDFs: invoices, contracts, reports and forms. Parsing them where the rest of your data already lives means fewer separate tools and fewer copies of sensitive files. Translation in SQL helps any team working with customers, reviews or support tickets in more than one language.
How D3V can help
- We build document pipelines that read and extract data from unstructured files (AI & automation).
- A free data assessment to see what's possible with the data you already have.
- Our free BigQuery health check keeps costs in check as you add AI functions.
Source: BigQuery release notes, Google Cloud.
