Categories:

String & binary functions (AI Functions)

EXTRACT_ANSWER (SNOWFLAKE.CORTEX)

Notice

This page is provided for backward compatibility. For new use cases, start with %aisql-new-func-link%, which is the canonical surface going forward. This legacy function will be deprecated by the end of 2026.

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>)

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 Cortex LLM privileges for more information on granting this privilege.

Refer to Snowflake AI and ML.