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

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

Product
Teradata Vantage
Release Number
3.0
Published
May 2022
Last Update
2022-06-02
Content Type
User Guide
Publication ID
B700-1111-051K
Language
English (United States)
  • Create a Vantage table to store the models.
    PMML, H2O, and ONNX 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 H2O 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);