Categories:

String & Binary Functions (Large Language Model)

EXTRACT_ANSWER (SNOWFLAKE.CORTEX)

Fully qualified name: SNOWFLAKE.CORTEX.EXTRACT_ANSWER

Extracts an answer to a given question from a text document. The document may be a plain-English document or a string representation of a semi-structured (JSON) data object.

Syntax

SNOWFLAKE.CORTEX.EXTRACT_ANSWER(
    <source_document>, <question>)
Copy

Arguments

source_document

A string containing the plain-text or JSON document that contains the answer to the question.

question

A string containing the question to be answered.

Returns

A string containing an answer to the given question.

Access Control

Users must use a role that has been granted the SNOWFLAKE.CORTEX_USER database role. See Required Privileges for more information on granting this privilege.

Example

In this example, review_content is a column from the reviews table:. To extract an answer from each row of the table:

SELECT SNOWFLAKE.CORTEX.EXTRACT_ANSWER(review_content,
    'What dishes does this review mention?')
FROM reviews LIMIT 10;
Copy