DataikuPredict Example: Loading Model with BTEQ - Teradata Vantage

-- load generated model using BTEQ client
 
 
-- Make sure that the model table "dataiku_models" exists and has two columns: model_id as "varchar" and model as "BLOB" type
-- Create a file load_Dataiku_model.txt that has a model_id and a model file name entry such as:
-- iris_db_rf_model|iris_db_rf_model.jar
 
.import vartext file load_Dataiku_model.txt
.repeat * 
USING (c1 VARCHAR(30), c2 BLOB AS DEFERRED BY NAME) INSERT INTO dataiku_models(:c1, :c2);