Text Analytics AI Function Example Input | Teradata Vantage - Text Analytics AI Function Example Input - Teradata Analytics

Use the following CREATE and INSERT statements examples relevant for your cloud platform to run example queries.

Create tables

CREATE TABLE ta_employee_data (
    employee_id INTEGER ,
    employee_name VARCHAR(255),
    employee_data VARCHAR(255),
    articles VARCHAR(1255),
    reviews VARCHAR(1255),
    quotes VARCHAR(1255)
);

CREATE TABLE conversation_data (
      id INTEGER,
      text_data VARCHAR(500) CHARACTER SET LATIN NOT CASESPECIFIC)
PRIMARY INDEX ( id );

CREATE MULTISET TABLE context_data (
    id int, 
    text_data varchar(500)
);

CREATE MULTISET TABLE question (
    id int, 
    text_data varchar(500)
);

Insert context_data

INSERT INTO ta_employee_data (employee_id, employee_name, employee_data, articles, reviews, quotes) VALUES
(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');

INSERT INTO ta_employee_data (employee_id, employee_name, employee_data, articles, reviews, quotes) VALUES
(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.');

INSERT INTO ta_employee_data (employee_id, employee_name, employee_data, articles, reviews, quotes) VALUES
(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');

INSERT INTO ta_employee_data (employee_id, employee_name, employee_data, articles, reviews, quotes) VALUES
(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');

INSERT INTO ta_employee_data (employee_id, employee_name, employee_data, articles, reviews, quotes) VALUES
(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');

INSERT INTO context_data (1, 'The city of Islamabad is the capital of Pakistan and is known for its peaceful environment.');
INSERT INTO context_data (1, 'Islamabad is surrounded by the Margalla Hills and is famous for its modern infrastructure.');

INSERT INTO context_data (2, 'Karachi, located on the southern coast of Pakistan, is a major economic hub.');
INSERT INTO context_data (2, 'The city is known for its beaches, ports, and diverse cultural heritage.');
INSERT INTO context_data (2, 'Karachi is part of the Sindh province and includes areas with desert landscapes.');

INSERT INTO context_data (3, 'Musa has a net worth of $40,000, which includes his savings and assets.');
INSERT INTO context_data (3, 'Ali owns assets worth $20,000.');
INSERT INTO context_data (3, 'Sara has financial holdings valued at $20,000.');

INSERT INTO context_data (4, 'Lahore, known as the cultural capital of Pakistan, is famous for its historical landmarks.');
INSERT INTO context_data (4, 'The city is home to the Lahore Fort and Badshahi Mosque, which are UNESCO World Heritage sites.');
INSERT INTO context_data (4, 'Lahore is also known for its vibrant food scene and colorful festivals.');

INSERT INTO context_data (5, 'Peshawar is a city in Khyber Pakhtunkhwa known for its rich history and ancient bazaars.');
INSERT INTO context_data (5, 'The city serves as a gateway to the historic Khyber Pass.');
INSERT INTO context_data (5, 'Peshawar is famous for its traditional cuisine and handcrafted goods.');

INSERT INTO context_data (6, 'The Great Wall of China is an ancient fortification built to protect against invasions.');
INSERT INTO context_data (6, 'The Wall stretches over 13,000 miles and is considered a marvel of engineering.');
INSERT INTO context_data (6, 'It is one of the most visited tourist attractions in the world, attracting millions of tourists every year.');

INSERT INTO question (1, 'What is this city name in discussion?');
INSERT INTO question (2, 'What is in Karachi?');
INSERT INTO question (2, 'Does it have a desert?');
INSERT INTO question (3, 'Give me name and value from the given data.');

INSERT INTO question (4, 'Which city is known as the cultural capital of Pakistan?');
INSERT INTO question (4, 'What landmarks are UNESCO World Heritage sites in Lahore?');
INSERT INTO question (4, 'What is Lahore famous for besides its landmarks?');

INSERT INTO question (5, 'Which city serves as the gateway to the Khyber Pass?');
INSERT INTO question (5, 'What is Peshawar known for historically?');
INSERT INTO question (5, 'What type of goods is Peshawar famous for?');

INSERT INTO question (6, 'What is the purpose of the Great Wall of China?');
INSERT INTO question (6, 'How long is the Great Wall of China?');
INSERT INTO question (6, 'Why is the Great Wall of China considered a marvel?'

INSERT INTO conversation_data (1,  'Agent: Hi! How can I help you today? Customer: I just wanted to say thank you. The replacement arrived earlier than expected and works perfectly. Agent: That?s great to hear! Is there anything else I can assist you with? Customer: Nope, all good. Appreciate the quick support!');
INSERT INTO conversation_data (2,  'Agent: Hello, how can I assist you? Customer: I?ve been waiting for over a week and still haven?t received my order. This is really frustrating. Agent: I?m sorry to hear that. Let me check the status for you. Customer: I already called twice. Nothing changed.');
INSERT INTO conversation_data (3,  'Agent: Good afternoon! Customer: Just wanted to say your team was super helpful. I had a billing issue and it got resolved within minutes. Agent: Wonderful! We?re glad we could help. Customer: Thanks again!');
INSERT INTO conversation_data (4,  'Agent: Hi there, how can I help? Customer: I?m really disappointed. I was promised a refund last week and still haven?t received it. Agent: I apologize for the delay. Let me escalate this for you. Customer: Please do. I?m tired of waiting.');

Create authorization objects

Use the statement relevant to your cloud platform.

CREATE AUTHORIZATION td_gen_aws_auth
       user '{AWS_ACCESS_KEY}'
       password '{AWS_SECRET_KEY}';
	   Session_Token '{AWS_SESSION_TOKEN}';

CREATE AUTHORIZATION td_gen_azure_auth
       user '{API_BASE}'
       password '{API_KEY}'
       Session_Token '2024-02-15-preview';

CREATE AUTHORIZATION td_gen_gcp_auth
       user '{GCP_PROJECT}'
       password 'us-central1'
       Session_Token '{GCP_ACCESS_TOKEN}';

CREATE AUTHORIZATION td_gen_nim_auth
       user '{API_BASE}'
       password '{API_KEY}';