Categories:: String & binary functions (Large Language Model)

AI_COMPLETE¶

Note

When AI_COMPLETE becomes Generally Available, it will replace COMPLETE (SNOWFLAKE.CORTEX). Use AI_COMPLETE in preview to try out the latest functionality. Snowflake does not recommend using preview functions with production workloads.

Generates a response (completion) using a supported language model. You can provide:

A text prompt, to generate a response from the model. For more information, see AI_COMPLETE (Single string).
A single image and a text prompt, to generate a response based on the image and prompt. For more information, see AI_COMPLETE (Single image).
A prompt object that can support multiple images and text. For more information, see AI_COMPLETE (Prompt object).

Syntax¶

The syntax for the function depends on the type of input that you provide. For information about the syntax, see the following sections:

Access control requirements¶

Users must use a role that has been granted the SNOWFLAKE.CORTEX_USER database role. See Required privileges for more information on this privilege.

Legal notices¶

Refer to Snowflake AI and ML for legal notices.

Limitations¶

Snowflake Cortex functions do not support dynamic tables.