Skip to main content
Here are some general guidelines for connecting JavaScript or TypeScript code to the Honeydew JDBC interface. Honeydew can integrate with JavaScript and TypeScript applications using the Trino JavaScript client package.
Before you start, make sure you have the Trino JavaScript client installed:
npm install trino-client
If your organization uses a custom hostname for the JDBC connection, you can locate it in the Honeydew UI, under the JDBC section in Settings.
It is recommended to use an API Key for setting up the connection.
import {Trino, BasicAuth} from 'trino-client';

const trino = Trino.create({
  // If your organization uses a custom hostname for the JDBC connection,
  // you can locate it in the Honeydew UI, under the JDBC section in Settings.
  server: 'https://jdbc.honeydew.cloud',

  // For credentials, pass the API key (or a Honeydew username),
  // and the API secret (or the Honeydew password).
  auth: new BasicAuth('<api key name>', '<api key secret>'),

  // catalog is based on the Honeydew "workspace" and "branch"
  // you would like to connect to.
  // Omit the branch value if connecting to "prod".
  // For example, for workspace "tpch", branch "prod",
  // the value would be: "tpch".
  catalog: '<workspace>__<branch>',

  schema: 'domains',
});

// List available domains
const tablesIter = await trino.query('SHOW TABLES FROM domains');
for await (const result of tablesIter) {
  console.log(result.data);
}

// Query a domain
const queryIter = await trino.query(
  'SELECT "orders.o_orderdate", AGG("lineitem.revenue") FROM domains.my_domain'
);
for await (const result of queryIter) {
  console.log(result.data);
}