Trino
Overview
This guide provides instructions on how to set up and use Trino with DBeaver.
Before you start, you must create a connection in DBeaver and select Trino. If you haven’t done this yet, see our Database Connection article.
DBeaver connects to Trino using a dedicated JDBC driver. It supports all modern Trino versions. If you’re working with older Presto (PrestoSQL) setups, you can also use the Presto driver. For newer deployments, use the Trino driver for better compatibility and feature support.
Trino specialty
Trino is a fast, distributed SQL engine designed for querying large datasets across different data sources. It lets you work with data where it lives - whether in databases, data lakes, or file systems - without copying or moving it. You can run SQL queries across multiple systems at once, joining data from sources like Hive, Iceberg, PostgreSQL, or S3.
Trino is built for scalability and performance. It uses a coordinator and worker architecture that supports high concurrency and horizontal scaling. Security and access control can be managed using external tools or plugins, with support for various authentication methods and permissions.
Info
For more, see the Trino documentation.
Setting up
This section provides an overview of DBeaver's settings for establishing a direct connection and the configuration of secure connections using SSH, proxies, AWS SSM and Kubernetes.
Trino connection settings
In this subsection, we will outline the settings for establishing a direct connection to a Trino database using DBeaver. Correctly configuring your connection ensures seamless interaction between DBeaver and your Trino database.
The connection settings page requires you to fill in specific fields to establish the initial connection.
| Field | Description |
|---|---|
| Connect by (Host/URL) | Choose whether you want to connect using a host or a URL. |
| URL | If you are connecting via URL, enter the URL of your Trino database here. This field is disabled if you're connecting via the host. |
| Host | If you are connecting via host, enter the host address of your Trino database here. |
| Database/Schema | Enter the name of the Trino database you want to connect to. |
| Port | Enter the port number for your Trino database. The default Trino port is 8080. |
| Authentication | Choose the type of authentication you want to use for the connection. For detailed guides on authentication types, please refer to the following articles: - Native Database Authentication - DBeaver Profile Authentication  - Trino Kerberos Authentication You can also read about security in DBeaver PRO. |
| Connection Details | Provide additional connection details if necessary. |
| Driver Name | This field will be auto-filled based on your selected driver type. |
| Driver Settings | If there are any specific driver settings, configure them here. |
Connection details
The Connection Details section in DBeaver allows you to customize your experience while working with Trino database. This includes options for adjusting the Navigator View, setting up Security measures, applying Filters, configuring Connection Initialization settings, and setting up Shell Commands. Each of these settings can significantly impact your database operations and workflow. For detailed guides on these settings, please refer to the following articles:
- Connection Details Configuration
- Database Navigator
- Security Settings Guide
- Filters Settings Guide
- Connection Initialization Settings Guide
- Shell Commands Guide
Secure Connection Configurations
DBeaver supports secure connections to your Trino database. Guidance on configuring such connections, specifically SSH, Proxy, Kubernetes, and AWS SSM connections, can be found in various referenced articles. For a comprehensive understanding, please refer to these articles:
Secure Storage with Secret Providers
DBeaver supports various cloud-based secret providers to retrieve database credentials. For detailed setup instructions, see Secret Providers.
Powering Trino with DBeaver
DBeaver provides a host of features designed for Trino databases. This includes the ability to view and manage databases, along with numerous unique capabilities aimed at optimizing database operations.
Trino database objects
DBeaver lets you view and manipulate a wide range of Trino database objects. DBeaver has extensive support for various Trino metadata types, allowing you to interact with a wide variety of database objects, such as:
- Databases (schemas)
- Tables
- Columns
- Views
- Tables
Trino Features in DBeaver
DBeaver is not limited to typical SQL tasks. It also includes numerous unique features specifically for Trino. Beyond regular SQL operations, DBeaver provides a range of Trino-specific capabilities, such as:
| Category | Feature |
|---|---|
| Data Types | Native support for complex and custom types:map, row, json, hyperloglog, geometry, ipaddress, uuid, jsonpath, etc. |
| Metadata Access | Explore information_schema and Trino's internal system schemas |
Additional features compatible with Trino, but not exclusive to it:
| Category | Feature |
|---|---|
| Data Transfer | Data Import |
| Data Export | |
| Data Compare | Data Compare |
| Data Generation | Mock Data Generation |