AI_EXTRACT_ANSWER

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;