Developer package utilities

The developer package includes utilities for SSL certificate management and engine management.

watsonx.data Developer edition

These developer package utilities are automatically configured to work with the installed Presto engine.

For more information, see Installing the IBM® watsonx.data developer version.

The developer version supports the following utilities:

presto-cli

Start an interactive session with the Presto engine.

Syntax

Select a specific catalog context for the interactive Presto CLI session. For example:
bin/presto-cli --catalog=tpch

For more information, see Using built-in presto-cli in the developer edition.

presto-run

Run SQL in a non-interactive manner.

Syntax

Use the bin/presto-run utility to run SQL in a noninteractive manner. For example:
bin/presto-run --catalog=tpch <<< "select * from tiny.customer limit 10;"
Run SQL from a file from your LH_SANDBOX_DIR mount. For more information, see Sandbox directory
bin/presto-run -f <path of sql file directory>

For more information, see Running SQL queries by using developer utilities.

python-run

It provides a way to run python scripts.

Syntax

Start an interactive python session.
bin/python-run
Note: The engine details are available as environment variables (ENG_HOST, ENG_PORT, ENG_USERNAME, ENG_PASSWORD). For example,os.environ['ENG_PASSWORD'] provides the saved password for the selected engine.
Run a python script from your LH_SANDBOX_DIR mount. For more information, see Sandbox directory
bin/python-run <python-script-in-sandbox>

For more information, see Running Python scripts by using developer utilities.

dev-sandbox

Provides a containerized environment with useful utilities and python modules to help explore the watsonx.data.

Syntax

Set the sandbox that starts an interactive bash shell from which you can run other commands:
bin/dev-sandbox

For more information, see Running Python scripts in sandbox container by using developer utilities

user-mgmt

It is used to add or remove users to the developer edition and to change passwords for such users. This can be helpful to exercise user access authorizations in watsonx.data Developer edition.

As part of the installation procedure, the ibmlhadminuser is created. During setup, the --password=<ibmlhadmin password> argument can be used to select a password. If a password is not selected, then the default password is password.

Syntax

Use the add-user command to introduce a new user ID. For example:
user-mgmt add-user <username> <role> [password]
Note: 'Role' must either be 'Admin' or 'User'.

If a password for this user is not set on the command line (recommended), then you are prompted to enter the new password and confirm. For example: user-mgmt add-user tom User password

Use the delete-user command to delete an existing user ID. For example, user-mgmt delete-user tom
user-mgmt delete-user <username>
Use the change-password command to set a new password for a user ID or default user. For example:
user-mgmt change-password <username>
You are prompted to enter the new password and confirm. For example: 
user-mgmt change-password ibmlhadmin