nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

Oracle Communities

Oracle AI and Analytics

Child Item

Semantic Modeler - Use of Trino connection (Starburst)

Thomas HYRIEN

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

Find more posts tagged with

Delivered

Status: Delivered

Comments

Pravin Janardanam-Oracle

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

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

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

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

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

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.

Pravin Janardanam-Oracle

Is the Catalog specified in the connection?

Top Leaders

Top Ideas

Ability to disable the header row in tables and pivot tables
I am creating two tables in a freeform report and overlaying these tables to appear as one to the end user. I can hide the header titles by setting the font and highlight colour to the same as the background colour but it would be better if there was a functionality to disable the header row completely.
Ability to list the members/users of a custom role from the OAC -> Console-> Roles and Permissions
My organization needs a practical way to generate a comprehensive report listing all members—including both direct and inherited assignments—of every custom application role within the Oracle Analytics Cloud (OAC) Console’s Roles and Permissions area. Today, the only built‑in method is exporting one role at a time through…
Ability to fix the width of table columns to a set value
Currently you are able to change the width of a field in a table or pivot table by dragging the border but there is no option to manually fix it to a set value e.g. 100px. Justification: I am creating a report with two tables in freeform and need the field widths to have the same size when I overlay one table on the other.…
Allow Selection Steps in OAC Classic Analysis Reports to Support CASE Logic Conditions.
Request for an enhancement to Oracle Analytics Cloud (OAC) Classic Analysis Selection Steps on measure suppression for a specific calculated member created through Selection Steps. This idea is opened based on the directions from oracle CEAL team, for more details please find the below service request. SR -…
REST API for OAC App Roles
Hi, We use a lot of Custom App Roles in OAC Console and It would be easier to have an API to manage the members of App Roles.