About the Lakehouse Module

Query Editor Page

The The "Query Editor" page icon is a cloud with a arrow to the bottom. Query Editor page allows visualizing and managing data from SQL commands based on Trino functions.

By default, the Query Editor page opens when you click the The "Lakehouse" module icon is a Datalake. Lakehouse module.

  • To have access to this Data Query Editor, your Saagie instance must be have Lakehouse enabled and configured by your administrator during the configuration of the Saagie installer, saagiectl. They must have answered the prompt to use Lakehouse when configuring your cluster settings.

  • To run SQL queries on a catalog, you must have at least one role granted on this Lakehouse Catalog. For more information, see Lakehouse Catalog Access Rights.

By default, on a Saagie installation, the following catalogs are available:

  • hive

  • iceberg

  • postgresql

  • tpch

  • tpcds

  • system

Dynamic management of catalogs

You can add or remove catalogs dynamically through Trino commands.
See :

This Trino features can be used only by users who have the trino-admin role.
In more, this features are considering like experimental by Trino team.

Overview of the Query Editor Page

The Query Editor page displays a complete SQL editor.

  • On the left side, you can see the list of available catalogs and schemas.

  • On the right side, you can write and run your SQL queries.

  • On the bottom, you can see the query result.

  • On the top, in more of tabs, you can see many buttons:

    • to save current query

    • to access queries historic

    • to access Trino cluster monitoring

    • to run/stop the query

    • to display a help panel about Trino functions

lakehouse editor queries v2
Figure 1. The Query Editor page provides a complete SQL editor.
1 – Tabs

You can open multiple tabs for different queries. You can also open a new tab using the button + To close a tab, click on the cross next to its name.

  • You can open maximum 10 tabs per user.

  • You can save each queries in the tabs.

  • Queries has been saved automatically in the current tab every time you change it to prevent losing them.

2 - Help panel on Trino functions

This panel gives you all the information about Trino functions. It’s useful if you want to know how to use a function or what it does exactly.
To open this panel, click on the book mark icon. To close it, click again on the same icon.

3 - Search bar of help panel

You can search directly into the help panel. Just type something in the search bar to filter results.

4 - List of Trino functions

Here you can find all the Trino functions that you can use in your queries.
Click on any function to get more details about it.