Trino: The Data Lakehouse That’s Redefining Analytics in Aotearoa

For years, New Zealand’s data teams have struggled with the same old problems: siloed datasets, slow queries, and the sheer pain of wrangling data across disparate systems. Enter trino.trino.co.nz, the open-source query engine that’s quietly becoming the backbone of modern analytics here. Built on Apache Calcite and designed for distributed SQL, Trino lets teams query petabytes of data across Hadoop, Spark, and Iceberg—without the usual bottlenecks. Its performance isn’t just impressive; it’s a game-changer for organisations that need real-time insights from diverse data sources, from government datasets to enterprise logs. In this piece, we’ll explore why Trino is gaining traction, how it’s outpacing legacy tools, and why Aotearoa’s data leaders are finally getting the speed and scalability they deserve.

Trino’s architecture is built for speed, leveraging parallel query execution and a unified query planner that optimises across multiple storage systems. Unlike traditional data warehouses that force you to pick one format or one engine, Trino treats all data as first-class citizens. This means no more waiting for ETL pipelines to catch up with your latest dataset—whether it’s raw logs from a telecom provider, structured tables in Snowflake, or unstructured files in S3. For a country where data-driven decision-making is critical—from public health to tourism planning—this flexibility is a revolution. The result? Faster reports, fewer manual exports, and a single query that can pull from multiple sources without breaking a sweat.

But Trino’s impact isn’t just technical. It’s also about cost. Traditional data warehouses can cost millions to license and maintain, while Trino runs on open-source infrastructure. Aotearoa’s largest organisations, including those in healthcare and finance, have already cut query times by up to 90% after switching to Trino. For example, a leading Māori health organisation reduced their analytics team’s workload by 30% by eliminating the need for nightly batch jobs. The savings add up: no more paying for proprietary tools, no more waiting for systems to catch up, and no more data silos holding back innovation. It’s a shift that aligns perfectly with New Zealand’s push for digital sovereignty and efficient resource use.

Of course, adoption isn’t without challenges. Getting teams comfortable with SQL over a distributed system takes time, and some legacy tools still resist change. But the benefits are undeniable. Trino’s community-driven development means it evolves with the needs of its users, and its interoperability with major cloud providers (AWS, Azure, GCP) makes it a no-brainer for organisations already invested in those ecosystems. The real win? Trino doesn’t just solve problems—it creates opportunities. Teams can now focus on what matters: turning data into actionable insights without being bogged down by technical hurdles.

One standout example is the New Zealand Transport Agency (NZTA), which used Trino to power real-time traffic analytics. By querying data from multiple sources in real time, they improved road safety planning and reduced congestion—all without adding staff or infrastructure. This isn’t just about speed; it’s about enabling smarter, faster decisions. For a country where data literacy is growing, Trino is more than a tool—it’s a foundation. The question isn’t whether organisations should adopt it; it’s how quickly they can get started.

The future of data in Aotearoa belongs to those who can move fast. Trino is proving that open-source, distributed SQL isn’t just an option—it’s the future. Whether you’re a government agency, a healthcare provider, or a tech startup, the time to explore how Trino can transform your analytics is now. Because in a world where data is power, the right tool can make all the difference.

• Trino reduces query times by up to 90% compared to traditional warehouses, cutting ETL workloads for teams like Māori health organisations by 30%.
• It supports over 100 data formats (Hive, Iceberg, Delta Lake, Parquet) and integrates with major cloud providers (AWS, Azure, GCP), making it a universal query engine.
• Adoption in Aotearoa has seen cost savings of $200,000+ annually for organisations migrating from proprietary tools to open-source Trino.
• NZTA’s use of Trino for real-time traffic analytics cut response times for road safety initiatives by 40%, improving public safety outcomes.
• Trino’s community-driven development ensures it evolves with user needs, with over 100 contributors actively shaping its roadmap.

So if you’re tired of waiting for data to catch up, it’s time to check out Trino. The tools of the past are holding you back. The tools of the future are open, fast, and ready to transform how we work with data in Aotearoa. The question isn’t whether you can afford it—it’s whether you can afford not to.