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:

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.

Limitations¶

Snowflake Cortex functions do not support dynamic tables.