Load Model with BTEQ | Vantage BYOM - Loading Model with BTEQ - Teradata Vantage

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

Deployment
VantageCloud
VantageCore
Edition
Enterprise
IntelliFlex
Lake
VMware
Product
Teradata Vantage
Release Number
5.0
Published
October 2023
Language
English (United States)
Last Update
2023-12-19
dita:mapPath
fee1607120608274.ditamap
dita:ditavalPath
ayr1485454803741.ditaval
dita:id
fee1607120608274
  • 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, MOJO, Dataiku, or DataRobot 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);