Deploy Trino with the trino template

Stand up Trino, an open-source federated SQL query engine, on a single Quake AI instance using the validated OpenTofu template trino. You apply the template, run a smoke-test query against the built-in sample catalog, and wire in a Postgres warehouse when you have one.

Trino is the query layer over your lakehouse stack. You run it yourself; this is a self-hosted tool you operate, not a hosted query service.

Monthly cost estimate

Pricing calculator ↗

Sized as a custom package on dedicated vCPU.

Starting template$137.40/mo

Monthly total for the required template above. Use the configurator below to add optional pieces and see the total update.

What each resource is for

Trino

m2a.xlarge · 4 dedicated vCPU, 16 GiB RAM, 1 Gbps

$132.00/mo

Compute shown per role at custom-package rates ($29/dedicated vCPU, $7.25/shared vCPU, $1/GiB RAM). The headline above is the billed total: the cheaper of a named plan and the custom package, plus add-ons.

Included in baseline

m2a.xlarge

4 dedicated vCPU, 16 GiB RAM, 1 Gbps

$132.00

Compute + RAM rate basis

4 vCPU + 16 GiB RAM at $29/dedicated vCPU, $7.25/shared vCPU, $1/GiB RAM (regular). Totals apply the flat −$5/mo package promotion.

—

Block storage (130 GiB)

130 GiB at $0.08/GiB/mo

$10.40

Public IP (included)

1 included with the custom package

$0.00

Package promotional discount

Flat −$5.00/mo on the custom package (same promotion as named plans).

$-5.00

Included at no charge

These line items are zero on Quake AI. Many other providers meter them separately.

Data transfer (inbound and outbound)

Unlimited data transfer on every plan; Quake AI does not meter per-GB egress.

AWS, GCP, and Azure meter outbound transfer per GB. DigitalOcean and Hetzner include an allowance on compute plans, then charge overage.

Learn more

$0.00

Private networking

Private networks, subnets, Neutron routers, and security groups are included with the plan.

VPC objects are usually free to create elsewhere, but NAT gateways bill hourly plus per-GB processed. Quake AI uses router SNAT with no separate NAT line item.

$0.00

Control-plane API requests

OpenStack API calls for provisioning and management are included.

Some managed services on other clouds meter API calls or charge for premium control-plane features.

$0.00

Dev/test vs production

Start on shared CPU for dev/test, then promote to dedicated for production with a flavor resize. The network, storage, and template stay the same.

Dev/test on shared CPU

Burstable s1a flavors; suited to prototyping and low or bursty load.

$38.40/mo

Production on dedicated CPU

The headline estimate above; predictable steady-load performance.

$137.40/mo

Saves $99.00/mo while you build on shared CPU.

Shared flavors carry less RAM (m2a.xlarge (16 GiB RAM) -> s1a.medium (4 GiB RAM)). A resize reboots the instance; data on attached volumes persists. Size the dedicated flavor for the RAM your production workload needs.

Pricing data last validated: 2026-09-16. For current rates, check quake.ai/pricing.

Prerequisites#

You need OpenTofu 1.6.0 or later, OpenStack credentials sourced into the shell, an SSH keypair in your project, a copy of the trino template from the template reference page, and your workstation public IP for first-boot UI access.

Step 1: Apply the template#

Copy terraform.tfvars.example to terraform.tfvars, set key_name and ui_allowed_cidr = "YOUR_IP/32", then run:

bash

tofu init
tofu plan
tofu apply

Record floating_ip and ui_url from tofu output.

Step 2: Run a smoke-test query#

Open ui_url in your browser. When the Trino UI loads, run:

SQL

SELECT nationkey, name
FROM tpch.tiny.nation
ORDER BY nationkey
LIMIT 5;

Trino returns five rows from the built-in tpch sample catalog.

Step 3: Wire in a Postgres catalog (optional)#

SSH to the instance and create /opt/trino/catalog/postgres.properties with your warehouse connection, including connection-password. Restart the stack:

bash

cd /opt/trino
sudo docker compose restart

See the Trino template reference for ClickHouse and Iceberg catalog shapes.

Clean up#

bash

tofu destroy

Deploy Trino with the trino template

Deploy Trino with the trino template

Monthly cost estimate

Prerequisites#

Step 1: Apply the template#

Step 2: Run a smoke-test query#

Step 3: Wire in a Postgres catalog (optional)#

Clean up#

Next steps#

See Also