Skip to main content

AI

Function NameDescription
AI_GENERATEFlexible general-purpose function for processing unstructured data, primarily used for complex data extraction requiring multiple fields from source files.
AI_CLASSIFYSpecialized form of AI_GENERATE for sentiment analysis and document categorization, returned as VARCHAR, INT, FLOAT or BOOLEAN. Classification list provided to LLM as an Array of VARCHAR, INT, FLOAT or BOOLEAN.
AI_COMPLETESpecialized form of AI_GENERATE for creative text generation and summaries, returned as VARCHAR.
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.