Trino Connector

The high-performance Trino Connector provides read/write capabilities within your application, allowing you to perform numerous Trino operations with minimal coding or even no-coding at all. Integrate Trino data into applications such as SSIS, SQL Server, any ODBC-compatible application, or even directly within a programming language using this connector.

Download

Integrate Trino with these applications

All
Data Integration
Database
BI & Reporting
Productivity
Programming Languages
Automation & Scripting
ODBC applications

SQL examples for Trino Connector

Use these example Trino SQL queries within SSIS, SQL Server or any ODBC-compatible application:

Get orders

This query uses sample data from Docker Trino image.

SELECT * FROM tpch.sf1.orders

Get open orders

This query uses sample data from Docker Trino image.

SELECT * 
FROM tpch.sf1.orders
WHERE orderstatus = 'O'

Count orders grouped by priority

This query uses sample data from Docker Trino image.

SELECT orderpriority, COUNT(*) as count
FROM tpch.sf1.orders
GROUP BY orderpriority
ORDER BY orderpriority

Get all customer orders

This query uses sample data from Docker Trino image.

SELECT c.name, o.orderkey, totalprice
FROM tpch.sf1.orders as o
JOIN tpch.sf1.customer as c on c.custkey = o.custkey

Sum all orders price per customer

This query uses sample data from Docker Trino image.

SELECT c.name, SUM(totalprice) as totalprice
FROM tpch.sf1.orders as o
JOIN tpch.sf1.customer as c on c.custkey = o.custkey
GROUP BY c.name
ORDER BY c.name

Download