Similar to how you created the prior database tables, you can use Teradata Studio to update the database.
- Use the following code to create the CUSTOMER_PROFILE table in the tutorial database:
CREATE TABLE CUSTOMER_PROFILE ( Entity_id INTEGER, age INTEGER, region VARCHAR(100), voice_calls_avg DECIMAL(5,0), data_usage_avg DECIMAL(5,0), sms_usage_avg DECIMAL(5,0) );
This table contains the customer profile attributes - Use the Teradata Studio Load Data Wizard to import the tutorial_customer_profiles.csv file, which is included in the tutorial ZIP file.
- Use the following code to create the TUTORIAL_CUSTOMER_EXTENDED_EVENTS table in the tutorial database:
CREATE TABLE TUTORIAL_CUSTOMER_EXTENDED_EVENTS ( entity_id INTEGER, event VARCHAR(100) CHARACTER SET LATIN, datestamp TIMESTAMP, age INTEGER, region VARCHAR(100), voice_calls_avg DECIMAL(5,0), data_usage_avg DECIMAL(5,0), sms_usage_avg DECIMAL(5,0) );
The character set must be LATIN.