Trino

Connect & Ingest data from / to a Trino database

Sling CLI Setup

The following credentials keys are accepted:

  • http_url (required) -> The url to use to connect (examples: http://user:password@localhost:8080?catalog=memory&schema=test)

  • catalog (required) -> The database / catalog name of the instance

  • schema (optional) -> The default schema to use

  • source (optional) -> Source of the connection

  • session_properties (optional) -> Session properties, as a map[string]string

  • extra_credentials (optional) -> Extra credentials, as a map[string]string

  • custom_client_name (optional) -> Custom client name

  • kerberos_enabled (optional) -> KerberosEnabled (default is false)

  • kerberos_keytab_path (optional) -> Kerberos Keytab Path

  • kerberos_principal (optional) -> Kerberos Principal used to authenticate to KDC

  • kerberos_realm (optional) -> The Kerberos Realm

  • kerberos_config_path (optional) -> The krb5 config path

  • ssl_cert_path (optional) -> The SSL cert path on local disk for TLS verification

  • ssl_cert (optional) -> The SSL cert string value for TLS verification

Here are examples of setting a connection named TRINO. We must provide the type=trino property:

$ sling conns set TRINO type=trino http_url="http://user:password@localhost:8080?catalog=memory&schema=test"

Environment Variable

export TRINO='{ type: trino, http_url: "http://user:password@localhost:8080?catalog=memory&schema=test" }'

Sling Env File YAML

See here to learn more about the sling env.yaml file.

connections:
  TRINO:
    type: trino
    http_url: <http_url>
    catalog: <catalog>
    schema: <schema>
    ssl_cert_path: <ssl_cert_path>

If you are facing issues connecting, please reach out to us at support@slingdata.io, on discord or open a Github Issue here.

Last updated