Configuration Settings for Trino Apps
The configuration.yaml file for Trino should include this section with details for connecting to a VAST Database:
vast: 'connector.name: vast
endpoint: ENDPOINT
access_key_id: VAST_ACCESS_KEY
secret_access_key: VAST_SECRET_KEY
data_endpoints: DATA_ENDPOINTS
vast.http-client.request-timeout: 100h
vast.http-client.idle-timeout: 290s
num_of_splits: 512
num_of_subsplits: 4
'
where VAST_ACCESS_KEY and VAST_SECRET_KEY are the access and secret keys for a VMS user with permissions to create and access VAST Databases (see Pre-requisites), and ENDPOINT and DATA_ENDPOINTS are the Coordinator VIP.
Downloading and Configuring the Trino Client
Run this command to download the Trino client jar
wget https://repo1.maven.org/maven2/io/trino/trino-cli/<version>/trino-cli-<version>-executable.jar -O trino chmod +x trinowhere
<version>is the Trino version of the client (for example, 429).
Using the Trino Client to Connect to the Trino Managed App
Run this command on the client to connect to the Trino app:
./trino --server <VIP>:8080 --catalog vast --schema <schema> --user <username> where VIP is the Coordinator VIP, schema is your schema in the VAST database, and username is the VMS user created for Trino.