Cloudera Docs

Connecting to a Trino Virtual Warehouse from a BI client

You can connect BI tools and SQL clients to a Trino Virtual Warehouse to explore and query data. Cloudera Data Warehouse provides built-in downloadables such as Trino JDBC/ODBC driver for connecting JDBC/ODBC-compliant tools to the Virtual Warehouses.

  1. Log in to the Cloudera Data Warehouse service as DWUser.
  2. In the Overview page of the Cloudera Data Warehouse service, click See More in the Resources and Downloads tile.
  3. Click Trino JDBC/ODBC Driver to download the Trino JDBC and ODBC drivers zip file.
  4. Provide the JAR file that you downloaded to your JDBC or ODBC client.
    On most clients, add the JAR file under the Libraries folder. Refer to your client documentation for information on the location to add the JAR file.
  5. In the Cloudera Data Warehouse service Overview page, for the Trino Virtual Warehouse you want to connect to the client, click and select Copy Trino JDBC URL.
    A URL is copied to your system clipboard in the following format:
    jdbc:trino://<your_virtual_warehouse>.<your_environment>.<dwx.company.com>:<port>
  6. Configure your client BI tool to connect to the Virtual Warehouse using the copied JDBC URL.