Create A Model Table | BYOM | Teradata Vantage - 2.0 - Creating Model Tables - Teradata Vantage

Teradata Vantageā„¢ - Bring Your Own Model User Guide

Product
Teradata Vantage
Release Number
2.0
Release Date
October 2021
Content Type
User Guide
Publication ID
B700-1111-051K
Language
English (United States)
  • Create a Vantage table to store the models.
    PMML and H2O models can reside in the same table. However, Teradata recommends having separate tables when the H2O DAI license key is in the model table. See Option 2 in Load the H20 Driverless AI License. PMML and H2O open source models do not require a license.

    The table must have a model identifier, which must be a single column named model_id of data type VARCHAR, and a column named Model for the model itself (see a ModelTable schema in PMMLPredict Input or H2OPredict Input).

    For example, the following statement creates a ModelTable:
    CREATE SET TABLE pmml_models (
      model_id VARCHAR (30),
      model BLOB
    )
    PRIMARY INDEX (model_id);