AI_AnalyzeSentiment Examples | Teradata Vantage - Examples: How to Use AI_AnalyzeSentiment - Teradata VantageCloud Lake

Lake - Analyze Your Data with ClearScape Analytics™
Deployment
VantageCloud
Edition
Lake
Product
Teradata VantageCloud Lake
Release Number
Published
February 2025
ft:locale
en-US
ft:lastEdition
2026-02-20
dita:mapPath
tcl1683670667798.ditamap
dita:ditavalPath
pny1626732985837.ditaval
dita:id
tcl1683670667798

Verify the input has been configured. See Text Analytics AI Function Example Input.

AWS Bedrock
SELECT * FROM AI_ANALYZESENTIMENT(   
      ON ta_employee_review AS InputTable
      USING   
      TextColumn('reviews')
      ApiType('aws')
      REGION('us-west-2')
      Authorization(td_gen_aws_auth)
      ModelName('anthropic.claude-v2')
      ModelArgs('{}')
      isDebug('true')
      Accumulate('[0:]')
    ) as dt;

Output

employee_id employee_name employee_data articles reviews quotes Sentiment Message
1 Parker Doe Parker Doe originally from Brazil has successfully cleared all their loans by 2020 04 25 Reach them at 555 555 5555 Their SSN is 859 98 0987 and Brazilian CPF number is 998214865 68 Climate change poses significant challenges globally affecting weather patterns ecosystems and human societies It accelerates sea level rise alters precipitation patterns and intensifies extreme weather events such as hurricanes and droughts The burning of fossil fuels by industries like ExxonMobil and deforestation contribute to the buildup of greenhouse gases like CO2 in the atmosphere Scientists agree urgent action is needed to mitigate these impacts and adapt to the changing climate The Paris Agreement signed in 2015 aims to limit global warming to well below 2 degrees Celsius above pre-industrial levels Efforts to reduce emissions by 2030 are critical with targets set by countries like the United States and the European Union Todays food delivery was quicker than yesterdays Appreciated it El tiempo es oro positive  
2 Alex Smith Alex Smith a Canadian has an outstanding loan due on 2022 05 30 Their contact number is 555 555 5556 and SSN is 123 45 6789 Canadian SIN number is 123 456 789 The 2020 Tokyo Olympics was postponed to 2021 due to the COVID-19 pandemic This was the first time in history that the Olympics was postponed rather than cancelled The food was excellent but it arrived a bit late Apres la pluie le beau temps positive  
3 Emily Johnson Emily Johnson from the UK cleared all their loans by 2021 01 15 They can be contacted at 555 555 5557 Their SSN is 987 65 4321 and UK NINO number is AB 12 34 56 C Renewable energy sources such as solar wind and hydroelectric power play a crucial role in reducing dependence on fossil fuels They provide clean sustainable alternatives to coal oil and natural gas which are major contributors to greenhouse gas emissions Solar panels harness sunlight to generate electricity while wind turbines convert wind energy into power Hydroelectric dams use flowing water to produce electricity These technologies are pivotal in combating climate change and achieving energy security Governments worldwide are investing heavily in renewable energy initiatives to meet growing demand and reduce environmental impact The transition to renewable energy is seen as essential for a sustainable future The delivery was prompt but the food was spilled and the portion size was small La vie est belle negative  
4 Michael Brown Michael Brown an Australian has a loan due on 2023 07 20 Contact them at 555 555 5558 Their SSN is 654 32 1987 and Australian TFN number is 123 456 789 The recent 2020 United States elections have shown a shift in the political landscape With more young people voting the impact of social media platforms like Facebook and Twitter and digital campaigns led by parties such as the Democrats and Republicans has been more evident than ever Both the food and the delivery service were topnotch Geniet van de kleine dingen. positive  
5 Linda Taylor Linda Taylor a German cleared all their loans by 2020 12 31 They can be reached at 555 555 5559 Their SSN is 321 98 7654 and German IdNr number is 12345678910 The 2019 Amazon rainforest wildfires were a severe environmental crisis The fires burned thousands of square miles of forest and released large amounts of carbon dioxide into the atmosphere The food was average and the delivery person was rude Wees de verandering die je in de wereld wil zien gebeuren negative  
AWS Bedrock Key
SELECT * FROM AI_AnalyzeSentiment(   
  ON ta_employee_data AS InputTable
  USING   
  TextColumn('reviews')
  ApiType('aws')
  BedrockKey('bedrock-api-key-YmVkcm9jay5hbWF6b25hd3MuY29tLz9BY3Rpb249Q2FsbFdpdGhCZWFyZXJUb2tlbiZYLUFtei1BbGdvcml0aG09QVdTNC1ITUFDLVNIQTI1NiZYLUFtei1DcmVkZW50aWFsPUFTSUFSRFlFN0FNMlNJQURWRkJOJTJGMjAyNTEwMTAlMkZ1cy13ZXN0LTIlMkZiZWRyb2NrJTJGYXdzNF9yZXF1ZXN0JlgtQW16LURhdGU9MjAyNTEwMTBUMTE0MDM0WiZYLUFtei1FeHBpcmVzPTQzMjAwJlgtQW16LVNlY3VyaXR5LVRva2VuPUlRb0piM0pwWjJsdVgyVmpFRlFhQ1hWekxYZGxjM1F0TWlKSE1FVUNJSFNhZjhQNnd0NWRJSjRQbG9xbGRmelNCdlpyQzNJSVR3dXRURFpQU3daVkFpRUE2ZW03ZVdUUTBYSFFnRk44d2hLY29OeTdYaFh5RGNBVWhrUG5GMldQb2lzcTJ3UUk3ZiUyRiUyRiUyRiUyRiUyRiUyRiUyRiUyRiUyRiUyRkFSQURHZ3d3TnpZM09ESTVOakUwTmpFaURFJTJCbXJHc1YySDhHUDZHakNDcXZCQzZuekpNZjU4WG5LM0lCNVJSVGVqWWxWMUExQ2JoMkh1Z1hEbDdmdVRVMEhXN2dSZDA1cGFmQSUyRlR3ZkZFY1NkRlVSdkFTU2VRNlpzN2YxbjBRa3FlZmhHWDJxUyUyQnhLTEhncXdIQ1NDZnJSa25IZzljdWswd0w3QVJnMEpaQnJTdThuUm1URFloRyUyQiUyRkluc0M2bGo0eFpzNVRGRVpqSFJVRVJXaDhXQTdoZzFiM25xYVlGWmd6V09rMUFNcTdWTjBDdUJUYldJQiUyRjdiN2klMkZ1ZlBiVkdXVTRWT0djUk9MUlYlMkZaZlpxMHg3VG8xdkklMkZYNVFNR3VBOGw1RkJSUERNUFlvWDFJeVBKVyUyQjFta0h6WWdSYnVwRjJNbm1majYzUDJZR09xT1lJZTkwR0NlRWJzcUF4NXZLNW83JTJGZG0xcjdwUFVzYU8zN3piTHZaQnVyUjkxJTJCcDV6cGFhSU8lMkZmbmxwY0RDTUJvJTJCNUhhM1F4dEtheFI2SUtPaW1ZVXFOeGE1Q1ZHbnlrQ3djOWl6bGg5RzBHOHlXcVJUUEl2OHF2Z3JGaTZrNW9pb0ZxSVYzMU9LWXdwcEFCZkI5clVvS3Y3SkV6Z1RLQTlkcFpNYXVabTRzT01hMVp3Q01FaXY2Tm0yME1yMTk5S0ZISGNDc1ZVUjY4TlNJbnNUU3dVNjVIbmVoJTJCNnp2cTl6SFFRU3paM0RNRElMVmFXR3hLdWJsVlRtSU5oemthRHpHVkNQbUQ4eXVVb0kzZEZ4M2JzYVBSaDZRMVN6ejJTcFglMkZVTExXakNoTjR2ODJid0pBQ0h4Q2E0TWw5bXB3a0RLV0xkSVZkaWEwNEVTMVd3NENLbCUyQmRxYUNLWFdVTWlZS1FnVktwJTJCNG5XbnRudWplVkZrWDRyaTJoT0drUFZyakJIdkpJJTJGQ2JqcWc3REl3d3FXZEhwQmdubjFPamluSDJlbTVNRnF5T2pObUNHeTA4dEYweDdBVzVlUWxucEJqblhNZGt3a2VHanh3WTZ4UUxFR3lmR3hrMEtrQWw5UTBqeVpuYTh3R1BiZU5hQjJTWEFuMlpFJTJCNGtPOFltcHRQWGc0MjRmMFZTJTJCRkJpRVhJb0dCdFIlMkZVYkJJc3hka2c4ciUyRiUyQjIxWHBlNVVsTU5uazBWbFdrQ0dnbm5DcmljQzByYmY5b28lMkZBck04blhtUFRMNkZiUG42d0dUdno4TXk3byUyRkgxWkk3ZG1YTTJPeHVXQXQlMkZMY1l0RzRlSUMlMkY1TEw3eFF0aEo5JTJGUzNHZVRFQllQNENCbUxad3JHZ0s1M042N0pwazdzMzlndFI0JTJGdmVaSDZRYiUyQlZONWFBcnBEJTJCdzIwT2pxOVUxQWdoRkpRTlc4M0s3bjg4UzZWRWtYQWdaUUkzcmhyT0NGNkRjN1FHZEFzUWt4YjZEZEZWJTJGTnhkQWs4SlB4TW1PNnJVR2Zyb3hOcUlsWG5LQ29nWU5yNlZrSzhkZFlYRVZWVjdod2wwT3hXU0hwNkh4TSUyRlclMkJJdVpST1FQN2liRE93UW82Q1RqUjlLYWV5SGN2VTJJcVdOYzltRUx1SzA0N0klMkZlYiUyRm0yTEhFVDhzMmJJJTJGOTV6ZmMwbHFRUmYmWC1BbXotU2lnbmF0dXJlPTQ5NGNiNjg2NTg2NmVkOWNmMWIwNzNmNmUyNTdkNGU2YTRlNzcwYTcxMTU0MzI4MjMwMjhjMzhmNDIwZjc5MTkmWC1BbXotU2lnbmVkSGVhZGVycz1ob3N0JlZlcnNpb249MQ==')
  Region('us-west-2')
  ModelName('us.amazon.nova-micro-v1:0')
  isDebug('true')
  Accumulate('[0:]')
  ShowNumTokens('y')
) as dt;

Output

employee_id employee_name employee_data articles reviews quotes Sentiment Message
1 Parker Doe Parker Doe originally from Brazil has successfully cleared all their loans by 2020 04 25 Reach them at 555 555 5555 Their SSN is 859 98 0987 and Brazilian CPF number is 998214865 68 Climate change poses significant challenges globally affecting weather patterns ecosystems and human societies It accelerates sea level rise alters precipitation patterns and intensifies extreme weather events such as hurricanes and droughts The burning of fossil fuels by industries like ExxonMobil and deforestation contribute to the buildup of greenhouse gases like CO2 in the atmosphere Scientists agree urgent action is needed to mitigate these impacts and adapt to the changing climate The Paris Agreement signed in 2015 aims to limit global warming to well below 2 degrees Celsius above pre-industrial levels Efforts to reduce emissions by 2030 are critical with targets set by countries like the United States and the European Union Todays food delivery was quicker than yesterdays Appreciated it El tiempo es oro positive  
2 Alex Smith Alex Smith a Canadian has an outstanding loan due on 2022 05 30 Their contact number is 555 555 5556 and SSN is 123 45 6789 Canadian SIN number is 123 456 789 The 2020 Tokyo Olympics was postponed to 2021 due to the COVID-19 pandemic This was the first time in history that the Olympics was postponed rather than cancelled The food was excellent but it arrived a bit late Apres la pluie le beau temps positive  
3 Emily Johnson Emily Johnson from the UK cleared all their loans by 2021 01 15 They can be contacted at 555 555 5557 Their SSN is 987 65 4321 and UK NINO number is AB 12 34 56 C Renewable energy sources such as solar wind and hydroelectric power play a crucial role in reducing dependence on fossil fuels They provide clean sustainable alternatives to coal oil and natural gas which are major contributors to greenhouse gas emissions Solar panels harness sunlight to generate electricity while wind turbines convert wind energy into power Hydroelectric dams use flowing water to produce electricity These technologies are pivotal in combating climate change and achieving energy security Governments worldwide are investing heavily in renewable energy initiatives to meet growing demand and reduce environmental impact The transition to renewable energy is seen as essential for a sustainable future The delivery was prompt but the food was spilled and the portion size was small La vie est belle negative  
4 Michael Brown Michael Brown an Australian has a loan due on 2023 07 20 Contact them at 555 555 5558 Their SSN is 654 32 1987 and Australian TFN number is 123 456 789 The recent 2020 United States elections have shown a shift in the political landscape With more young people voting the impact of social media platforms like Facebook and Twitter and digital campaigns led by parties such as the Democrats and Republicans has been more evident than ever Both the food and the delivery service were topnotch Geniet van de kleine dingen. positive  
5 Linda Taylor Linda Taylor a German cleared all their loans by 2020 12 31 They can be reached at 555 555 5559 Their SSN is 321 98 7654 and German IdNr number is 12345678910 The 2019 Amazon rainforest wildfires were a severe environmental crisis The fires burned thousands of square miles of forest and released large amounts of carbon dioxide into the atmosphere The food was average and the delivery person was rude Wees de verandering die je in de wereld wil zien gebeuren negative   
 SELECT * FROM AI_ANALYZESENTIMENT(   
      ON ta_employee_data AS InputTable
      USING   
      TextColumn('reviews')
      ApiType('azure')
      ApiBase('<api base>')
      ApiVersion('<api version>')
      ApiKey('<api key>')
      DeploymentId('<engine id>')
      ModelName('gpt-3.5-turbo')
      ModelArgs('{}')
      isDebug('true')
      Accumulate('[0:]')
    ) as dt;

Output

employee_id employee_name employee_data articles reviews quotes Sentiment Message InputTokens OutputTokens
0 Linda Taylor Linda Taylor a German cleared all their loans by 2020 12 31 They can be reached at 555 555 5559 Their SSN is 321 98 7654 and German IdNr number is 12345678910 The 2019 Amazon rainforest wildfires were a severe environmental crisis The fires burned thousands of square miles of forest and released large amounts of carbon dioxide into the atmosphere The food was average and the delivery person was rude Wees de verandering die je in de wereld wil zien gebeuren negative   91 1
1 Emily Johnson Emily Johnson from the UK cleared all their loans by 2021 01 15 They can be contacted at 555 555 5557 Their SSN is 987 65 4321 and UK NINO number is AB 12 34 56 C Renewable energy sources such as solar wind and hydroelectric power play a crucial role in reducing dependence on fossil fuels They provide clean sustainable alternatives to coal oil and natural gas which are major contributors to greenhouse gas emissions Solar panels harness sunlight to generate electricity while wind turbines convert wind energy into power Hydroelectric dams use flowing water to produce electricity These technologies are pivotal in combating climate change and achieving energy security Governments worldwide are investing heavily in renewable energy initiatives to meet growing demand and reduce environmental impact The transition to renewable energy is seen as essential for a sustainable future The delivery was prompt but the food was spilled and the portion size was small La vie est belle negative   96 1
2 Parker Doe Parker Doe originally from Brazil has successfully cleared all their loans by 2020 04 25 Reach them at 555 555 5555 Their SSN is 859 98 0987 and Brazilian CPF number is 998214865 68 Climate change poses significant challenges globally affecting weather patterns ecosystems and human societies It accelerates sea level rise alters precipitation patterns and intensifies extreme weather events such as hurricanes and droughts The burning of fossil fuels by industries like ExxonMobil and deforestation contribute to the buildup of greenhouse gases like CO2 in the atmosphere Scientists agree urgent action is needed to mitigate these impacts and adapt to the changing climate The Paris Agreement signed in 2015 aims to limit global warming to well below 2 degrees Celsius above pre-industrial levels Efforts to reduce emissions by 2030 are critical with targets set by countries like the United States and the European Union Todays food delivery was quicker than yesterdays Appreciated it El tiempo es oro positive   94 1
3 Michael Brown Michael Brown an Australian has a loan due on 2023 07 20 Contact them at 555 555 5558 Their SSN is 654 32 1987 and Australian TFN number is 123 456 789 The recent 2020 United States elections have shown a shift in the political landscape With more young people voting the impact of social media platforms like Facebook and Twitter and digital campaigns led by parties such as the Democrats and Republicans has been more evident than ever Both the food and the delivery service were topnotch Geniet van de kleine dingen. positive   92 1
4 Alex Smith Alex Smith a Canadian has an outstanding loan due on 2022 05 30 Their contact number is 555 555 5556 and SSN is 123 45 6789 Canadian SIN number is 123 456 789 The 2020 Tokyo Olympics was postponed to 2021 due to the COVID-19 pandemic This was the first time in history that the Olympics was postponed rather than cancelled The food was excellent but it arrived a bit late Apres la pluie le beau temps positive   91 1 
SELECT * FROM AI_ANALYZESENTIMENT(   
      ON ta_employee_data AS InputTable
      USING   
      TextColumn('articles')
      ApiType('gcp')
      AccessToken('{gcp_token}')J
      REGION('us-central1')
      PROJECT('gcp-datascience-languages')
      ModelName('gemini-1.5-pro-001')
      EnableSafety('false')
      isDebug('true')
      Accumulate('[0:]')
    ) as dt;

Output

employee_id employee_name employee_data articles reviews quotes Sentiment Message InputTokens OutputTokens
1 Parker Doe Parker Doe originally from Brazil has successfully cleared all their loans by 2020 04 25 Reach them at 555 555 5555 Their SSN is 859 98 0987 and Brazilian CPF number is 998214865 68 Climate change poses significant challenges globally affecting weather patterns ecosystems and human societies It accelerates sea level rise alters precipitation patterns and intensifies extreme weather events such as hurricanes and droughts The burning of fossil fuels by industries like ExxonMobil and deforestation contribute to the buildup of greenhouse gases like CO2 in the atmosphere Scientists agree urgent action is needed to mitigate these impacts and adapt to the changing climate The Paris Agreement signed in 2015 aims to limit global warming to well below 2 degrees Celsius above pre-industrial levels Efforts to reduce emissions by 2030 are critical with targets set by countries like the United States and the European Union Todays food delivery was quicker than yesterdays Appreciated it El tiempo es oro positive \n   91 1
2 Alex Smith Alex Smith a Canadian has an outstanding loan due on 2022 05 30 Their contact number is 555 555 5556 and SSN is 123 45 6789 Canadian SIN number is 123 456 789 The 2020 Tokyo Olympics was postponed to 2021 due to the COVID-19 pandemic This was the first time in history that the Olympics was postponed rather than cancelled The food was excellent but it arrived a bit late Apres la pluie le beau temps positive \n   96 1
3 Emily Johnson Emily Johnson from the UK cleared all their loans by 2021 01 15 They can be contacted at 555 555 5557 Their SSN is 987 65 4321 and UK NINO number is AB 12 34 56 C Renewable energy sources such as solar wind and hydroelectric power play a crucial role in reducing dependence on fossil fuels They provide clean sustainable alternatives to coal oil and natural gas which are major contributors to greenhouse gas emissions Solar panels harness sunlight to generate electricity while wind turbines convert wind energy into power Hydroelectric dams use flowing water to produce electricity These technologies are pivotal in combating climate change and achieving energy security Governments worldwide are investing heavily in renewable energy initiatives to meet growing demand and reduce environmental impact The transition to renewable energy is seen as essential for a sustainable future The delivery was prompt but the food was spilled and the portion size was small La vie est belle negative \n   94 1
4 Michael Brown Michael Brown an Australian has a loan due on 2023 07 20 Contact them at 555 555 5558 Their SSN is 654 32 1987 and Australian TFN number is 123 456 789 The recent 2020 United States elections have shown a shift in the political landscape With more young people voting the impact of social media platforms like Facebook and Twitter and digital campaigns led by parties such as the Democrats and Republicans has been more evident than ever Both the food and the delivery service were topnotch Geniet van de kleine dingen. positive \n   92 1
5 Linda Taylor Linda Taylor a German cleared all their loans by 2020 12 31 They can be reached at 555 555 5559 Their SSN is 321 98 7654 and German IdNr number is 12345678910 The 2019 Amazon rainforest wildfires were a severe environmental crisis The fires burned thousands of square miles of forest and released large amounts of carbon dioxide into the atmosphere The food was average and the delivery person was rude Wees de verandering die je in de wereld wil zien gebeuren negative \n   91 1 
SELECT * FROM AI_ANALYZESENTIMENT
(ON ta_employee_data as InputTable
      USING
      TextColumn('reviews')
      isDebug('True')
      ApiType('nim')
      Authorization(nim_auth)
      ModelName('meta/llama-3.1-8b-instruct')
      Accumulate('[0:]')
) as dt

Output

employee_id employee_name employee_data articles reviews quotes Sentiment Message
1 Parker Doe Parker Doe originally from Brazil has successfully cleared all their loans by 2020 04 25 Reach them at 555 555 5555 Their SSN is 859 98 0987 and Brazilian CPF number is 998214865 68 Climate change poses significant challenges globally affecting weather patterns ecosystems and human societies It accelerates sea level rise alters precipitation patterns and intensifies extreme weather events such as hurricanes and droughts The burning of fossil fuels by industries like ExxonMobil and deforestation contribute to the buildup of greenhouse gases like CO2 in the atmosphere Scientists agree urgent action is needed to mitigate these impacts and adapt to the changing climate The Paris Agreement signed in 2015 aims to limit global warming to well below 2 degrees Celsius above pre-industrial levels Efforts to reduce emissions by 2030 are critical with targets set by countries like the United States and the European Union Todays food delivery was quicker than yesterdays Appreciated it El tiempo es oro positive  
2 Alex Smith Alex Smith a Canadian has an outstanding loan due on 2022 05 30 Their contact number is 555 555 5556 and SSN is 123 45 6789 Canadian SIN number is 123 456 789 The 2020 Tokyo Olympics was postponed to 2021 due to the COVID-19 pandemic This was the first time in history that the Olympics was postponed rather than cancelled The food was excellent but it arrived a bit late Apres la pluie le beau temps positive  
3 Emily Johnson Emily Johnson from the UK cleared all their loans by 2021 01 15 They can be contacted at 555 555 5557 Their SSN is 987 65 4321 and UK NINO number is AB 12 34 56 C Renewable energy sources such as solar wind and hydroelectric power play a crucial role in reducing dependence on fossil fuels They provide clean sustainable alternatives to coal oil and natural gas which are major contributors to greenhouse gas emissions Solar panels harness sunlight to generate electricity while wind turbines convert wind energy into power Hydroelectric dams use flowing water to produce electricity These technologies are pivotal in combating climate change and achieving energy security Governments worldwide are investing heavily in renewable energy initiatives to meet growing demand and reduce environmental impact The transition to renewable energy is seen as essential for a sustainable future The delivery was prompt but the food was spilled and the portion size was small La vie est belle negative  
4 Michael Brown Michael Brown an Australian has a loan due on 2023 07 20 Contact them at 555 555 5558 Their SSN is 654 32 1987 and Australian TFN number is 123 456 789 The recent 2020 United States elections have shown a shift in the political landscape With more young people voting the impact of social media platforms like Facebook and Twitter and digital campaigns led by parties such as the Democrats and Republicans has been more evident than ever Both the food and the delivery service were topnotch Geniet van de kleine dingen. positive  
5 Linda Taylor Linda Taylor a German cleared all their loans by 2020 12 31 They can be reached at 555 555 5559 Their SSN is 321 98 7654 and German IdNr number is 12345678910 The 2019 Amazon rainforest wildfires were a severe environmental crisis The fires burned thousands of square miles of forest and released large amounts of carbon dioxide into the atmosphere The food was average and the delivery person was rude Wees de verandering die je in de wereld wil zien gebeuren negative