Oracle Analytics Cloud and Server Idea Lab

Home› Oracle Analytics› Oracle Analytics Idea Labs› Oracle Analytics Cloud and Server Idea Lab

Categories

Welcome to the Oracle Analytics Community: Please complete your User Profile and upload your Profile Picture

Semantic Modeler - Use of Trino connection (Starburst)

Planned
43
Views
6
Comments
Thomas HYRIEN
Thomas HYRIEN Rank 4 - Community Specialist
edited Sep 25, 2025 10:58AM in Oracle Analytics Cloud and Server Idea Lab

Hello,

We would like to use Trino connections in Semantic Modeler.

Trino Starburst is very useful in the company and we have high expectations for using it in OAC Classic through a subject area.

Thank you

4
Up
4 votes

Planned · Last Updated

Planned CY2025 - Pravin J/Alan L

Comments

  • Pravin Janardanam-Oracle
    Pravin Janardanam-Oracle Mod

    Thank you very much for reaching out and sharing your valuable feedback. Trino connectivity in Semantic Modeler is tentatively scheduled for release in CY 2025.

  • Thomas HYRIEN
    Thomas HYRIEN Rank 4 - Community Specialist

    Hello,

    Trino connectivity in Semantic Modeler is now available.

    But it doesn't work well with the hierarchy : Catalog > Schema > Table

    The level Catalog is missing. So we have several schemas with the name at the same level.

    And the tables are not loading.

  • Pravin Janardanam-Oracle
    Pravin Janardanam-Oracle Mod

    Hi,

    Does the physical layer of the semantic model under the database have a catalog, schema, and table?

    If the table import did not create the catalog, you can manually create the catalog and the schema in the Physical Layer as needed.

  • Thomas HYRIEN
    Thomas HYRIEN Rank 4 - Community Specialist

    Hi, yes but it is very long to create all the tables and all the columns manually… Why the metadatas are not loading ?

  • Pravin Janardanam-Oracle
    Pravin Janardanam-Oracle Mod

    Is the import working and only the catalog missing or the objects are not loading at all when you expand the connection for import?

    For the first case, follow these steps..

    Lets say, after import, you have Schema —> 100s of Tables directly under Physical Database.

    Now you want the path to be CAT1 —> Schema —> 100s of Tables.

    Step 1: Create the Catalog CAT1
    Step 2: Cut the schema and paste on CAT1

    No need to create tables manually.

  • Thomas HYRIEN
    Thomas HYRIEN Rank 4 - Community Specialist

    When I expand my trino connection, I have directly the list of the schemas and not the catalogs.

    Import is not working because I can't expand the tables under the schemas.