Standard ai_extract mode now delivers higher quality and speed

Use cases

Imagine you need to extract structured data from invoices, contracts, and financial documents at scale using SQL. With the updated default mode for ai_extract, you can:

• Process documents faster.
• Achieve higher extraction quality.
• Keep costs flat while using the updated model checkpoint.

How to use

Run the ai_extract function passing the text content and your desired schema in a SQL query.

SELECT ai_extract(
  'Invoice #12345 from Acme Corp for $1,250.00 dated 2024-01-15',
  '["invoice_id", "vendor_name", "total_amount", "invoice_date"]',
  options => map('version', '2.1')
);

What happens in this code:

1. The invoice text is provided as the first argument.
2. A simple JSON schema defines the fields to extract.
3. The version option specifies the recommended interface version.

Limitations and requirements

• Available in Databricks SQL and Databricks Runtime.
• Requires Databricks Runtime 15.4 LTS or above (18.2 recommended).
• Not available on Databricks SQL Classic.