Skip to main content

AI

Function NameDescription
AI_CLASSIFYSpecialized form of AI_GENERATE for sentiment analysis and document categorization. Classification list provided to LLM as an array of VARCHAR, INT, FLOAT or BOOLEAN and the return is of the same type.
AI_COMPLETESpecialized form of AI_GENERATE for creative text generation and summaries, returned as VARCHAR.
AI_GENERATEFlexible general-purpose function for processing unstructured data, primarily used for complex data extraction requiring multiple fields from source files.
LIST_FILESLists files recursively from a source directory, adhering to the COPY INTO security model. Returns structured information about each file for use with AI functions and data processing workflows.