---
title: Trino
description: Connect Trino to R2 Data Catalog using the Iceberg REST catalog connector.
image: https://developers.cloudflare.com/dev-products-preview.png
---

> Documentation Index  
> Fetch the complete documentation index at: https://developers.cloudflare.com/r2/llms.txt  
> Use this file to discover all available pages before exploring further. 

[Skip to content](#%5Ftop) 

# Trino

Below is an example of using [Trino ↗](https://trino.io/) to connect to R2 Data Catalog. For more information on connecting to R2 Data Catalog with Trino, refer to [Trino documentation ↗](https://trino.io/docs/current/connector/iceberg.html).

## Prerequisites

* Sign up for a [Cloudflare account ↗](https://dash.cloudflare.com/sign-up/workers-and-pages).
* [Create an R2 bucket](https://developers.cloudflare.com/r2/buckets/create-buckets/) and [enable the data catalog](https://developers.cloudflare.com/r2/data-catalog/manage-catalogs/#enable-r2-data-catalog-on-a-bucket).
* [Create an R2 API token, key, and secret](https://developers.cloudflare.com/r2/api/tokens/) with both [R2 and data catalog permissions](https://developers.cloudflare.com/r2/api/tokens/#permissions).
* Install [Docker ↗](https://docs.docker.com/get-docker/) to run the Trino container.

## Setup

Create a local directory for the catalog configuration and change directories to it

Terminal window

```
mkdir -p trino-catalog && cd trino-catalog/
```

Create a configuration file called `r2.properties` for your R2 Data Catalog connection:

```
# r2.propertiesconnector.name=iceberg
# R2 Configurationfs.native-s3.enabled=trues3.region=autos3.aws-access-key=<Your R2 access key>s3.aws-secret-key=<Your R2 secret>s3.endpoint=<Your R2 endpoint>s3.path-style-access=true
# R2 Data Catalog Configurationiceberg.catalog.type=resticeberg.rest-catalog.uri=<Your R2 Data Catalog URI>iceberg.rest-catalog.warehouse=<Your R2 Data Catalog warehouse>iceberg.rest-catalog.security=OAUTH2iceberg.rest-catalog.oauth2.token=<Your R2 authentication token>
```

## Example usage

1. Start Trino with the R2 catalog configuration:  
Terminal window  
```  
# Create a local directory for the catalog configurationmkdir -p trino-catalog  
# Place your r2.properties file in the catalog directorycp r2.properties trino-catalog/  
# Run Trino with the catalog configurationdocker run -d \  --name trino-r2 \  -p 8080:8080 \  -v $(pwd)/trino-catalog:/etc/trino/catalog \  trinodb/trino:latest  
```
2. Connect to Trino and query your R2 Data Catalog:  
Terminal window  
```  
# Connect to the Trino CLIdocker exec -it trino-r2 trino  
```
3. In the Trino CLI, run the following commands:  
```
-- Show all schemas in the R2 catalogSHOW SCHEMAS IN r2;
-- Show all schemas in the R2 catalogCREATE SCHEMA r2.example_schema
-- Create a table with some values in itCREATE TABLE r2.example_schema.yearly_clicks (    year,    clicks)WITH (   partitioning = ARRAY['year'])AS VALUES    (2021, 10000),    (2022, 20000);
-- Show tables in a specific schemaSHOW TABLES IN r2.example_schema;
-- Query your Iceberg tableSELECT * FROM r2.example_schema.yearly_clicks;  
```

```json
{"@context":"https://schema.org","@type":"TechArticle","@id":"https://developers.cloudflare.com/r2/data-catalog/config-examples/trino/#page","headline":"Trino · Cloudflare R2 docs","description":"Connect Trino to R2 Data Catalog using the Iceberg REST catalog connector.","url":"https://developers.cloudflare.com/r2/data-catalog/config-examples/trino/","inLanguage":"en","image":"https://developers.cloudflare.com/dev-products-preview.png","dateModified":"2026-06-08","publisher":{"@type":"Organization","name":"Cloudflare","url":"https://www.cloudflare.com/"},"isPartOf":{"@type":"WebSite","@id":"https://developers.cloudflare.com/#website","name":"Cloudflare Docs","url":"https://developers.cloudflare.com/"}}
{"@context":"https://schema.org","@type":"BreadcrumbList","itemListElement":[{"@type":"ListItem","position":1,"item":{"@id":"/directory/","name":"Directory"}},{"@type":"ListItem","position":2,"item":{"@id":"/r2/","name":"R2"}},{"@type":"ListItem","position":3,"item":{"@id":"/r2/data-catalog/","name":"R2 Data Catalog"}},{"@type":"ListItem","position":4,"item":{"@id":"/r2/data-catalog/config-examples/","name":"Connect to Iceberg engines"}},{"@type":"ListItem","position":5,"item":{"@id":"/r2/data-catalog/config-examples/trino/","name":"Trino"}}]}
```