Load Model with BTEQ | Vantage BYOM - 2.0 - Loading Model with BTEQ - 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)
  • Load the model into the Vantage table (model_table):

    Create a file that has a column for a model identifier and a column for the model file name (the file that contains the PMML or MOJO model):

    .import vartext file text_table.txt
    .repeat * 
    USING (c1 VARCHAR(20), c2 BLOB AS DEFERRED BY NAME) INSERT INTO model_table(:c1, :c2);
    For example, suppose the file has the following content:
    iris_db_rf_model|iris_db_rf_model.pmml

    Create a file load_pmml_model.txt with model identifier iris_db_rf_model and model file name iris_db_rf_model.pmml:

    .import vartext file load_pmml_model.txt
    .repeat * 
    USING (c1 VARCHAR(20), c2 BLOB AS DEFERRED BY NAME) INSERT INTO pmml_models(:c1, :c2);