58: Understanding your users with Trino and Mitzu

Introduction

István Mészáros from Mitzu joins us to talk about using Mitzu with Trino. Mitzu is a warehouse-native product analytics platform that revolutionizes how companies leverage their product usage data in the data lake.

Video

• Introduction: Episode 58: Understanding your users with Trino and Mitzu (0.0s)
• Releases: Trino 442, 443, and 444 (76.0s)
• Trino Gateway: Version 7 and Starburst Trino Champion Peng Wei (323.0s)
• Starburst Trino Tamas Cservenak: For all the Apache Maven help (369.0s)
• Introduction of István Mészáros: Founder and CEO of Mitzu (492.0s)
• Mitzu introduction and logo: (575.0s)
• High level overview : Mitzu and warehouse-native product analytics (636.0s)
• What products and what source data? (724.0s)
• More about events, users, and sessions (810.0s)
• Mitzu use cases, personas, and difference to BI tools (930.0s)
• Common and supported event data structures (1030.0s)
• What does Mitzu do after connecting: Start of demo with Starburst Galaxy and Mitzu (1218.0s)
• Warehouse-native - no data copying necessary (1410.0s)
• How Mitzu works with Trino (1518.0s)
• Initial configuration (1603.0s)
• Segmentation, funnle, and retention (1733.0s)
• SQL query generation: Optimizations and Trino performance benefits (1984.0s)
• Mitzu as cloud-based SaaS application (2257.0s)
• Connection demo (2391.0s)
• Practical experience with customers : And Mitzu compared to other solutions (2579.0s)
• Sharing insights with dashboards (2723.0s)
• Conclusion about Mitzu (3166.0s)
• Rounding out with Trino Fest and other events (3230.0s)

Audio

Hosts

• Cole Bowden, Developer Advocate at Starburst
• Manfred Moser, Director of Trino Community Leadership at Starburst, (@simpligility)

Guests

• István Mészáros, Founder and CEO of Mitzu

Trino releases

Trino 442

• Add support for configuring AWS deployment type in OpenSearch connector.
• Fix a regression from 440 in Iceberg connector.

Trino 443

• Ensure all files are deleted when native S3 file system support is enabled, and some other object storage connector improvements.
• Add support for a custom authorization header name in Prometheus connector.

Trino 444

• Update Docker image to use Java 22 for runtime.
• Numerous performance improvements for the Snowflake connector.
• Add support for reading BYTE_STREAM_SPLIT encoding in Parquet files.
• Add support for canned access control lists with the native S3 file system.

Other Trino news

• Trino Gateway 7 shipped with a new user interface thanks to a contribution from our new Starburst Trino champion Peng Wei
• Status of the continuous integration and build setup with Apache Maven improved a lot thanks to our collaboration with the new Starburst Trino champion Tamas Cservenak
• Trino Contributor Call recap is now available

Mitzu

Mitzu is a warehouse-native product analytics platform that revolutionizes how companies leverage their product usage data in the data lake.

By directly connecting to Trino, Mitzu eliminates the need for traditional reverse ETL processes to 3rd party applications such as Amplitude or Mixpanel. Mitzu enables real-time self-served product analytics on top of the existing data infrastructure with generated SQL queries.

In our conversation and demo session with István we cover all the following aspects and a few other topics:

• What is product analytics?
• Discuss some key terms, such as segmentation, funnels, and retention, and discuss what insights and benefit become available.
• What are some example use cases?
• What kind of products can be analyzed?
• Use of Mitzu for marketing.
• What other product analytics tools exist, and what sets Mitzu apart?
• How is Trino involved to make Mitzu warehouse-native?
• What are the advantages of being warehouse-native? What does that mean?
• Compare with Mitzu on other data platforms.
• Implementation details of the Mitzu and Trino integration, such as connectors, security, and client libraries
• How to use Mitzu in terms of deployment and configuration.
• Cool features of Mitzu.
• Practical experience and customers.

Rounding out

Trino Fest news:

• Speakers are selected, contact and announcement coming soon
• Register now, and book travel and hotel.
• Contact us to join the Trino Contributor Congregation the next day

Other news and events:

• Manfred will attend Open Source Summit NA, and present a Big Data Whirlwind Tour at the inaugural Data Engineer Things meeting in Seattle.
• Trino Contributor Call is now planned as monthly event with video recordings.
• Check out the upcoming Trino Community Broadcast episode about jOOQ.

If you want to learn more about Trino, get the definitive guide from O’Reilly. You can get the free PDF from Starburst or buy the English, Polish, Chinese, or Japanese edition.

Music for the show is from the Megaman 6 Game Play album by Krzysztof Slowikowski.