1.1 - 8.10 - Where Functions Save Output Files - Teradata Vantage

Teradata Vantage™ - Machine Learning Engine Analytic Function Reference

Teradata Vantage
Release Number
October 2019
Content Type
Programming Reference
Publication ID
English (United States)

Model Files

Functions that output model files save them on the user schema on ML Engine.

If you run multiple instances of a function simultaneously, each run must use a unique name for each output file.

Nonmodel Output Files

By default, functions save nonmodel output files to the user database. To save an output table to a different database, prefix the table name with the database name; for example:

SELECT * FROM UnivariateStatistics (
  ON abc_table AS InputTable
  OUT TABLE MomentsTableName (db1.moments)
  OUT TABLE BasicTableName (db1.basic)
  OUT TABLE QuantilesTableName (db1.quantiles)
) AS dt;