Source
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
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_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.
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_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_SIMILARITY
Computes a similarity score based on the vector cosine similarity value of the inputs’ embedding vectors. Currently supports both text and image similarity computation.
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_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_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.
AI_EMBED
Creates an embedding vector from text or an image. Embeddings are abstract numerical representations of the features of a piece of text or an image that can be used to determine the degree of similarity between pieces of text or…