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
6.0
Published
March 2025
ft:locale
en-US
ft:lastEdition
2025-03-21
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);