Source
AI_COUNT_TOKENS
AI_COUNT_TOKENS is the updated version of COUNT_TOKENS (SNOWFLAKE.CORTEX). For the latest functionality, use AI_COUNT_TOKENS. Returns the number of tokens in a prompt for the specified large language model or task - specific function.
AI_SUMMARIZE_AGG
Summarizes a column of text data. For example, AI_SUMMARIZE_AGG(churn_reason) will return a summary of the churn_reason column. Unlike AI_COMPLETE and SUMMARIZE (SNOWFLAKE.CORTEX), this function supports datasets larger than the maximum…
AI_AGG
Reduces a column of text data using a natural language instruction. For example, AI_AGG(reviews, 'Describe the most common complaints mentioned in the book reviews') will return a summary of user feedback.
Extract information with Document AI
Feature — Generally Available Available to accounts in AWS, Microsoft Azure, and Google Cloud commercial regions, with some exceptions.
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.
AI_TRANSCRIBE
Transcribes text from an audio file with optional timestamps and speaker labels. AI_TRANSCRIBE supports numerous languages, and audio can contain more than one language. Timestamps and speaker labels are extracted based on the specified…
AI_COMPLETE (Single string)
Generates a response (completion) for a text prompt using a supported language model. Syntax The function contains two required arguments and four optional arguments. The function can be used with either positional or named argument…
AI_SENTIMENT
AI_SENTIMENT is the updated version of ENTITY_SENTIMENT (SNOWFLAKE.CORTEX). For the latest functionality, use AI_SENTIMENT. Returns overall and category sentiment in the given input text.
AI_CLASSIFY
AI_CLASSIFY is the updated version of CLASSIFY_TEXT (SNOWFLAKE.CORTEX). For the latest functionality, use AI_CLASSIFY. Classifies text or images into categories that you specify.
AI_COMPLETE (Prompt object)
Generates a response (completion) for a prompt object. The prompt object references one or more columns containing text or image data. Syntax The function can be used with either positional or named argument syntax.