Create the Tutorial Tables | Vantage Analyst - Creating the Tables - Teradata Analytic Apps

Using Teradata Studio™, you can create and populate the sample database. For complete information, see Teradata Studio™ User Guide.

Create the tutorial data tables using the following code:

CREATE TABLE TUTORIAL_WEB
(
    web_cust_id     INTEGER,
    page_ts         TIMESTAMP,
    web_page        VARCHAR(100)
);
CREATE TABLE TUTORIAL_TRANS
(
    account_id     INTEGER,
    tran_ds        TIMESTAMP,
    tran_cd        VARCHAR(100)
);
CREATE TABLE TUTORIAL_SUPPORT
(
    customer_id     INTEGER,
    ticket_ds       TIMESTAMP,
    issue_cd        VARCHAR(100)
);

Use the Teradata Studio Load Data Wizard to import the CSV files which are included in the tutorial ZIP file into the appropriate table.
Use following code to create an Events table for Vantage Analyst called TUTORIAL_CUSTOMER_EVENTS. The new table will contain the integrated events from the three event source tables.
```
CREATE TABLE TUTORIAL_CUSTOMER_EVENTS
(
    entity_id     INTEGER,
    datestamp     TIMESTAMP,
    event         VARCHAR(100) CHARACTER SET LATIN
);
```
The character set must be LATIN.

Use the following code to create a table to hold the generated path customer segment.

create table TUTORIAL_PATH_SEGMENT_EXPORT
(
    entity_id    varchar(100),
    path         varchar(1000)
);

Use the following code to create a table to hold the nPath query.
```
create table  STORED_NPATH_QUERIES
(
    id   varchar(100),
    name varchar(1000),
    query varchar(32000)
);
```
This table may already exist, as part of your installation.

Create the Tutorial Tables | Vantage Analyst - Creating the Tables - Teradata Analytic Apps - Vantage Analyst

Vantage Analyst Path Analysis Tutorial