AI_ExtractKeyPhrases Examples | Teradata Vantage - Examples: How to Use AI_ExtractKeyPhrases - 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

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

SELECT * FROM AI_ExtractKeyPhrases(   
      ON ta_employee_data AS InputTable
      USING   
      TextColumn('articles')
      ApiType('aws')
      REGION('us-west-2')
      ACCESSKEY('<access key>')
      SECRETKEY('<secret key>')
      ModelName('anthropic.claude-v2')
      isDebug('true')
      Accumulate('[0:]')
      ShowNumTokens('1')
    ) as dt;

Output

employee_id employee_name employee_data articles reviews quotes Key_Phrases 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 climate change, greenhouse gases, global warming, Paris Agreement, fossil fuels, deforestation, extreme weather events, sea level rise, emissions, pre-industrial levels 207 68
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 The 2020 Tokyo Olympics, postponed to 2021, COVID-19 pandemic, first time in history, Olympics postponed rather than cancelled 211 57
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 renewable energy, solar, wind, hydroelectric power, reducing dependence on fossil fuels, clean sustainable alternatives, coal, oil, natural gas, greenhouse gas emissions, solar panels, sunlight, generate electricity, wind turbines, wind energy, power, hydroelectric dams, flowing water, produce electricity, combating climate change, achieving energy security, Governments, renewable energy initiatives, meet growing demand, reduce environmental impact, transition to renewable energy, sustainable future 197 86
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. recent 2020 United States elections, shift in the political landscape, young people voting, impact of social media platforms, Facebook, Twitter, digital campaigns, Democrats, Republicans 206 100
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 2019 Amazon rainforest wildfires, severe environmental crisis, fires burned thousands of square miles of forest, released large amounts of carbon dioxide into the atmosphere 280 35

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

SELECT * FROM AI_ExtractKeyPhrases(   
      ON ta_employee_data AS InputTable
      USING   
      TextColumn('articles')
      ApiType('azure')
      ApiBase('<api base>')
      ApiVersion('<api version>')
      ApiKey('')
      DeploymentId('<engine id>')
      ModelName('gpt-3.5-turbo')
      isDebug('true')
      Accumulate('[0:]')
      ShowNumTokens('t')
      RefreshCredentialTimeSeconds('1800')  
    ) as dt;

Output

employee_name employee_data articles reviews quotes Key_Phrases InputTokens OutputTokens
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 Climate change, significant challenges, globally, weather patterns, ecosystems, human societies, sea level rise, precipitation patterns, extreme weather events, hurricanes, droughts, burning of fossil fuels, industries, ExxonMobil, deforestation, greenhouse gases, CO2, atmosphere, Scientists, urgent action, mitigate impacts, adapt to changing climate, Paris Agreement, 2015, limit global warming, well below 2 degrees Celsius, pre-industrial levels, reduce emissions, 2030, critical, targets, United States, European Union. 207 68
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 2020 Tokyo Olympics, postponed, 2021, COVID-19 pandemic, first time in history, Olympics, cancelled, NaN 211 57
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 renewable energy sources, solar wind, hydroelectric power, dependence on fossil fuels, clean sustainable alternatives, coal oil, natural gas, greenhouse gas emissions, solar panels, sunlight, electricity, wind turbines, wind energy, power, hydroelectric dams, flowing water, electricity, technologies, climate change, energy security, governments worldwide, renewable energy initiatives, growing demand, environmental impact, transition, sustainable future. 197 86
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. recent 2020 United States elections, shift, political landscape, young people, social media platforms, Facebook, Twitter, digital campaigns, parties, Democrats, Republicans, evident 206 100
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 2019 Amazon rainforest wildfires, severe environmental crisis, fires, thousands of square miles of forest, large amounts of carbon dioxide, atmosphere 280 35 
SELECT * FROM AI_ExtractKeyPhrases(   
      ON ta_employee_data AS InputTable
      USING   
      TextColumn('articles')
      ApiType('gcp')
      AccessToken('{gcp_token}')
      Authorization(td_gen_gcp_auth)
      EnableSafety('false')
      isDebug('true')
      Accumulate('[0:]')
      ShowNumTokens('no')
    ) as dt;

Output

emplotee_id employee_name employee_data articles reviews quotes Key_Phrases 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 Climate change, weather patterns, ecosystems, human societies, sea level rise, precipitation patterns, extreme weather events, hurricanes, droughts, burning of fossil fuels, ExxonMobil, deforestation, greenhouse gases, CO2, atmosphere, Paris Agreement, global warming, reduce emissions, 2030, United States, European Union \n  
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 2020 Tokyo Olympics, COVID-19 pandemic, Olympics postponed \n  
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 renewable energy sources, solar wind, hydroelectric power, fossil fuels, clean sustainable alternatives, coal oil, natural gas, greenhouse gas emissions, solar panels, wind turbines, wind energy, hydroelectric dams, climate change, energy security, renewable energy initiatives, environmental impact, transition to renewable energy, sustainable future \n  
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. 2020 United States elections, political landscape, young people voting, social media platforms, Facebook, Twitter, digital campaigns, Democrats, Republicans \n  
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 2019 Amazon rainforest wildfires, environmental crisis, thousands of square miles of forest, carbon dioxide   
SELECT * FROM AI_ExtractKeyPhrases(   
      ON ta_employee_data AS InputTable
      USING   
      TextColumn('articles')
      ApiType('nim')
      Authorization(nim_auth)
      ModelName('meta/llama-3.1-8b-instruct')
      isDebug('true')
      Accumulate('[0:]')
      ShowNumTokens('1')
    ) as dt;

Output

employee_id employee_name employee_data articles reviews quotes Key_Phrases 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 climate change, weather patterns, ecosystems, human societies, sea level rise, precipitation patterns, extreme weather events, greenhouse gases, fossil fuels, deforestation, global warming, Paris Agreement, greenhouse gas emissions 207 68
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 2020 Tokyo Olympics, COVID-19 pandemic, Olympics was postponed 211 57
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 renewable energy sources, reducing dependence on fossil fuels, clean sustainable alternatives, greenhouse gas emissions, solar panels, wind turbines, hydroelectric dams, combating climate change, energy security, renewable energy initiatives, sustainable future 197 68
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. young people voting, social media platforms, political landscape, digital campaigns, United States elections 206 100
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 2019 Amazon rainforest wildfires, environmental crisis, thousands of square miles of forest, large amounts of carbon dioxide 280 35