AI_EXTRACT_ANSWER

Snowflake

Mengekstrak jawaban dari teks berdasarkan pertanyaan yang diberikan.

Tipe hasil: OBJECT (answer dan score)Diperbarui: 6 Jan 2026

Syntax

SQL

SNOWFLAKE.CORTEX.EXTRACT_ANSWER(context, question)

Parameter

contextVARCHARwajib

Teks yang berisi informasi

questionVARCHARwajib

Pertanyaan yang ingin dijawab

Contoh Penggunaan

Extract Information

SQL

1 SELECT SNOWFLAKE.CORTEX.EXTRACT_ANSWER(
2   'John Smith is the CEO of Acme Corp. The company was founded in 2015 and has 500 employees.',
3   'Who is the CEO?'
4 ) as result;

Ekstrak jawaban dari teks.

Hasil

{"answer": "John Smith", "score": 0.95}

Document Q&A

SQL

1 SELECT
2   doc_title,
3   SNOWFLAKE.CORTEX.EXTRACT_ANSWER(
4     doc_content,
5     'What is the return policy?'
6   ):answer as return_policy
7 FROM policy_documents;

Extract info dari dokumen.

Kembali ke Snowflake Functions

1	SELECT SNOWFLAKE.CORTEX.EXTRACT_ANSWER(
2	'John Smith is the CEO of Acme Corp. The company was founded in 2015 and has 500 employees.',
3	'Who is the CEO?'
4	) as result;

1	SELECT
2	doc_title,
3	SNOWFLAKE.CORTEX.EXTRACT_ANSWER(
4	doc_content,
5	'What is the return policy?'
6	):answer as return_policy
7	FROM policy_documents;