When ModelTable Contains Only One Model
SELECT * FROM [schema.]DataikuPredict( ON { table | view | (query) } [ as InputTable ] ON { table | view | (query) } [ as ModelTable ] DIMENSION USING Accumulate(column|columns|'*') [ ModelOutputFields(modelOutputField|modelOutputFields) ] [ IsDebug({'true'|'false'}) ] [ OverwriteCachedModel(cached_model_name|'*')] ) as alias ;
When ModelTable Contains Multiple Models
SELECT * FROM [schema.]DataikuPredict( ON { table | view | (query) } as InputTable ON (SELECT*FROM [table | view | {query}) WHERE model_id = model_identifier) [ AS ModelTable ] DIMENSION USING Accumulate(column|columns|'*') [ ModelOutputFields(modelOutputField|modelOutputFields) ] [ IsDebug({'true'|'false'}) ] [ OverwriteCachedModel(cached_model_name|'*')] ) as alias ;