As an interface to the SCRIPT table operator object in Advanced SQL Engine, Script offers execution in two modes:
- Test/Debug mode: to test user scripts locally in a containerized environment. Supported methods:
- setup_sto_env: set up test environment.
- test_script: test user script in containerized environment.
- set_data: set test data parameters.
- In-Database Script Execution mode: to execute user scripts in database.Supported methods:
- execute_script: execute user script in Vantage.
- install_file: install or replace file in database.
- remove_file: remove installed files from database.
- set_data: set test data parameters.
Required Docker and OS Versions
setup_sto_env method and test_script method are supported on the following platforms with Docker 19.03.5 or later versions:
- Ubuntu 16.04.2 LTS or later versions
- CentOS Linux 7 or later versions
- RHEL 7.1 or later versions
- Windows 10 or later versions
- macOS 13 or later versions
All other methods: set_data, execute_script, install_file, remove_file, do not require Docker and work on all teradataml supported platforms.
setup_sto_env method and test_script method will not work on VMs that do not have docker setup.
Users will encounter issues with docker setup on VMs that do no support nested virtualization. For example, "Failed to start the virtual machine name of virtual machine because one of the Hyper-V components is not running."
See https://docs.docker.com/docker-for-windows/troubleshoot/#running-docker-desktop-for-windows-in-nested-virtualization-scenarios for details about this issue.