AI_COMPLETE

1
SELECT SNOWFLAKE.CORTEX.COMPLETE(
2
  'mistral-large',
3
  'Summarize this text in one sentence: ' || article_text
4
) as summary
5
FROM articles;

1
SELECT SNOWFLAKE.CORTEX.COMPLETE(
2
  'llama3-70b',
3
  'Translate to Indonesian: Hello, how are you?',
4
  {'temperature': 0.3, 'max_tokens': 100}
5
) as translation;

1
SELECT SNOWFLAKE.CORTEX.COMPLETE(
2
  'mixtral-8x7b',
3
  'Context: ' || product_description ||
4
  '
5
 
6
Question: What are the key features?'
7
) as answer
8
FROM products;