# Trino

In order to grant Trino access to UltiHash, users need to create and configure a catalogue called UltiHash, with the ultihash.properties text file as follows:

```python
connector.name=hive
hive.metastore.uri=thrift://hive-metastore:9083
hive.non-managed-table-writes-enabled=true
hive.s3.path-style-access=true
hive.s3.endpoint=https://ultihash
hive.s3.aws-access-key=mocked
hive.s3.aws-secret-key=mocked
```

In this file, we setup the Hive connector, which is using S3A connector under the hood. This enables Trino to integrate and communicated with UltiHash.

Each catalogue points at a UltiHash Cluster, and within a catalogue the user can create SQL tables which point at specific buckets in the UltiHash Cluster. Each catalogue can host several SQL tables.

> See all information about the integration on GitHub here: <https://github.com/UltiHash/scripts/tree/main/trino>