AI_COMPLETE

Snowflake

Menggunakan Large Language Model untuk generate text completion berdasarkan prompt.

Tipe hasil: VARCHARDiperbarui: 6 Jan 2026

Syntax

SQL

SNOWFLAKE.CORTEX.COMPLETE(model, prompt [, options])

Parameter

modelVARCHARwajib

Nama model: 'mistral-large', 'llama3-70b', 'mixtral-8x7b', dll

promptVARCHARwajib

Prompt atau instruction untuk model

optionsOBJECTopsional

Opsi: temperature, max_tokens, top_p

Contoh Penggunaan

Text Completion

SQL

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

Summarize article menggunakan AI.

With Options

SQL

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;

Translation dengan temperature rendah.

Q&A from Context

SQL

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;

Ekstrak informasi dari teks.

Kembali ke Snowflake Functions

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;