Trino

Trino is a powerful, open-source database tool that helps you analyze and explore large amounts of data really quickly. Imagine you have a bunch of data spread across different places - like files stored in the cloud, databases, and other data sources. Trino lets you access all of that data in one place, using standard SQL queries, without having to move or copy the data around.

Trino parameters

Required parameters are in red and Optional parameters are in blue.

---

• host, the IP address or URL of your Trino catalog

---

• port, the port number where your Trino catalog is located
  default: 8080

---

• catalog, the catalog to write new data to
  if tables do not exist in the catalog.schema location already, we'll auto-create them

---

• schema, the schema to write new data to
  default: public, if tables do not exist in the catalog.schema location already, we'll auto-create them

---

• authentication, the type of authentication mechanism to use to connect to Trino
  ( allowed: basic, jwt )

---

• username, your Trino username

---

• secret, the secret value to pass to the authentication mechanism
  this will be either a password or json web token

---

• load_strategy, how to write new data into existing tables
  default: APPEND ( allowed: APPEND, TRUNCATE, UPSERT )

How do I use the Trino syncer in commands?

cs_tools tools searchable bi-server --syncer trino://host=0.0.0.0&catalog=...&schema=cs_tools&authentication=basic&username=admin&load_strategy=upsert

- or -

cs_tools tools searchable bi-server --syncer trino://definition.toml

Definition TOML Example

definition.toml

[configuration]
host = "0.0.0.0"
catalog = "..."
schema = "cs_tools"
authentication = "basic"
username = "admin"
load_strategy = "upsert"