DataikuPredict Example JSON Report | Vantage BYOM - DataikuPredict Example: JSON Report - Teradata Vantage

select * from mldb.DataikuPredict(
 on iris_test
 on (select * from dataiku_models where model_id='di_ir_dt_ann_thin') DIMENSION
 using
Accumulate('id')
) as td;
 
 *** Query completed. 30 rows found. 3 columns returned.
 *** Total elapsed time was 1 second.

         id prediction                json_report
----------- ------------------------- ------------------------------------------------------------------------------------------------------------------------------------------------------------------
         80 '2'                       {"species":"'2'","prob_class_3":0.2731788965259344,"all_class_labels":"['3', '2', '1']","prob_class_2":0.5729669225258344,"prob_class_1":0.15385418094823136,"all_
         45 '1'                       {"species":"'1'","prob_class_3":0.2411569046296039,"all_class_labels":"['3', '2', '1']","prob_class_2":0.20856480192396082,"prob_class_1":0.5502782934464352,"all_
         15 '1'                       {"species":"'1'","prob_class_3":0.20558190766423365,"all_class_labels":"['3', '2', '1']","prob_class_2":0.24680324284626629,"prob_class_1":0.5476148494895,"all_cl
         30 '1'                       {"species":"'1'","prob_class_3":0.06963549384822368,"all_class_labels":"['3', '2', '1']","prob_class_2":0.24433084111062764,"prob_class_1":0.6860336650411486,"all
         25 '1'                       {"species":"'1'","prob_class_3":0.10901460883962828,"all_class_labels":"['3', '2', '1']","prob_class_2":0.22364079180119173,"prob_class_1":0.66734459935918,"all_c
         70 '2'                       {"species":"'2'","prob_class_3":0.25014618964032026,"all_class_labels":"['3', '2', '1']","prob_class_2":0.5982374795803547,"prob_class_1":0.15161633077932507,"all
        115 '3'                       {"species":"'3'","prob_class_3":0.4984983853841108,"all_class_labels":"['3', '2', '1']","prob_class_2":0.2718582851837623,"prob_class_1":0.22964332943212684,"all_
        135 '2'                       {"species":"'2'","prob_class_3":0.38587464501653135,"all_class_labels":"['3', '2', '1']","prob_class_2":0.4760568494785199,"prob_class_1":0.13806850550494876,"all
         50 '1'                       {"species":"'1'","prob_class_3":0.09101376559530465,"all_class_labels":"['3', '2', '1']","prob_class_2":0.2737413070457125,"prob_class_1":0.635244927358983,"all_c
        100 '2'                       {"species":"'2'","prob_class_3":0.3201181076336191,"all_class_labels":"['3', '2', '1']","prob_class_2":0.46648435183255704,"prob_class_1":0.21339754053382382,"all
...