AI_AskLLM Syntax | Teradata Vantage - AI_AskLLM Syntax - Teradata Analytics

Teradata® Text Analytics AI Functions

Product
Teradata Analytics
Release Number
20.00
Published
July 2026
ft:locale
en-US
ft:lastEdition
2026-07-10
dita:mapPath
foa1783708212383.ditamap
dita:ditavalPath
jlp1749501702948.ditaval
dita:id
foa1783708212383
TD_SYSFNLIB.AI_AskLLM(   
  ON question AS InputTable partition by key
  ON context_data AS ContextTable partition by key 
  USING 
    TextColumn('text_data')  
    { Azure_CSP_LLM_arguments | AWS_Bedrock_CSP_LLM_arguments | Google_Gemini_LLM_arguments | NVIDIA_NIM_Arguments | Lite_LLM_Arguments | AUTHORIZATION([DatabaseName]AuthorizationObjectName) }
    ContextColumn('text_data')
    Prompt('Provide an answer to the question using data as information relevant to the question. \nQuestion: #QUESTION# \n Data: #DATA#')
    DATAPOSITION('#DATA#')
    QUESTIONPOSITION('#QUESTION#')
    [ isDebug('true') ]
    [ Accumulate('[0:]') ]
	[ShowNumTokens('true,false,yes,no,0,1,t,f')]
	[RefreshCredentialTimeSeconds('0')]
)
TD_SYSFNLIB.AI_AskLLM(   
  ON question AS InputTable partition by key
  ON context_data AS ContextTable partition by key 
  USING 
    TextColumn('text_data')  
    { Azure_CSP_LLM_arguments | AWS_Bedrock_CSP_LLM_arguments | Google_Gemini_LLM_arguments | NVIDIA_NIM_Arguments | AUTHORIZATION([DatabaseName]AuthorizationObjectName) }
    ContextColumn('text_data')
    Prompt('Provide an answer to the question using data as information relevant to the question. \nQuestion: #QUESTION# \n Data: #DATA#')
    DATAPOSITION('#DATA#')
    QUESTIONPOSITION('#QUESTION#')
    [ isDebug('true') ]
    [ Accumulate('[0:]') ]
)