Oct 16, 2025: AI_EXTRACT AISQL function (General availability)¶
The Snowflake AISQL AI_EXTRACT function lets you extract information from text or document files using large language models.
This release adds the following features to the existing AI_EXTRACT capabilities:
Table extraction support: Extract tabular data from documents, which helps you analyze financial reports, data sheets, invoices, and other documents that contain tabular data.
Flexible response formats: Define the response format using simple object schemas, arrays of questions, or JSON schemas that support both entity and table extraction.
Contextual guidance: Provide context to the model using the optional
description
field; for example, to help the model localize the correct table in a document.Output length: The maximum output length for entity extraction is 512 tokens per question. For table extraction, the model returns answers that are a maximum of 4096 tokens long.
For more information, see AI_EXTRACT.