When ModelTable Contains Only One Model
SELECT * FROM [schema.]PMMLPredict (
ON { table | view | (query) } [ AS InputTable ]
ON { table | view | (query) } [ AS ModelTable ] DIMENSION
USING
Accumulate ({ accumulate_column [,...] | '*' })
[ ModelOutputFields (model_output_field [,...])]
[ OverwriteCachedModel(current_cached_model_name|'*'|'true'|'t'|'yes'|'y'|'1'|'false'|'f'|'no'|'n'|'0')]
) as alias ;
When ModelTable Contains Multiple Models
SELECT * FROM [schema.]PMMLPredict(
ON { table | view | (query) } [ AS InputTable ]
ON (SELECT * FROM { table | view | (query) } WHERE model_id = model_identifier) [ AS ModelTable ] DIMENSION
USING
Accumulate ({ accumulate_column [,...] | '*' })
[ ModelOutputFields (model_output_field [,...])]
[ OverwriteCachedModel(current_cached_model_name|'*'|'true'|'t'|'yes'|'y'|'1'|'false'|'f'|'no'|'n'|'0')]
[ IsDebug({'true'|'false'}) ]
) as alias ;