61: Trino powers business intelligence

Introduction

Patrick Pichler from Creative Data joins us to talk about his open source driver for the interactive data visualization software product suite Power BI from Microsoft.

Video

• Introduction and Trino Fest recap (0.0s)
• Trino releases 449 and 450 (122.0s)
• Guest Patrick Pichler (399.0s)
• Creative Data overview (552.0s)
• Power BI overview (689.0s)
• Patrick encountering Trino and creating the PowerBI Trino connector (898.0s)
• Import and direct query modes (1300.0s)
• Demo (1595.0s)
• Call for users to participate and next steps (3225.0s)
• Announcement of Trino Fest 2024 (3633.0s)

Audio

Hosts

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

Guest

• Patrick Pichler, Owner and co-founder at Creative Data

Releases and news

Trino 449

• Add OpenLineage event listener.
• Add support for views when using the Iceberg REST catalog.
• Improve write performance for Parquet files in Hive, Iceberg, and Delta Lake connector.
• Improve equality delete performance in Iceberg connector.

Trino 450

• Improve performance for the first_value(), last_value(), date_trunc(), date_add(), and date_diff() functions.
• Add support for concurrent UPDATE, MERGE, and DELETE queries in Delta Lake connector.
• Add support for reading UniForm tables in Iceberg connector.
• Add support for TRUNCATE in Iceberg and Memory connector.
• Automatically configure BigQuery scan parallelism.

First recap from Trino Fest 2024

Cole and Manfred chat a bit about Trino Fest last week, mentioning that all videos are now available, and a blog post with slides and more material is coming as well.

Impression from Trino Contributor Congregation

Manfred and Dain lead the discussions in the congregation. We are excited about a lot of the follow ups for the project and increased collaboration and innovation.

Guest Patrick Pichler

Patrick specializes in providing guidance, designing, and implementing sustainable data, analytics and AI solutions utilizing open architectures at Creative Data. He has a long history of working in the data and data platform space as user, developer, administrator, manager, consultant, and educator.

PowerBI overview

Power BI is an interactive data visualization software product suite developed by Microsoft with a primary focus on business intelligence. We talk about the different available products and features, and their usage in the community.

Trino client support options for Power BI

Typically, Power BI relies on ODBC drivers for connecting to specific data sources. Since there is no open source Trino ODBC driver however, Patrick and other clever developers have created a Power BI client that connects to Trino directly via the client REST API - the PowerBITrinoConnector. We discuss the details and limitation of both approaches, look at the source code, and learn about import and direct query modes.

Demo

Patrick showcases how to install and use the connector in his demo of Trino and Power BI.

Rounding out

Trino Summit 2024 is coming on the 11th and 12th of December, and registration is open now.

If you want to learn more about Trino, check out 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.