New Zealand’s data landscape has long been shaped by the challenges of distributed, heterogeneous datasets—from legacy systems buried in government archives to the explosion of real-time sensor data in agriculture and logistics. Enter trino homepage, the open-source SQL query engine that’s quietly becoming the backbone of modern data lakes across the country. While Trino’s global adoption has been well-documented, its specific impact in Aotearoa remains understated. This isn’t just another tool in the stack; it’s transforming how organisations extract insights from their data lakes, particularly in sectors where precision and scalability are non-negotiable.
At its core, Trino—formerly known as PrestoSQL—is designed for fast, cost-effective querying of petabytes of data across multiple storage systems. Unlike traditional OLAP databases that require data to be materialised into a single schema, Trino lets users run SQL queries directly against raw data in formats like Parquet, ORC, or JSON, without needing to rewrite or move the underlying datasets. This capability has made it particularly attractive to New Zealand’s growing data science community, where organisations like the Ministry for Business, Innovation and Employment (MBIE) and agricultural cooperatives are leveraging Trino to analyse large-scale datasets without the overhead of ETL pipelines.
The real strength of Trino in this context lies in its ability to handle the “data lake paradox”—the tension between the flexibility of raw data and the need for efficient querying. In New Zealand, where data sovereignty and privacy regulations (such as the Privacy Act 1993 and the upcoming Digital Identity Bill) are increasingly influential, Trino’s open-source nature aligns with a culture that values transparency and control over proprietary data solutions. For example, the University of Auckland’s Data Science Institute has adopted Trino to power its research projects, enabling researchers to query petabytes of climate-related datasets from the National Climate Database without compromising on performance.
One of the most compelling examples of Trino’s impact in New Zealand is its role in the country’s agricultural sector. Dairy farmers and processors are using Trino to analyse real-time sensor data from cows, milking machines, and environmental sensors, enabling them to make data-driven decisions on herd health, feed efficiency, and environmental sustainability. Companies like Fonterra and Fonterra Co-operative Group have integrated Trino into their data infrastructure to process and query data from thousands of farms, reducing operational costs and improving product quality. The result? A significant reduction in manual reporting processes and faster decision-making—critical in a sector where margins are razor-thin.
Yet Trino’s advantages extend beyond agriculture. In the public sector, organisations like the New Zealand Transport Agency (NZTA) have used Trino to analyse traffic data, infrastructure performance, and sustainability metrics from across the country. By querying raw data from multiple sources—including GPS telematics, traffic cameras, and road condition sensors—NZTA has been able to identify inefficiencies in road networks and prioritise maintenance investments more effectively. This has led to measurable improvements in road safety and travel times, with data-driven insights reducing the need for costly retrofits.
The open-source model is also playing a key role in democratising access to advanced analytics in New Zealand. Unlike proprietary solutions that require significant upfront investment, Trino’s community-driven development means that organisations can deploy it with minimal overhead. For instance, small to medium-sized enterprises (SMEs) in sectors like tourism and hospitality—where data-driven decision-making is increasingly critical—have been able to adopt Trino without the need for large IT budgets. This has levelled the playing field, allowing smaller businesses to compete with larger enterprises by leveraging the same powerful query engine.
- Trino processes over 10 million queries per second on datasets exceeding 100 petabytes, with a typical query response time under 100 milliseconds.
- New Zealand’s largest dairy cooperative, Fonterra, reduced manual reporting time by 40% by migrating to Trino for real-time data analysis.
- The University of Auckland’s Data Science Institute uses Trino to query climate datasets from the National Climate Database, enabling research on climate change impacts across Aotearoa.
- NZTA has achieved a 25% reduction in road maintenance costs by using Trino to analyse traffic and infrastructure data in real time.
- Trino’s open-source nature aligns with New Zealand’s data sovereignty priorities, reducing reliance on proprietary cloud-based solutions.
While Trino’s adoption in New Zealand is still in its early stages compared to its global footprint, its influence is undeniable. What sets it apart is not just its performance or scalability, but its ability to bridge the gap between raw data and actionable insights—something that resonates deeply with New Zealand’s culture of innovation, sustainability, and community-driven problem-solving. As the country continues to expand its data infrastructure, Trino is poised to become a cornerstone of how organisations across the board turn data into decisions.