Source
AI_COMPLETE structured outputs
AI_COMPLETE lets you supply a JSON schema or type literal that completion responses must follow, producing structured output. Structured output reduces the need for post - processing in your AI data pipelines and enables seamless integration…
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_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.
SnowConvert AI - Preview Features Settings
Enter any of the available flags in the textbox to allow SnowConvert AI to use Snowflake preview features. Please be sure that each flag is spelled correctly; if any flag is misspelled, all flags will be ignored during conversion.
AI_FILTER
Classifies free - form prompt inputs into a boolean. Currently supports both text and image filtering.
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.
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.
SnowConvert AI - BigQuery Issues
SnowConvert AI for Google BigQuery currently supports assessment and translation for TABLES and VIEWS. Although SnowConvert AI can recognize other types of statements, they are not fully supported.
SnowConvert AI - Teradata - Built-in Functions
SnowConvert AI - Teradata - Built - in Functions This page provides a description of the translation for the built - in functions in Teradata to Snowflake Note This page only lists the functions that are already transformed by SnowConvert AI,…