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 jwt

---

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

---

Serverless Requirements

If you're running CS Tools    serverless, you'll want to ensure you install these    python requirements.

Don't know what this means? It's probably safe to ignore it.

How do I use the Syncer in commands?

CS Tools accepts syncer definitions in either declarative or configuration file form.

_{Find the copy button to the right of the code block.}

  Declarative   Configuration File

Simply write the parameters out alongside the command.

cs_tools tools searchable metadata --syncer "trino://host=coordinator.thoughtspot.com&catalog=thoughtspot&schema=cs_tools&authentication=basic&username=tsadmin&secret=[redacted]" --config dogfood

^{* when declaring multiple parameters inline, you should wrap the enter value in quotes.}

1. Create a file with the .toml extension.

   syncer-overwrite.toml

   [configuration]
   host = "coordinator.thoughtspot.com"
   port = 8080
   catalog = "thoughtspot"
   schema = "cs_tools"
   authentication = "basic"
   username = "tsadmin"
   secret = "[redacted]"
   load_strategy = "TRUNCATE"
   

   ^{* this is a complete example, not all parameters are required.}

2. Write the filename in your command in place of the parameters.

   cs_tools tools searchable metadata --syncer trino://syncer-overwrite.toml --config dogfood