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

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_TextEmbeddings(   
      ON ta_employee_data AS InputTable
      USING   
      TextColumn('articles')
      ApiType('aws')
      REGION('us-west-2')
      Authorization(td_gen_aws_empty_creds)
      ModelName('amazon.titan-embed-text-v1')
      outputformat('varbyte')
      isDebug('true')
      Accumulate('[0:]')
      ShowNumTokens('0')
      RefreshCredentialTimeSeconds('1800') 
    ) as dt;

Output

employee_id employee_name employee_data articles reviews quotes Embeddings 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 0.09716796875,-0.19140625,-0.515625,0.15625,-0.0157470703125,0.10107421875,-0.24609375,-0.236328125,-0.08984375,...  
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 0.09716796875,-0.19140625,-0.515625,0.15625,-0.0157470703125,0.10107421875,-0.24609375,-0.236328125,-0.08984375,...  
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 0.09716796875,-0.19140625,-0.515625,0.15625,-0.0157470703125,0.10107421875,-0.24609375,-0.236328125,-0.08984375,...  
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. 0.09716796875,-0.19140625,-0.515625,0.15625,-0.0157470703125,0.10107421875,-0.24609375,-0.236328125,-0.08984375,...  
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 0.09716796875,-0.19140625,-0.515625,0.15625,-0.0157470703125,0.10107421875,-0.24609375,-0.236328125,-0.08984375,...  
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_TextEmbeddings(   
      ON ta_employee_data AS InputTable
      USING   
      TextColumn('articles')
      ApiType('aws')
      REGION('us-west-2')
      Authorization(td_gen_aws_empty_creds)
      ModelName('amazon.titan-embed-text-v1')
      outputformat('VARCHAR')
      OutputCharset('UNICODE')
      isDebug('true')
      Accumulate('[0:]')
      ShowNumTokens('0')
      RefreshCredentialTimeSeconds('1800') 
    ) as dt;

Output

employee_id employee_name employee_data articles reviews quotes Embeddings 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 0.09716796875,-0.19140625,-0.515625,0.15625,-0.0157470703125,0.10107421875,-0.24609375,-0.236328125,-0.08984375,...  
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 0.09716796875,-0.19140625,-0.515625,0.15625,-0.0157470703125,0.10107421875,-0.24609375,-0.236328125,-0.08984375,...  
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 0.09716796875,-0.19140625,-0.515625,0.15625,-0.0157470703125,0.10107421875,-0.24609375,-0.236328125,-0.08984375,...  
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. 0.09716796875,-0.19140625,-0.515625,0.15625,-0.0157470703125,0.10107421875,-0.24609375,-0.236328125,-0.08984375,...  
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 0.09716796875,-0.19140625,-0.515625,0.15625,-0.0157470703125,0.10107421875,-0.24609375,-0.236328125,-0.08984375,...  
AWS Bedrock Key
SELECT * FROM AI_TextEmbeddings(
ON ta_employee_data as inputtable
USING
TextColumn('articles')
ApiType('aws')
BedrockKey('bedrock-api-key-YmVkcm9jay5hbWF6b25hd3MuY29tLz9BY3Rpb249Q2FsbFdpdGhCZWFyZXJUb2tlbiZYLUFtei1BbGdvcml0aG09QVdTNC1ITUFDLVNIQTI1NiZYLUFtei1DcmVkZW50aWFsPUFTSUFSRFlFN0FNMlNNN1FZVEdDJTJGMjAyNTEwMDglMkZ1cy13ZXN0LTIlMkZiZWRyb2NrJTJGYXdzNF9yZXF1ZXN0JlgtQW16LURhdGU9MjAyNTEwMDhUMDUwMjE3WiZYLUFtei1FeHBpcmVzPTQzMjAwJlgtQW16LVNlY3VyaXR5LVRva2VuPUlRb0piM0pwWjJsdVgyVmpFQjBhQ1hWekxYZGxjM1F0TWlKSU1FWUNJUUNVVGZHaHUxM1FSek91VlNlYXRBaWhQeWtZQnMwMmlPcXZQTXhQRUh2UFdnSWhBTllzamlzaTN3TnZuQjZNekxJNXY4MGwyMVFtcjhJbVVWWFdydkQlMkZ4Q2dBS3RzRUNMYiUyRiUyRiUyRiUyRiUyRiUyRiUyRiUyRiUyRiUyRndFUUF4b01NRGMyTnpneU9UWXhORFl4SWd5dm92a2hyVmJTV0xlNlhKMHFyd1NKanVvdllhQmxPVUliajdYWDI3ZGs1d1AyJTJCanpOSERNNTZ4YVBVNyUyRkVFRFhXOVJyek9LWXBUaTZvekVVVDdHN01rUktjMEFUbG1kakdEZHdEcXklMkZnV0xHU2tBZ1IlMkYlMkZmZ1E1RldFeUdGRSUyQmFiMENISVpSTUExMVJrdGFYY25WOWZKJTJGTmJNa3JaTGt0NmVLQlZhZ0MlMkZhOVpZTGZCMldtWk1hdmZGdWVtMU1lQ1ZFY2hFaHc5QWp5Mnh1OXN6MjdmcVVuekllWGRNMjhkbTVOb05SUERsWDRVWjRSZzJ4eGx1MVVrSnRKSEtqSUxTUnpjTkJ0bnY0VDR5dWFuUyUyRnRINVpnbWV0Q3k5JTJGeUxEdHNsbHVtMndXRUVaZlFxN3lUZExPWllDMEpNSkhRT25OZmhCczMySExrSUxXYTRjTWwxeUlhTzdMckRhdmR3VUZMWktyMWFVYVRnUXhPQjglMkZKbThlcXpvMHhyQXJQM1JJRDB0UUtrVzV0NkV4UXpoeWs2NFRzUGttVldQMEZOUzhWZVlBS3JGUTd0TSUyQlE4JTJGMFo2Y2VGV203bVVOakhaJTJCTkRhZ0s0RWxWS3dZWVd4NjJLdFdGNzg3OExoM1hGOHRmJTJGc21LNDJBeW1BbVVOQU9tTmJtV1MwZkFDcnpoSmdQeng4U1clMkJ3Y3BMb1lnJTJGTUszRERJTUdGYzJhbUdQOHQwY0s1QmNDNHdCR24lMkZFUnJ2VVpoUkxhNjJUVFlVODg4ZlZsV3laV3RTSmtYMUIybW9MOXFmOXl2Q1ElMkJrVUV6NTR0NVh1WXJDRGxROUhPTUVEeE5WUHUlMkYyQ3lORm54M1RWWFFzTm1UcW5udXk2aGhjWk9PM3dBMnQyMXQxMkxpRm5qNjA3ZVJVb0taZTRJWFBqZ0RaYlRGYjFoZHJ5eEJFSmMlMkI4ZVZDOWRPMERzdWhMdEk0ZkFFbmJJa2pWdkV6R3BBbkNqYjVhNXV1bVVQcGJJZlFlYlN2b29LMGlYTUpqZ2w4Y0dPc1FDM1UzVUlDTU1ReUJFbWFBTTN2MldvT2RUUVM2WFEySVl2NFFxQ1hvRDNWd1lWU3QyclpKJTJGc0JvZXpETm9RMmclMkJaaTdTMHBhSkhJZE9jRFklMkJhJTJCNUtSamdXZk01c01VRUdOb0sybEhQRW1HJTJCZ0RkckFHem42emVYeXU1N3p4YlVWdWdHYVZrZDQ1TElPbnNSN3ZZcWduUE9DM3U5NWpzNlJ4YWlnZURwblMlMkI2UDZiU3BLQzN1T0xzbFE5Slc3RGE0TGd3dFd3dWglMkZzRmJuNmc0dXIzNyUyQnpQc1d5cjFMTXVmMkYxSU5HekQ3N0E3SEh2bmd6byUyQjV4T3FUOWpubXM3a3FuTnhJNUklMkZUMzZaN2hPSzlyR0pSZVQyRjlOamdrQmpheVhZZXltNlI4ZEpoVjN2SWw5NG1uWExYTmVxM2hLeXo0ZUprYjlzJTJCWEx0QkFSSHYlMkJTTWY4Vm9aNzltcVA2bndPcUhzN1Q0aEo2WXlXaHhja2h1OWhrSSUyRldtMDFiaVMlMkZmdHl5OElvV3dNckVuOUhtck9VQUZyc0lZMWxlZHdFV000aTU0eWxpcE9vZUZFTCZYLUFtei1TaWduYXR1cmU9NjcyN2Y2MTk5ZmM3N2VmZDg2OThmZDczMTEyYzBmZmUxOGZiYTJjOGZmMGQ4MjZmYzQwODE1MTA2MWIyOGVkYyZYLUFtei1TaWduZWRIZWFkZXJzPWhvc3QmVmVyc2lvbj0x')
Region('us-west-2')
ModelName('amazon.titan-embed-text-v1')
ModelArgs('{}')
isDebug('true')
Accumulate('[0:]')
BatchArgs('{}')
OutputFormat('varbyte')
) as dt

Output

employee_id employee_name employee_data articles reviews quotes Embeddings 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 0.09716796875,-0.19140625,-0.515625,0.15625,-0.0157470703125,0.10107421875,-0.24609375,-0.236328125,-0.08984375,...  
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 0.09716796875,-0.19140625,-0.515625,0.15625,-0.0157470703125,0.10107421875,-0.24609375,-0.236328125,-0.08984375,...  
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 0.09716796875,-0.19140625,-0.515625,0.15625,-0.0157470703125,0.10107421875,-0.24609375,-0.236328125,-0.08984375,...  
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. 0.09716796875,-0.19140625,-0.515625,0.15625,-0.0157470703125,0.10107421875,-0.24609375,-0.236328125,-0.08984375,...  
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 0.09716796875,-0.19140625,-0.515625,0.15625,-0.0157470703125,0.10107421875,-0.24609375,-0.236328125,-0.08984375,...  

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

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

Output

employee_name employee_data articles reviews quotes Embeddings Num_Tokens
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 0.09716796875,-0.19140625,-0.515625,0.15625,-0.0157470703125,0.10107421875,-0.24609375,-0.236328125,-0.08984375,... 207
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 0.09716796875,-0.19140625,-0.515625,0.15625,-0.0157470703125,0.10107421875,-0.24609375,-0.236328125,-0.08984375,... 211
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 0.09716796875,-0.19140625,-0.515625,0.15625,-0.0157470703125,0.10107421875,-0.24609375,-0.236328125,-0.08984375,... 197
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. 0.09716796875,-0.19140625,-0.515625,0.15625,-0.0157470703125,0.10107421875,-0.24609375,-0.236328125,-0.08984375,... 206
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 0.09716796875,-0.19140625,-0.515625,0.15625,-0.0157470703125,0.10107421875,-0.24609375,-0.236328125,-0.08984375,... 280 
SELECT * FROM AI_TEXTEMBEDDINGS(   
    ON ta_employee_data AS InputTable
    USING   
    TextColumn('articles')
    ApiType('gcp')
	accessToken('<gcp_vertex_access_token>')
    REGION('<gcp_region>')
    Project('<gcp_project_name>')
    ModelName('text-embedding-005')
    ModelArgs('{}')
    outputformat('varchar')
    isDebug('true')
    Accumulate('[0:]')
    ShowNumTokens('1')
) as dt;

Output

employee_id employee_name employee_data articles reviews quotes Embeddings Num_Tokens
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 0.09716796875,-0.19140625,-0.515625,0.15625,-0.0157470703125,0.10107421875,-0.24609375,-0.236328125,-0.08984375,... 207
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 0.09716796875,-0.19140625,-0.515625,0.15625,-0.0157470703125,0.10107421875,-0.24609375,-0.236328125,-0.08984375,... 211
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 0.09716796875,-0.19140625,-0.515625,0.15625,-0.0157470703125,0.10107421875,-0.24609375,-0.236328125,-0.08984375,... 197
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. 0.09716796875,-0.19140625,-0.515625,0.15625,-0.0157470703125,0.10107421875,-0.24609375,-0.236328125,-0.08984375,... 206
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 0.09716796875,-0.19140625,-0.515625,0.15625,-0.0157470703125,0.10107421875,-0.24609375,-0.236328125,-0.08984375,... 280

Input

create authorization td_gen_litellm_embeddings_auth 
                user '{litellm_embeddings_api_base}' 
                password '{litellm_embeddings_api_key}';

Query

SELECT * FROM AI_TEXTEMBEDDINGS (
      ON ta_employee_data  AS InputTable
      USING
      apitype('LiteLLM')
      Authorization(td_gen_litellm_embeddings_auth)
      modelname('amazon.titan-embed-text-v2:0')
      textcolumn('articles')
      outputformat('varchar')
      IsDebug('true')
      ShowNumTokens('t')
) as sqlmr;

Output

employee_id employee_name employee_data articles reviews quotes Embedding Message NumTokens
5 Linda Taylor Linda Taylor a German cleared all their loans ... The 2019 Amazon rainforest wildfires were a se... The food was average and the delivery person w... Wees de verandering die je in de wereld wil zi... -0.013416271656751633,-...   33
3 Emily Johnson Emily Johnson from the UK cleared all their lo... Renewable energy sources such as solar wind an... The delivery was prompt but the food was spill... La vie est belle 0.029794558882713318,0....   109
1 Parker Doe Parker Doe originally from Brazil has successf... Climate change poses significant challenges gl... Todays food delivery was quicker than yesterda... El tiempo es oro -0.0030208691023290157,...   127
4 Michael Brown Michael Brown an Australian has a loan due on ... The recent 2020 United States elections have s... Both the food and the delivery service were to... Geniet van de kleine dingen. 0.02112133614718914,0.0...   50
2 Alex Smith Alex Smith a Canadian has an outstanding loan ... The 2020 Tokyo Olympics was postponed to 2021 ... The food was excellent but it arrived a bit late Apres la pluie le beau temps 0.021693000569939613,0....   35 
SELECT * FROM AI_TEXTEMBEDDINGS (
      ON ta_employee_data  AS InputTable
      USING
      apitype('litellm')
      ApiBase('{litellm_embeddings_api_base}')
      apikey('{litellm_embeddings_api_key}')
      modelname('amazon.titan-embed-text-v2:0')
      textcolumn('articles')
      outputformat('varchar')
      IsDebug('true')
      ShowNumTokens('t')
) as sqlmr;

Output

employee_id employee_name employee_data articles reviews quotes Embedding Message NumTokens
5 Linda Taylor Linda Taylor a German cleared all their loans ... The 2019 Amazon rainforest wildfires were a se... The food was average and the delivery person w... Wees de verandering die je in de wereld wil zi... -0.013416271656751633,-...   33
3 Emily Johnson Emily Johnson from the UK cleared all their lo... Renewable energy sources such as solar wind an... The delivery was prompt but the food was spill... La vie est belle 0.029794558882713318,0....   109
1 Parker Doe Parker Doe originally from Brazil has successf... Climate change poses significant challenges gl... Todays food delivery was quicker than yesterda... El tiempo es oro -0.0030208691023290157,...   127
4 Michael Brown Michael Brown an Australian has a loan due on ... The recent 2020 United States elections have s... Both the food and the delivery service were to... Geniet van de kleine dingen. 0.02112133614718914,0.0...   50
2 Alex Smith Alex Smith a Canadian has an outstanding loan ... The 2020 Tokyo Olympics was postponed to 2021 ... The food was excellent but it arrived a bit late Apres la pluie le beau temps 0.021693000569939613,0....   35

Query (Using URL instead of authorization object)

SELECT Embedding, Message FROM AI_TextEmbeddings(
      ON ta_employee_data AS InputTable
      USING
      TextColumn('reviews')
      ApiType('nim')
      ApiBase('http://127.0.0.1:8001/v1/embeddings')
      ApiKey('1234567890')
      ModelName('nvidia/nv-embedqa-mistral-7b-v2')
      outputformat('varchar')
      isDebug('true')
      Accumulate('[0:]')
      ModelArgs('{}')
      ShowNumTokens('yes')
    ) as dt;

Output

employee_id employee_name employee_data articles reviews quotes Embeddings Num_Tokens
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 0.09716796875,-0.19140625,-0.515625,0.15625,-0.0157470703125,0.10107421875,-0.24609375,-0.236328125,-0.08984375,... 207
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 0.09716796875,-0.19140625,-0.515625,0.15625,-0.0157470703125,0.10107421875,-0.24609375,-0.236328125,-0.08984375,... 211
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 0.09716796875,-0.19140625,-0.515625,0.15625,-0.0157470703125,0.10107421875,-0.24609375,-0.236328125,-0.08984375,... 197
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. 0.09716796875,-0.19140625,-0.515625,0.15625,-0.0157470703125,0.10107421875,-0.24609375,-0.236328125,-0.08984375,... 206
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 0.09716796875,-0.19140625,-0.515625,0.15625,-0.0157470703125,0.10107421875,-0.24609375,-0.236328125,-0.08984375,... 280