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 have the Lakehouse enabled and configured.

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

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, you can see many buttons:

    • to save current query

    • to access queries historic

    • to access Trino cluster monitoring

    • to run the query

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