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

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

AWS Bedrock

Empty credentials can be used; the function will use credentials from IAM roles for EC2 instances. Such credentials are updated every RefreshCredentialTimeSeconds.

CREATE AUTHORIZATION td_gen_aws_empty_creds
user ''
password '';

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

Output

employee_id	employee_name	employee_data	articles	reviews	quotes	Sentiment
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

Empty credentials can be used; the function will use credentials from IAM roles for EC2 instances. Such credentials are updated every RefreshCredentialTimeSeconds.

CREATE AUTHORIZATION td_gen_aws_empty_creds
user ''
password '';

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

Output

employee_id	employee_name	employee_data	articles	reviews	quotes	Sentiment
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

Empty credentials can be used; the function will use credentials from IAM roles for EC2 instances. Such credentials are updated every RefreshCredentialTimeSeconds.

CREATE AUTHORIZATION td_gen_aws_empty_creds
user ''
password '';

SELECT * FROM AI_ANALYZESENTIMENT(   
      ON ta_employee_review AS InputTable
      USING   
      TextColumn('reviews')
      ApiType('aws')
      REGION('us-west-2')
      Authorization(td_gen_aws_empty_creds)
      ModelName('us.amazon.nova-micro-v1:0')
      ModelArgs('{}')
      isDebug('true')
      Accumulate('[0:]')
      ShowNumTokens('f')
      RefreshCredentialTimeSeconds('1800')
    ) as dt;

Output

employee_id	employee_name	employee_data	articles	reviews	quotes	Sentiment
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
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

API Key can be empty as it will be generated from Azure VMs. It will be refreshed every RefreshCredentialTimeSeconds.

 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:]')
      ShowNumTokens('t')
      RefreshCredentialTimeSeconds('1800')
    ) as dt;

Output

employee_id	employee_name	employee_data	articles	reviews	quotes	Sentiment	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

Empty credentials are not supported in Google Cloud Platform.

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:]')
      ShowNumTokens('true')
    ) as dt;

Output

employee_id	employee_name	employee_data	articles	reviews	quotes	Sentiment	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:]')
      ShowNumTokens('1')
) as dt

Output

employee_id	employee_name	employee_data	articles	reviews	quotes	Sentiment	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	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	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	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	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	91	1

AI_AnalyzeSentiment Examples | Teradata Vantage - Examples: How to Use AI_AnalyzeSentiment - Teradata Analytics

Teradata® Text Analytics AI Functions