Categories:

String & binary functions (Large Language Model)

EXTRACT_ANSWER (SNOWFLAKE.CORTEX)¶

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 requirements¶

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