This documentation page assumes that you already have a SeekTable account. Create your free account by signing up.

Presto/Trino BI Tool for pivot tables, charts, tabular reports

SeekTable is a self-service Presto/Trino BI tool that allows users to create pivot tables, charts, and flat table reports directly from Presto/Trino databases:

Building a Presto/Trino pivot table in SeekTable

Live Presto/Trino connection: report queries execute in real-time, meaning your operational reports always up-to-date (no need in refreshes).
No ETL / zero data extraction: analyze massive datasets directly in your data warehouse, no data imports required.
Designed for business users: Excel-like web interface enables non-IT users to perform fast data analysis and data visualization without writing SQL or exporting sensitive data.
Governed data access: safely share common reports and data cubes with RLS. End-users queries are limited to configured data models (no direct SQL access to Presto/Trino).
On-premise reporting tool: self-hosted SeekTable meets strict corporate compliance and data governance requirements. It supports fully isolated deployment environments to deliver real-time insights without your data ever leaving your internal network.
Embedded BI: seamlessly integrate SeekTable published reports and dashboards directly into your web app. Or embed the entire SeekTable app view to let them build their own reports directly inside your app.
White-labeling: apply your own logo, branding, and UI styles to make SeekTable look exactly like your company's own in-house reporting solution.

Setup Presto/Trino Connection

Connection String example (NReco.PrestoAdo .NET driver):

Host=hostName;Port=8080;UseSsl=false;Schema=defaultSchema;Catalog=catalog;User=user;Password=password;

TrinoHeaders	Whether to use "X-Trino-" prefix in HTTP request headers (boolean; `false` by default - means that 'legacy' "X-Presto-" prefix is used).
Host	The DNS host name or IP address of the presto/trino coordinator with REST API v1.
Port	The web interface port of the presto/trino coordinator (8080 by default).
UseSsl	Specifies that the connections made to the presto coordinator and possibly worker nodes should use SSL.
Catalog	The catalog to use for interaction with presto/trino.
Schema	The schema to connect to in presto/trino ('default' by default).
User	The name of the user connecting to presto.
Password	The password to use in HTTP basic auth with the presto server.
CheckInterval	The amount of time in milliseconds that the client will wait in between checks for new data from presto. The minimum interval is 50ms and the maximum interval is 5000ms (800ms by default).
IgnoreSslErrors	Whether to ignore SSL errors produced by connecting to presto over an SSL connection that may be using expired or untrusted certificates (boolean; `false` by default).
ClientRequestTimeout	The timeout in seconds for how long to wait for a query to finish (no timeout by default).

Trino notes

By default SeekTable Presto driver uses "X-Presto-" prefix in HTTP headers. It can be used to connect to Trino in one of these ways:

specify TrinoHeaders=1 in a connection string to use "X-Trino-" headers by SeekTable Presto driver
configure Trino to accept Presto headers in a compatiblity mode:
```
protocol.v1.alternate-header-name=Presto
```