Prerequisites to run teradataml open-source machine learning functions when your local machine is connected to VantageCloud Enterprise:
- Execution of the teradataml open-source machine learning functions depends on the Script table operator.
The Script table operator setup is done on Vantage.
- Administrator provides the standard permissions required by Script table operator to the database user.
- Administrator sets the following standard permissions for the database <user>:
GRANT EXECUTE FUNCTION ON td_sysfnlib.script TO <user>; GRANT CREATE EXTERNAL PROCEDURE ON <user> TO <user>; GRANT DROP PROCEDURE ON <user> TO <user>; GRANT EXECUTE PROCEDURE ON SYSUIF.INSTALL_FILE TO <user>; GRANT EXECUTE PROCEDURE ON SYSUIF.REPLACE_FILE TO <user>; GRANT EXECUTE PROCEDURE ON SYSUIF.REMOVE_FILE TO <user>; GRANT EXECUTE ON SYSUIF.DEFAULT_AUTH TO <user>;
- Administrator sets the following permission for OpensourceML:
GRANT CREATE EXTERNAL PROCEDURE ON SYSUIF TO <user>;
- If the default user database <userDB> is different from the <user> database, set the following permissions:
GRANT CREATE EXTERNAL PROCEDURE ON <userDB> TO <user>; GRANT DROP PROCEDURE ON <userDB> TO <user>; GRANT EXECUTE FUNCTION ON td_sysfnlib.script TO <userDB> WITH GRANT OPTION; GRANT EXECUTE ON SYSUIF.DEFAULT_AUTH TO <userDB> WITH GRANT OPTION;
- Version of the open-source package on your local machine should be the same as the one installed in Vantage as part of the Script table operator setup.
You can use db_python_package_details() to check the version of installed packages.
If Teradata In-nodes Python Packages (STO) is installed on Vantage, there are additional requirements based on different versions of the Teradata In-nodes Python Packages.
- For Teradata In-nodes Python Packages v1.0.x:
- The Python executable is /opt/teradata/languages/Python/.Set the following to make sure teradataml open-source machine learning functions could invoke the interpreter.
from teradataml import configure
configure.indb_install_location = "/opt/teradata/languages/Python/"
- scikit-learn version on your client is expected to be v0.24.2 as STO has scikit-learn version 0.24.2.
- The Python executable is /opt/teradata/languages/Python/.
- For Teradata In-nodes Python Packages v2.0.0:
- The Python executable is present in the directory /var/opt/teradata. teradataml open-source machine learning functions use this location by default.If Vantage raises "python interpreter file not found" exception, set the following to make sure teradataml open-source machine learning functions could invoke the interpreter.
from teradataml import configure
configure.indb_install_location = "/var/opt/teradata/languages/sles12sp3/Python/"
- Upgrade or downgrade the scikit-learn library on your client to v1.1.3 to keep it similar to the scikit-learn version on STO v2.0.0.
- The Python executable is present in the directory /var/opt/teradata. teradataml open-source machine learning functions use this location by default.