- Categories:
String & binary functions (AI) , File functions (AI)
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:
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.