-
From a client application (such as BTEQ or Teradata Studio), log on to Vantage as DBC. For example:
.logon systemname.your_company.com/dbc
where systemname is the primary database node (the name by which Vantage is known to the network, also called the TDPID).
If you run this as another user, the user must have the ANY privilege granted on the server object (td_server_db.coprocessor) to display the output from HELP FOREIGN SERVER. -
Run the command:
help foreign server td_server_db.coprocessor;
The command returns a list of databases on the Machine Learning Engine. For example:Name ------------------ beehive
If an error results:
Error Condition Result Resolution MLE functions are available, the user does not have permissions on the foreign server # help foreign server td_server_db.coprocessor; *** Failure 3523 The user does not have any access to TD_SERVER_DB.coprocessor.
You can grant the user permission. Run: GRANT EXECUTE FUNCTION on TD_SERVER_DB.coprocessor TO <user>;
MLE functions are not available # help foreign server td_server_db.coprocessor; *** Failure 3807 Object 'TD_SERVER_DB.coprocessor' does not exist.
Contact Teradata Customer Support.