Categories:: String & binary functions (AI Functions) , File functions (AI Functions)

AI_COMPLETE¶

Note

AI_COMPLETE is the updated version of COMPLETE (SNOWFLAKE.CORTEX). For the latest functionality, use AI_COMPLETE.

Generates a response (completion) from text or an image 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:

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

Refer to Snowflake AI and ML for legal notices.

Snowflake Cortex functions do not support dynamic tables.